APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_TASK_CONTACTS

Line 757: FROM jtf_task_contacts

753: -- All employee contacts that should be notified
754: -------------------------------------------------------------------------
755: Cursor c_emp_contacts Is
756: SELECT contact_id
757: FROM jtf_task_contacts
758: WHERE task_id = p_task_id
759: AND contact_type_code = 'EMP'
760: AND nvl(escalation_notify_flag, 'N') = 'Y';
761:

Line 779: FROM jtf_task_contacts ct,

775:
776: cursor c_ext_contact_details is
777: SELECT ct.contact_id,
778: p.subject_party_name contact_name
779: FROM jtf_task_contacts ct,
780: jtf_party_all_contacts_v p
781: WHERE ct.task_id = p_task_id
782: AND NVL(ct.escalation_notify_flag, 'N') = 'Y'
783: AND ct.contact_type_code ='CUST'