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)