DBA Data[Home] [Help]

APPS.AP_CHECKS_PKG dependencies on AP_INVOICES

Line 1501: l_inv_num AP_INVOICES.INVOICE_NUM%TYPE;

1497: --
1498: FUNCTION get_invoices_paid (l_check_id IN NUMBER)
1499: RETURN VARCHAR2
1500: IS
1501: l_inv_num AP_INVOICES.INVOICE_NUM%TYPE;
1502: l_inv_num_list VARCHAR2(2000) := NULL;
1503:
1504: -------------------------------------------------------------------
1505: -- Declare cursor to return the Invoice number

Line 1509: FROM ap_invoices ai,

1505: -- Declare cursor to return the Invoice number
1506: --
1507: CURSOR inv_num_cursor IS
1508: SELECT ai.invoice_num
1509: FROM ap_invoices ai,
1510: ap_invoice_payments aip
1511: WHERE aip.check_id = l_check_id
1512: AND aip.invoice_id = ai.invoice_id;
1513: