[Home] [Help]
267: /* GL_BC_PACKETS */
268: /* GL_BC_PACKET_ARRIVAL_ORDER */
269: /* GL_BC_OPTIONS */
270: /* GL_BC_OPTION_DETAILS */
271: /* GL_BC_PERIOD_MAP */
272: /* GL_BC_DUAL */
273: /* GL_BC_DUAL2 */
274: /* GL_CONCURRENCY_CONTROL */
275: /* GL_PERIOD_STATUSES */
3697: -- budgets and/or unused funds that are carried forward from the previous
3698: -- year
3699:
3700: -- Subtraction of first period actual begin balance is done via special rows
3701: -- in gl_bc_period_map with boundary code 'S'. The PM.boundary_code AND
3702: -- clause in the correlated update query joins to these 'S' rows in addition
3703: -- to the regular PM rows for the case of YTD, and b/s or summary accounts,
3704: -- where they are eventually used in the 'AYTD' sum decode operation for the
3705: -- subtraction
3712: -- NESTED LOOPS
3713: -- NESTED LOOPS
3714: -- TABLE ACCESS BY ROWID GL_BC_PACKETS
3715: -- INDEX RANGE SCAN GL_BC_PACKETS_N1
3716: -- INDEX RANGE SCAN GL_BC_PERIOD_MAP_U2
3717: -- TABLE ACCESS BY ROWID GL_BALANCES
3718: -- INDEX RANGE SCAN GL_BALANCES_N1
3719: --
3720:
3794: nvl(gb.period_net_cr, 0),
3795: 'EPJTD', nvl(gb.project_to_date_dr, 0) -
3796: nvl(gb.project_to_date_cr, 0) +
3797: nvl(gb.period_net_dr, 0) - nvl(gb.period_net_cr, 0), 0))
3798: from gl_bc_period_map pm,
3799: gl_balances gb
3800: -- ## selecting the latest open period
3801: -- ## Changes made For fix in Bug 3243216
3802: /* (select effective_period_num e, period_name n,quarter_num q,