oracle8.1.6 select r.role_key, r.role_name, p.party_id, acs_object.name(p.party_id) as party_name, p.email as party_email, '' as user_select_widget, '' as add_export_vars, '' as remove_url from wf_roles r, wf_context_assignments ca, parties p where r.workflow_key = :workflow_key and ca.context_key (+) = :context_key and ca.role_key (+) = r.role_key and p.party_id (+) = ca.party_id order by r.sort_order, r.role_key select p.party_id as sel_party_id, acs_object.name(p.party_id) as sel_name, p.email as sel_email from parties p where p.party_id not in (select ca.party_id from wf_context_assignments ca where ca.workflow_key = :workflow_key and ca.context_key = :context_key and ca.role_key = :role_key)