APPS.AP_PAYMENT_EVENT_WF_PKG SQL Statements

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

Line: 41

        SELECT  ''||invoice_num||
                ''||fnd_date.date_to_chardate(dateval=>ai.invoice_date,
		                     calendar_aware=>l_calendar_unaware)||
                ''||to_char(aip.discount_taken)||
                ''||to_char(aip.amount)||''
        FROM    ap_invoice_payments aip, ap_invoices ai
        WHERE   aip.check_id = l_check_id
        AND     ai.invoice_id = aip.invoice_id
        ORDER BY invoice_num;

Line: 78

     SELECT check_number,
            fnd_date.date_to_chardate(dateval=>check_date,calendar_aware=>l_calendar_unaware),
            currency_code,
            amount
     INTO   l_check_number,
            l_check_date,
            l_currency_code,
            l_payment_amount
     FROM   ap_checks
     WHERE  check_id = l_check_id;

Line: 223

    SELECT vendor_id,
           vendor_site_id
    INTO   l_vendor_id,
           l_vendor_site_id
    FROM   ap_checks
    WHERE  check_id = p_check_id;

Line: 232

    SELECT remit_advice_email
    INTO   p_email_address
    FROM   IBY_EXTERNAL_PAYEES_ALL
    WHERE  supplier_site_id = l_vendor_site_id;

Line: 251

    SELECT status_lookup_code
    INTO   p_check_status
    FROM   ap_checks
    WHERE  check_id = p_check_id;