select creation_user from acs_objects where object_id = :object_id select party_id from workflow_role_default_parties where role_id = :role_id select m.party_id from workflow_case_role_party_map m, workflow_cases c where m.role_id = :role_id and m.case_id = c.case_id and c.workflow_id = (select workflow_id from workflow_cases where case_id = :case_id) cc_users