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