APPS.POS_AP_INVOICE_PAYMENTS_PKG dependencies on AP_CHECKS

Line 8: RECORD (check_number ap_checks.check_number%TYPE,

4: -----------------------------------------------------------------------
5: -- Declare record type used to hold records returned from generic cursor
6: --
7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%TYPE,
9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,

Line 9: check_id ap_checks.check_id%TYPE,

5: -- Declare record type used to hold records returned from generic cursor
6: --
7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%TYPE,
9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%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,

Line 10: check_date ap_checks.check_date%TYPE,

6: --
7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%TYPE,
9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%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,

Line 16: method ap_checks.payment_method_lookup_code%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: -----------------------------------------------------------------------
20: -- Declare generic cursor to get check number, check id, invoice number

Line 39: ap_checks_all ac, --ap_checks

35: alc1.displayed_field,
36: ac.payment_method_lookup_code,
37: alc2.displayed_field
38: FROM ap_invoice_payments_all aip, --ap_invoice_payments
39: ap_checks_all ac, --ap_checks
40: ap_invoices_all ai, --ap_invoices
41: ap_lookup_codes alc1,
42: ap_lookup_codes alc2
43: WHERE aip.invoice_id = l_invoice_id