The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_site_sel VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';
l_contact_sel VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';
SELECT count(1)
INTO l_check_vid
FROM ap_suppliers
WHERE vendor_id = i_vendor_id;
SELECT count(1)
INTO l_check_vsid
FROM ap_supplier_sites_all
WHERE vendor_id = i_vendor_id
AND vendor_site_id = i_vendor_site_id;
SELECT count(1)
INTO l_check_vcid
FROM po_vendor_contacts
WHERE vendor_id = i_vendor_id
AND vendor_site_id = i_vendor_site_id
AND vendor_contact_id = i_vendor_contact_id;
SELECT count(1)
INTO l_check_vcid
FROM po_vendor_contacts
WHERE vendor_id = i_vendor_id
AND vendor_contact_id = i_vendor_contact_id;
|| 'SELECT vendor_site_id '
|| 'FROM PO_VENDOR_CONTACTS '
|| 'WHERE vendor_contact_id = '
|| to_char( i_vendor_contact_id ) || ' )' ;
SELECT *
INTO o_supplier_info.supp_rec
FROM ap_suppliers
WHERE vendor_id = i_vendor_id;
l_contact_tab.DELETE;
l_site_tab.DELETE;
SELECT *
FROM ap_suppliers
WHERE vendor_id BETWEEN i_from_vendor_id AND i_to_vendor_id;
l_site_sel VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';
l_contact_sel VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';
SELECT count(1)
INTO l_check_vid
FROM ap_suppliers
WHERE vendor_id BETWEEN i_from_vendor_id AND i_to_vendor_id;
l_contact_tab.DELETE;
l_site_tab.DELETE;
l_supplier_tab.DELETE;