DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1656: FROM po_vendor_sites_all

1652: AND party_site_id = p_location_id;
1653:
1654: CURSOR vendor_location_valid_csr IS
1655: SELECT 1
1656: FROM po_vendor_sites_all
1657: WHERE vendor_id = p_party_id
1658: AND vendor_site_id = p_location_id;
1659:
1660: BEGIN

Line 2478: Po_vendor_sites_all pvs

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