APPS.POS_SUPPLIER_CONTACT_BO_PKG dependencies on AP_SUPPLIERS

Line 114: ap_suppliers ap,

110:
111: BULK COLLECT
112: INTO x_ap_supplier_contact_bo
113: FROM ap_supplier_contacts apsc,
114: ap_suppliers ap,
115: ap_supplier_sites_all sa
116: WHERE ap.party_id = l_party_id
117: AND sa.vendor_id = ap.vendor_id
118: AND apsc.vendor_site_id = sa.vendor_site_id;

Line 346: FROM ap_suppliers supp

342: IF (p_vendor_contact_rec.vendor_id IS NULL) THEN
343: BEGIN
344: SELECT vendor_id
345: INTO p_vendor_contact_rec.vendor_id
346: FROM ap_suppliers supp
347: WHERE supp.party_id = l_party_id;
348:
349: EXCEPTION
350: WHEN OTHERS THEN