APPS.BIV_DBI_COLLECTION_INIT dependencies on JTF_TASK_REFERENCES_B

Line 221: , jtf_task_references_b trf

217: 'N'
218: END de_escalated_same_day
219: from
220: jtf_tasks_b tsk
221: , jtf_task_references_b trf
222: where
223: trf.object_type_code = 'SR'
224: and trf.reference_code = 'ESC'
225: and tsk.task_type_id = 22

Line 228: from jtf_task_references_b

224: and trf.reference_code = 'ESC'
225: and tsk.task_type_id = 22
226: and tsk.task_id = trf.task_id
227: and tsk.task_id in (select task_id from (select min(task_id)task_id, object_id
228: from jtf_task_references_b
229: where reference_code = 'ESC'
230: and object_type_code = 'SR'
231: group by object_id));
232: