DBA Data[Home] [Help]

APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_PARTY_ALL_CONTACTS_V

Line 780: jtf_party_all_contacts_v p

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'
784: AND ct.contact_id IN (p.subject_party_id, p.party_id);