APPS.ICX_AP_INVOICE_PAYMENTS_PKG dependencies on AP_LOOKUP_CODES

Line 15: type_trans ap_lookup_codes.displayed_field%TYPE,

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_lookup_code%TYPE,
17: method_trans ap_lookup_codes.displayed_field%TYPE);
18:
19: -----------------------------------------------------------------------

Line 17: method_trans ap_lookup_codes.displayed_field%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_lookup_code%TYPE,
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

Line 39: ap_lookup_codes alc1,

35: alc2.displayed_field
36: FROM ap_invoice_payments aip,
37: ap_checks ac,
38: ap_invoices ai,
39: ap_lookup_codes alc1,
40: ap_lookup_codes alc2
41: WHERE aip.invoice_id = l_invoice_id
42: AND aip.payment_num = l_payment_num
43: AND aip.check_id = ac.check_id

Line 40: ap_lookup_codes alc2

36: FROM ap_invoice_payments aip,
37: ap_checks ac,
38: ap_invoices ai,
39: ap_lookup_codes alc1,
40: ap_lookup_codes alc2
41: WHERE aip.invoice_id = l_invoice_id
42: AND aip.payment_num = l_payment_num
43: AND aip.check_id = ac.check_id
44: AND aip.other_invoice_id = ai.invoice_id (+)