APPS.ICX_AP_CHECKS_PKG dependencies on AP_INVOICES

Line 10: l_inv_num AP_INVOICES.INVOICE_NUM%TYPE;

6: --
7: FUNCTION get_invoices_paid (l_check_id IN NUMBER)
8: RETURN VARCHAR2
9: IS
10: l_inv_num AP_INVOICES.INVOICE_NUM%TYPE;
11: l_inv_num_list VARCHAR2(4000) := NULL;
12: l_inv_num_good VARCHAR2(4000) := NULL; -- newly added
13:
14: -------------------------------------------------------------------

Line 19: FROM ap_invoices ai,

15: -- Declare cursor to return the Invoice number
16: --
17: CURSOR inv_num_cursor IS
18: SELECT ai.invoice_num
19: FROM ap_invoices ai,
20: ap_invoice_payments aip
21: WHERE aip.check_id = l_check_id
22: AND aip.invoice_id = ai.invoice_id;
23: