DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on GL_PERIODS

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 436: lv_period_name gl_periods.period_name%type;

432: ln_entered_dr number;
433: ln_user_id fnd_user.user_id%type; --File.Sql.35 Cbabu := fnd_global.user_id;
434:
435: lv_organization_code org_organization_definitions.organization_code%type;
436: lv_period_name gl_periods.period_name%type;
437: lv_debit_credit_flag varchar2(1);
438: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
439:
440: ld_sysdate date; --File.Sql.35 Cbabu := SYSDATE;