APPS.POS_AP_SUPPLIER_SITE_BO_PKG dependencies on AP_SUPPLIERS

Line 441: ap_suppliers ap,

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
445: AND aps.terms_id = terms.term_id(+); -- Bug 12979867/16067074: OUTER Join ap_terms to get term's name

Line 617: FROM ap_suppliers supp

613: IF (vendor_site_rec.vendor_id IS NULL) THEN
614: BEGIN
615: SELECT vendor_id
616: INTO vendor_site_rec.vendor_id
617: FROM ap_suppliers supp
618: WHERE supp.party_id = l_party_id;
619:
620: EXCEPTION
621: WHEN OTHERS THEN