APPS.CSL_JTF_TASK_REFS_ACC_PKG dependencies on JTF_TASKS_B

Line 18: FROM jtf_tasks_b jtb,

14: IS
15: PRAGMA AUTONOMOUS_TRANSACTION;
16: CURSOR c_esc(b_task_id NUMBER, b_resource_id NUMBER, b_last_run_date DATE ) IS
17: SELECT jtr.task_reference_id
18: FROM jtf_tasks_b jtb,
19: jtf_task_references_b jtr,
20: jtf_task_statuses_b jts
21: WHERE jtb.task_id = jtr.task_id
22: AND jtb.task_type_id = 22

Line 165: FROM jtf_tasks_b jtb,

161: FROM jtm_jtf_task_references_acc
162: WHERE resource_id = b_resource_id
163: AND task_reference_id NOT IN(
164: SELECT jtr.task_reference_id
165: FROM jtf_tasks_b jtb,
166: jtf_task_references_b jtr,
167: jtf_task_statuses_b jts
168: WHERE jtb.task_id = jtr.task_id
169: AND jtb.task_type_id = 22