DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on PO_VENDOR_CONTACTS

Line 2219: FROM po_vendor_contacts pvc,

2215: AND hz1.party_name = p_contact_name;
2216:
2217: CURSOR vendor_party_contact_csr IS
2218: SELECT 1
2219: FROM po_vendor_contacts pvc,
2220: Po_vendor_sites_all pvs
2221: WHERE pvs.vendor_id = p_party_id
2222: AND pvc.vendor_site_id = pvs.vendor_site_id
2223: AND pvc.vendor_contact_id = p_contact_id;

Line 6156: FROM po_vendor_contacts pvc

6152: AND party_role_code = G_PARTY_ROLE_SUPPLIER;
6153:
6154: CURSOR vendor_email_csr(l_contact_id NUMBER) IS
6155: SELECT email_address
6156: FROM po_vendor_contacts pvc
6157: WHERE pvc.vendor_contact_id = l_contact_id;
6158:
6159: BEGIN
6160: