DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on GL_LEDGERS

Line 377: * gl_sets_of_books and included gl_ledgers.

373: /* Bug 5243532. Added by Lakshmi Gopalsami
374: * Removed cursor c_fetch_org_information and removed
375: * org_organization_definitions from the cursor c_period_name
376: * and passed set_of_books_id to the cursor. Also removed
377: * gl_sets_of_books and included gl_ledgers.
378: */
379:
380: cursor c_period_name(cp_set_of_books_id in number, cp_accounting_date in date) IS
381: select gd.period_name

Line 382: FROM gl_ledgers gle, gl_periods gd

378: */
379:
380: cursor c_period_name(cp_set_of_books_id in number, cp_accounting_date in date) IS
381: select gd.period_name
382: FROM gl_ledgers gle, gl_periods gd
383: where gle.ledger_id = cp_set_of_books_id
384: and gd.period_set_name = gle.period_set_name
385: and cp_accounting_date between gd.start_date and gd.end_date
386: and gd.adjustment_period_flag = 'N';

Line 1496: ln_set_of_books_id gl_ledgers.ledger_id%TYPE;

1492: * Defined variable for implementing caching logic.
1493: */
1494: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1495: lv_org_code org_organization_definitions.organization_code%TYPE;
1496: ln_set_of_books_id gl_ledgers.ledger_id%TYPE;
1497: -- End for bug 5243532
1498:
1499:
1500: BEGin