oracle8.1.7
select state_id
from workflow_fsm_states
where workflow_id = :workflow_id
order by sort_order
limit 1
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