postgresql7.2 select m.party_id, p.email, acs_object__name(m.party_id) as name from workflow_case_role_party_map m, parties p where m.case_id = :case_id and m.role_id = :role_id and p.party_id = m.party_id select acs_object__name(:object_id) as name select distinct acs_object__name(p.party_id) || ' (' || p.email || ')' as label, p.party_id from [ad_decode $subquery "" "cc_users" $subquery] p where upper(coalesce(acs_object__name(p.party_id) || ' ', '') || p.email) like upper('%'||:value||'%') order by label select acs_object__name(p.party_id) || ' (' || p.email || ')' as label, p.party_id from parties p where p.party_id in ([join $party_id_list ", "]) order by label select workflow_case_pkg__delete(:case_id) insert into workflow_case_enabled_actions (enabled_action_id, case_id, action_id, parent_enabled_action_id, assigned_p, execution_time) select :enabled_action_id, :case_id, :action_id, :parent_enabled_action_id, :db_assigned_p, current_timestamp + a.timeout from workflow_actions a where a.action_id = :action_id