The following lines contain the word 'select', 'insert', 'update' or 'delete':
UPDATE po_headers
SET vendor_id = p_new_vendor_id,
vendor_site_id = p_new_vendor_site_id,
last_update_date = SYSDATE,
last_update_login = FND_GLOBAL.login_id,
last_updated_by = FND_GLOBAL.user_id
WHERE vendor_id = p_old_vendor_id
AND vendor_site_id = p_old_vendor_site_id
AND segment1 IN (SELECT cc_num
FROM igc_cc_headers
WHERE org_id = g_org_id
AND vendor_id = p_old_vendor_id
AND vendor_site_id = p_old_vendor_site_id);
UPDATE igc_cc_headers
SET vendor_id = p_new_vendor_id,
vendor_site_id = p_new_vendor_site_id,
last_update_date = SYSDATE,
last_update_login = FND_GLOBAL.login_id,
last_updated_by = FND_GLOBAL.user_id
WHERE vendor_id = p_old_vendor_id
AND vendor_site_id = p_old_vendor_site_id
AND org_id = g_org_id;