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