APPS.JTF_EC_REFERENCES_PVT dependencies on JTF_EC_PUB

Line 322: AND tasks.task_type_id = jtf_ec_pub.g_escalation_type_id

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
324: AND reference.object_id = p_object_id
325: AND tasks.task_status_id = status.task_status_id
326: AND status.closed_flag = 'Y';