The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
INTO num_active
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;
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;