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