select t.case_id, t.workflow_key, t.transition_key, c.object_id, wcti.access_privilege from wf_tasks t, wf_cases c, wf_context_transition_info wcti where wcti.context_key = c.context_key and wcti.workflow_key = t.workflow_key and wcti.transition_key = t.transition_key and c.case_id = t.case_id and t.task_id = :task_id insert into wf_case_assignments (case_id, transition_key, workflow_key, party_id) select :case_id, :transition_key, :workflow_key, ta.party_id from wf_task_assignments ta where task_id = :task_id and not exists (select 1 from wf_case_assignments ca where ca.party_id = ta.party_id and ca.workflow_key = :workflow_key and ca.case_id = :case_id and ca.transition_key = :transition_key) delete from wf_case_assignments where workflow_key = :workflow_key and case_id = :case_id and transition_key = :transition_key and party_id = :user_id delete from wf_task_assignments where party_id = :user_id and task_id = :task_id