oracle8.1.6 select k.transition_key, k.task_id, t.transition_name, k.holding_user, content_workflow.get_holding_user_name(k.task_id) hold_name from wf_tasks k, wf_transitions t where k.case_id = :case_id and k.state in ('enabled', 'started') and k.transition_key = t.transition_key select to_char(deadline, 'DD MON') deadline from wf_case_deadlines where case_id = :case_id and transition_key = :transition_key