DBA Data[Home] [Help]

APPS.BIV_DBI_COLLECTION_INC dependencies on JTF_TASKS_B

Line 25: jtf_tasks_b tsk

21: trf.object_id incident_id
22: , tsk.actual_start_date escalated_date_from
23: , nvl(tsk.actual_end_date,p_collect_to_date+1) escalated_date_to
24: from
25: jtf_tasks_b tsk
26: , jtf_task_references_b trf
27: where
28: trf.object_type_code = 'SR'
29: and trf.reference_code = 'ESC'

Line 1495: jtf_tasks_b tsk, jtf_task_references_b trf

1491: ELSE
1492: 'N'
1493: END de_escalated_same_day
1494: from
1495: jtf_tasks_b tsk, jtf_task_references_b trf
1496: where trf.object_type_code = 'SR'
1497: and trf.reference_code = 'ESC'
1498: and tsk.task_type_id = 22
1499: and trf.task_id = tsk.task_id