11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: type_trans ap_lookup_codes.displayed_field%TYPE,
16: method ap_checks.payment_method_code%TYPE, --4552701
17: method_trans ap_lookup_codes.displayed_field%TYPE);
18:
19: -----------------------------------------------------------------------
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: type_trans ap_lookup_codes.displayed_field%TYPE,
16: method ap_checks.payment_method_code%TYPE, --4552701
17: method_trans ap_lookup_codes.displayed_field%TYPE);
18:
19: -----------------------------------------------------------------------
20: -- Declare generic cursor to get check number, check id, invoice number
21: -- invoice id, payment type, payment method lookup code, and translated
96: -- Get the translated phrase 'Multiple Payments'
97: --
98: SELECT displayed_field
99: INTO l_paid_by
100: FROM ap_lookup_codes
101: WHERE lookup_type = 'NLS TRANSLATION'
102: AND lookup_code = 'MULTIPLE PAYMENTS';
103:
104: EXIT;