The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT vendor_id,
org_id
INTO l_vendor_id,
l_org_id
FROM PO_VENDOR_SITES
WHERE selling_company_identifier = p_selling_co_id
AND rownum = 1;
SELECT invoice_num
INTO l_dup_invoices
FROM AP_INVOICES_ALL
WHERE invoice_num = p_invoice_num
AND vendor_id = l_vendor_id
AND org_id = l_org_id;
SELECT invoice_num
INTO l_dup_interface
FROM AP_INVOICES_INTERFACE
WHERE invoice_num = p_invoice_num
AND vendor_id = l_vendor_id
AND status <> 'PROCESSED'
AND rownum = 1;
SELECT invoice_num
INTO l_dup_history
FROM AP_HISTORY_INVOICES_ALL
WHERE invoice_num = p_invoice_num
AND vendor_id = l_vendor_id
AND org_id = l_org_id;
Select default_pay_site_id
Into l_alt_site_id
From PO_VENDOR_SITES_ALL
Where vendor_site_id = p_site_id; --Bug 3628373
SELECT NVL(gapless_inv_num_flag, 'N'), /* Bug 5197828 */
selling_company_identifier
INTO x_gapless_inv_num_flag,
x_selling_company_id
FROM PO_VENDOR_SITES_ALL
WHERE vendor_site_id = l_source_site_id;