DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on JTF_TASK_STATUSES_B

Line 351: jtf_task_statuses_b jts

347: AND ced.original_source_code = 'SR'
348: AND ced.interface_to_oe_flag = 'Y'
349: AND ciab.incident_id NOT IN (SELECT jtv.source_object_id
350: FROM jtf_tasks_vl jtv,
351: jtf_task_statuses_b jts
352: -- jtf_task_assignments jta,
353: -- csf_debrief_headers cdh
354: WHERE jtv.source_object_id = ciab.incident_id
355: -- AND jta.task_id = jtv.task_id

Line 393: jtf_task_statuses_b jts,

389: AND ced.original_source_code = 'SR'
390: AND ced.interface_to_oe_flag = 'Y'
391: AND ciab.incident_id IN (SELECT jtv.source_object_id
392: FROM jtf_tasks_vl jtv,
393: jtf_task_statuses_b jts,
394: jtf_task_assignments jta,
395: csf_debrief_headers cdh
396: WHERE jtv.source_object_id = ciab.incident_id
397: AND jta.task_id = jtv.task_id