oracle8.1.6 begin bt_project.keywords_delete(:package_id, 'f'); end; select acs_object.name(party_id) from parties where party_id = :filter_assignee content_keyword.is_assigned(b.bug_id, $keyword_id, 'none') = 't' begin bt_project.del(:project_id); end; begin bt_project.new(:project_id); end; select acs_object.name(p.party_id) || ' (' || p.email || ')' as label, party_id from parties p where party_id in (select distinct(party_id) from workflow_case_role_party_map, workflow_cases where workflow_case_role_party_map.case_id = workflow_cases.case_id and workflow_cases.workflow_id = :workflow_id)