27: source_object_id ,
28: open_flag ,
29: last_updated_by,
30: last_update_login
31: FROM jtf_tasks_b
32: WHERE task_id = l_task_id;
33:
34: c_sr_task_sr_closure_rec c_sr_task_sr_closure_csr%ROWTYPE;
35:
230: a.task_id = l_task_id;
231:
232: CURSOR cs_sr_get_task_owner_id_csr IS
233: SELECT b.source_id
234: FROM jtf_tasks_b a, jtf_rs_resource_extns b
235: WHERE a.owner_id = b.resource_id(+) AND
236: a.task_id = l_task_id;
237:
238: BEGIN