APPS.AP_INVOICE_PAYMENTS_PKG SQL Statements

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

Line: 27

    SELECT ac.check_number,
	   ac.check_id,
	   ac.check_date,
	   ai.invoice_num,
	   ai.invoice_id,
	   aip.accounting_date,
	   aip.invoice_payment_type,
	   iby.payment_method_name, --4552701
	   ac.payment_method_code, --4552701
	   iby.payment_method_name
    FROM   ap_invoice_payments_all aip,
	   ap_checks_all           ac,
	   ap_invoices_all       ai,
	   iby_payment_methods_vl iby
    WHERE  aip.invoice_id       = l_invoice_id
    AND    aip.payment_num      = l_payment_num
    AND    aip.check_id         = ac.check_id
    AND    aip.other_invoice_id = ai.invoice_id (+)
    AND    iby.payment_method_code     = ac.payment_method_code;

Line: 98

	    	SELECT displayed_field
	     	INTO   l_paid_by
	     	FROM   ap_lookup_codes
	     	WHERE  lookup_type = 'NLS TRANSLATION'
	     	AND    lookup_code = 'MULTIPLE PAYMENTS';

Line: 292

      SELECT NVL(MAX(accounting_date), SYSDATE-9000)
        INTO gl_date
        FROM ap_invoice_payments_all
       WHERE check_id = l_check_id;