APPS.POS_AP_INVOICE_PAYMENTS_PKG SQL Statements

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

Line: 28

    SELECT ac.check_number,
           ac.check_id,
           ac.check_date,
           ai.invoice_num,
           ai.invoice_id,
           aip.accounting_date,
           aip.invoice_payment_type,
           alc1.displayed_field,
           ac.payment_method_lookup_code,
           alc2.displayed_field
    FROM   ap_invoice_payments_all aip, --ap_invoice_payments
           ap_checks_all           ac,  --ap_checks
           ap_invoices_all         ai,  --ap_invoices
           ap_lookup_codes     alc1,
           ap_lookup_codes     alc2
    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    alc1.lookup_type     = 'NLS TRANSLATION'
    AND    alc1.lookup_code     = 'PREPAY'
    AND    alc2.lookup_type     = 'PAYMENT METHOD'
    AND    alc2.lookup_code     = ac.payment_method_lookup_code;