[Home] [Help]
2999: /* start bug 4104890*/
3000: FOR l_periods IN
3001: (SELECT start_date,
3002: end_date+1 end_date
3003: FROM psb_budget_periods
3004: WHERE budget_period_type = 'C'
3005: AND l_start_date between start_date AND end_date
3006: AND budget_calendar_id = g_budget_calendar_id
3007: )
3088: /* start bug 4104890*/
3089: FOR l_periods IN
3090: (SELECT start_date ,
3091: end_date+1 end_date
3092: FROM psb_budget_periods
3093: WHERE budget_period_type = 'C'
3094: AND l_start_date between start_date AND end_date
3095: AND budget_calendar_id = g_budget_calendar_id
3096: )
3776:
3777: cursor c_Year is
3778: select start_date,
3779: end_date
3780: from PSB_BUDGET_PERIODS
3781: where budget_period_id = p_budget_year_id;
3782:
3783: BEGIN
3784: