59: SELECT gps.period_name
60: INTO history_period
61: FROM gl_periods gps,
62: gl_periods gp,
63: gl_period_types gpt
64: WHERE gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),
65: 1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
66: gpt.number_per_fiscal_year +
67: mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))