APPS.PO_VENDORS_AP_PKG dependencies on AP_SUPPLIER_SITES

Line 19: FROM ap_supplier_sites pvs

15:
16:
17: SELECT count(*)
18: INTO num_active
19: FROM ap_supplier_sites pvs
20: WHERE pvs.vendor_id = X_vendor_id
21: AND (( X_ORG_ID IS NOT NULL AND
22: pvs.org_id = X_ORG_ID)
23: OR X_ORG_ID IS NULL)

Line 50: FROM ap_supplier_sites pvs

46:
47:
48: SELECT count(*)
49: INTO num_inactive
50: FROM ap_supplier_sites pvs
51: WHERE pvs.vendor_id = X_vendor_id
52: AND (( X_ORG_ID IS NOT NULL AND
53: pvs.org_id = X_ORG_ID)
54: OR X_ORG_ID IS NULL)