[Home] [Help]
278: /* GL_BC_PACKETS */
279: /* GL_BC_PACKET_ARRIVAL_ORDER */
280: /* GL_BC_OPTIONS */
281: /* GL_BC_OPTION_DETAILS */
282: /* GL_BC_PERIOD_MAP */
283: /* GL_BC_DUAL */
284: /* GL_BC_DUAL2 */
285: /* GL_CONCURRENCY_CONTROL */
286: /* GL_PERIOD_STATUSES */
3772: -- budgets and/or unused funds that are carried forward from the previous
3773: -- year
3774:
3775: -- Subtraction of first period actual begin balance is done via special rows
3776: -- in gl_bc_period_map with boundary code 'S'. The PM.boundary_code AND
3777: -- clause in the correlated update query joins to these 'S' rows in addition
3778: -- to the regular PM rows for the case of YTD, and b/s or summary accounts,
3779: -- where they are eventually used in the 'AYTD' sum decode operation for the
3780: -- subtraction
3787: -- NESTED LOOPS
3788: -- NESTED LOOPS
3789: -- TABLE ACCESS BY ROWID GL_BC_PACKETS
3790: -- INDEX RANGE SCAN GL_BC_PACKETS_N1
3791: -- INDEX RANGE SCAN GL_BC_PERIOD_MAP_U2
3792: -- TABLE ACCESS BY ROWID GL_BALANCES
3793: -- INDEX RANGE SCAN GL_BALANCES_N1
3794: --
3795:
3869: nvl(gb.period_net_cr, 0),
3870: 'EPJTD', nvl(gb.project_to_date_dr, 0) -
3871: nvl(gb.project_to_date_cr, 0) +
3872: nvl(gb.period_net_dr, 0) - nvl(gb.period_net_cr, 0), 0))
3873: from gl_bc_period_map pm,
3874: gl_balances gb
3875: -- ## selecting the latest open period
3876: -- ## Changes made For fix in Bug 3243216
3877: /* (select effective_period_num e, period_name n,quarter_num q,