DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1398: FROM po_vendor_sites_all

1394: AND party_site_id = p_location_id;
1395:
1396: CURSOR vendor_location_valid_csr IS
1397: SELECT 1
1398: FROM po_vendor_sites_all
1399: WHERE vendor_id = p_party_id
1400: AND vendor_site_id = p_location_id;
1401:
1402: BEGIN

Line 2220: Po_vendor_sites_all pvs

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;
2224: