DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 348: -- jtf_task_assignments jta,

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

Line 389: jtf_task_assignments jta,

385: AND ced.interface_to_oe_flag = 'Y'
386: AND ciab.incident_id IN (SELECT jtv.source_object_id
387: FROM jtf_tasks_vl jtv,
388: jtf_task_statuses_b jts,
389: jtf_task_assignments jta,
390: csf_debrief_headers cdh
391: WHERE jtv.source_object_id = ciab.incident_id
392: AND jta.task_id = jtv.task_id
393: AND jtv.source_object_type_code = 'SR'