33: aip.invoice_payment_type,
34: iby.payment_method_name, --4552701
35: ac.payment_method_code, --4552701
36: iby.payment_method_name
37: FROM ap_invoice_payments_all aip,
38: ap_checks_all ac,
39: ap_invoices_all ai,
40: iby_payment_methods_vl iby
41: WHERE aip.invoice_id = l_invoice_id
290: BEGIN
291:
292: SELECT NVL(MAX(accounting_date), SYSDATE-9000)
293: INTO gl_date
294: FROM ap_invoice_payments_all
295: WHERE check_id = l_check_id;
296:
297: RETURN gl_date;
298: