DBA Data[Home] [Help]

APPS.JTF_EC_REFERENCES_PVT dependencies on JTF_TASK_STATUSES_VL

Line 319: jtf_task_statuses_vl status

315: SELECT 1
316: INTO x
317: FROM jtf_tasks_vl tasks,
318: jtf_task_references_vl reference,
319: jtf_task_statuses_vl status
320: WHERE reference.task_reference_id <> p_escalation_reference_id
321: AND tasks.task_id = reference.task_id
322: AND tasks.task_type_id = jtf_ec_pub.g_escalation_type_id
323: AND reference.object_type_code = p_object_type_code