222: CURSOR last_period_c IS
223: SELECT lp.cal_period_id
224: FROM fem_cal_periods_b lp,
225: fem_cal_periods_b fp,
226: fem_cal_periods_attr lp_year,
227: fem_cal_periods_attr fp_year,
228: fem_cal_periods_attr lp_num
229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id
223: SELECT lp.cal_period_id
224: FROM fem_cal_periods_b lp,
225: fem_cal_periods_b fp,
226: fem_cal_periods_attr lp_year,
227: fem_cal_periods_attr fp_year,
228: fem_cal_periods_attr lp_num
229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id
231: AND lp.calendar_id = fp.calendar_id
224: FROM fem_cal_periods_b lp,
225: fem_cal_periods_b fp,
226: fem_cal_periods_attr lp_year,
227: fem_cal_periods_attr fp_year,
228: fem_cal_periods_attr lp_num
229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id
231: AND lp.calendar_id = fp.calendar_id
232: AND lp_year.cal_period_id = lp.cal_period_id