APPS.POS_AP_SUPPLIER_SITE_BO_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 440: FROM ap_supplier_sites_all aps,

436: aps.vendor_site_id,
437: --end of Bug 15992883
438: 'SUPP_ADDR_SITE_LEVEL')) BULK COLLECT
439: INTO x_ap_supplier_sites_bo
440: FROM ap_supplier_sites_all aps,
441: ap_suppliers ap,
442: ap_terms terms
443: WHERE ap.party_id = l_party_id
444: AND aps.vendor_id = ap.vendor_id

Line 550: FROM ap_supplier_sites_all

546: /* BEGIN
547:
548: SELECT 1
549: INTO v_row_exists
550: FROM ap_supplier_sites_all
551: WHERE vendor_id = p_vendor_site_rec.vendor_id
552: AND rownum < 2;
553: EXCEPTION
554: WHEN OTHERS THEN