DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on GL_PERIODS

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

397: ln_entered_dr number;
398: ln_user_id fnd_user.user_id%type; --File.Sql.35 Cbabu := fnd_global.user_id;
399:
400: lv_organization_code org_organization_definitions.organization_code%type;
401: lv_period_name gl_periods.period_name%type;
402: lv_debit_credit_flag varchar2(1);
403: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
404:
405: ld_sysdate date; --File.Sql.35 Cbabu := SYSDATE;