The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT po_vendor_id, vendor_party_id
FROM pos_supplier_registrations
WHERE supplier_reg_id = p_supplier_reg_id;
SELECT pv.vendor_id, pvsa.party_site_id, pvsa.vendor_site_id
FROM po_vendors pv, po_vendor_sites_all pvsa
WHERE pv.vendor_id = pvsa.vendor_id
AND pv.party_id = p_supplier_party_id
AND pvsa.org_id = p_org_id;
SELECT fu.person_party_id
FROM fnd_user fu, pos_supplier_users_v psuv
WHERE fu.user_id = psuv.user_id
AND psuv.vendor_id = x_vendor_id
ORDER BY fu.creation_date;
SELECT contact_party_id
FROM pos_contact_requests pcr
WHERE contact_request_id = p_contact_req_id;