APPS.PO_VENDORS_AP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

         SELECT count(pvs.vendor_site_id)
         INTO   num_active
	     FROM   ap_supplier_sites pvs,
                hz_party_sites H,
                ap_suppliers pv
         WHERE  pvs.vendor_id = X_vendor_id
         AND    (( X_ORG_ID IS NOT NULL AND
                   pvs.org_id = X_ORG_ID)
                   OR X_ORG_ID IS NULL)
         AND    pvs.pay_site_flag = 'Y'
         AND    nvl(pvs.inactive_date, sysdate+1) > sysdate
         AND H.party_site_id (+) = pvs.party_site_id
         AND PV.vendor_id = pvs.vendor_id
         AND DECODE(PV.vendor_type_lookup_code,'EMPLOYEE', 'A',NVL(H.status, 'I')) = ('A')
         GROUP BY pvs.vendor_id;

Line: 55

         SELECT count(*)
         INTO   num_inactive
	 FROM   ap_supplier_sites pvs
         WHERE  pvs.vendor_id = X_vendor_id
         AND    (( X_ORG_ID IS NOT NULL AND
                   pvs.org_id = X_ORG_ID)
                   OR X_ORG_ID IS NULL)
         AND    pvs.pay_site_flag = 'Y'
         AND    nvl(pvs.inactive_date, sysdate+1) < sysdate
         GROUP BY pvs.vendor_id;