DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on PO_VENDOR_CONTACTS

Line 2477: FROM po_vendor_contacts pvc,

2473: AND hz1.party_name = p_contact_name;
2474:
2475: CURSOR vendor_party_contact_csr IS
2476: SELECT 1
2477: FROM po_vendor_contacts pvc,
2478: Po_vendor_sites_all pvs
2479: WHERE pvs.vendor_id = p_party_id
2480: AND pvc.vendor_site_id = pvs.vendor_site_id
2481: AND pvc.vendor_contact_id = p_contact_id;

Line 7039: FROM po_vendor_contacts pvc

7035: AND party_role_code = G_PARTY_ROLE_SUPPLIER;
7036:
7037: CURSOR vendor_email_csr(l_contact_id NUMBER) IS
7038: SELECT email_address
7039: FROM po_vendor_contacts pvc
7040: WHERE pvc.vendor_contact_id = l_contact_id;
7041:
7042: BEGIN
7043: