220: l_recur_stat_entry_id NUMBER;
221:
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
221:
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