APPS.JTF_TASK_UTL dependencies on JTF_PARTY_ALL_CONTACTS_V

Line 313: from jtf_party_all_contacts_v pc,

309: l_rel_party_id hz_parties.party_id%TYPE;
310:
311: cursor get_party_ids (p_contact_id Number) Is
312: select pc.party_id, pc.subject_party_id
313: from jtf_party_all_contacts_v pc,
314: jtf_task_contacts tc
315: where tc.task_contact_id = p_contact_id
316: and tc.contact_id IN (pc.party_id, pc.subject_party_id);
317:

Line 491: FROM jtf_party_all_contacts_v contacts

487: THEN
488: BEGIN
489: SELECT 1
490: INTO x
491: FROM jtf_party_all_contacts_v contacts
492: WHERE contacts.object_party_id = (SELECT customer_id
493: FROM jtf_tasks_b
494: WHERE task_id = p_task_id)
495: AND p_contact_id in (contacts.subject_party_id, contacts.party_id)