DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on GL_LEDGERS

Line 391: * gl_sets_of_books and included gl_ledgers.

387: /* Bug 5243532. Added by Lakshmi Gopalsami
388: * Removed cursor c_fetch_org_information and removed
389: * org_organization_definitions from the cursor c_period_name
390: * and passed set_of_books_id to the cursor. Also removed
391: * gl_sets_of_books and included gl_ledgers.
392: */
393:
394: cursor c_period_name(cp_set_of_books_id in number, cp_accounting_date in date) IS
395: select gd.period_name

Line 396: FROM gl_ledgers gle, gl_periods gd

392: */
393:
394: cursor c_period_name(cp_set_of_books_id in number, cp_accounting_date in date) IS
395: select gd.period_name
396: FROM gl_ledgers gle, gl_periods gd
397: where gle.ledger_id = cp_set_of_books_id
398: and gd.period_set_name = gle.period_set_name
399: and cp_accounting_date between gd.start_date and gd.end_date
400: and gd.adjustment_period_flag = 'N';

Line 1556: ln_set_of_books_id gl_ledgers.ledger_id%TYPE;

1552: * Defined variable for implementing caching logic.
1553: */
1554: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1555: lv_org_code org_organization_definitions.organization_code%TYPE;
1556: ln_set_of_books_id gl_ledgers.ledger_id%TYPE;
1557: -- End for bug 5243532
1558:
1559:
1560: BEGin