APPS.PO_VENDORS_AP_PKG dependencies on AP_SUPPLIERS

Line 23: ap_suppliers pv

19: SELECT count(pvs.vendor_site_id)
20: INTO num_active
21: FROM ap_supplier_sites pvs,
22: hz_party_sites H,
23: ap_suppliers pv
24: WHERE pvs.vendor_id = X_vendor_id
25: AND (( X_ORG_ID IS NOT NULL AND
26: pvs.org_id = X_ORG_ID)
27: OR X_ORG_ID IS NULL)