DBA Data[Home] [Help]

APPS.AP_CHECKS_PKG dependencies on AP_INVOICES

Line 1383: l_inv_num AP_INVOICES.INVOICE_NUM%TYPE;

1379: --
1380: FUNCTION get_invoices_paid (l_check_id IN NUMBER)
1381: RETURN VARCHAR2
1382: IS
1383: l_inv_num AP_INVOICES.INVOICE_NUM%TYPE;
1384: l_inv_num_list VARCHAR2(2000) := NULL;
1385:
1386: -------------------------------------------------------------------
1387: -- Declare cursor to return the Invoice number

Line 1391: FROM ap_invoices ai,

1387: -- Declare cursor to return the Invoice number
1388: --
1389: CURSOR inv_num_cursor IS
1390: SELECT ai.invoice_num
1391: FROM ap_invoices ai,
1392: ap_invoice_payments aip
1393: WHERE aip.check_id = l_check_id
1394: AND aip.invoice_id = ai.invoice_id;
1395: