APPS.AP_PO_GAPLESS_SBI_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    	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;

Line: 31

	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;

Line: 47

	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;

Line: 66

        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;

Line: 111

	Select default_pay_site_id
  	Into l_alt_site_id
	From PO_VENDOR_SITES_ALL
	Where vendor_site_id = p_site_id;   --Bug 3628373

Line: 121

	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;