DBA Data[Home] [Help]

APPS.XLA_BALANCES_CALC_PKG dependencies on GL_LEDGERS

Line 3369: , gl_ledgers l

3365: SELECT l.ledger_category_code
3366: , gps.effective_period_num
3367: , adjustment_period_flag -- Bug 12613841
3368: FROM gl_period_statuses gps
3369: , gl_ledgers l
3370: WHERE l.ledger_id = p_ledger_id
3371: AND gps.ledger_id = l.ledger_id
3372: AND gps.application_id = 101
3373: AND gps.period_name = p_period_name;

Line 3458: FROM gl_period_statuses gps,gl_ledgers gll

3454: IF l_xlo_not_nul_count > 0 THEN -- added Bug12613841
3455:
3456: UPDATE xla_ledger_options xlo
3457: SET effective_period_num = (SELECT gps.effective_period_num
3458: FROM gl_period_statuses gps,gl_ledgers gll
3459: WHERE gps.application_id= 101
3460: AND gps.ledger_id = xlo.ledger_id
3461: AND gll.ledger_id = xlo.ledger_id
3462: AND gps.period_name = gll.FIRST_LEDGER_PERIOD_NAME