125: THEN NULL
126: ELSE fcpa_start_year.number_assign_value + 1
127: END
128: INTO l_year_to_apply_re
129: FROM fem_cal_periods_attr fcpa_start_year,
130: fem_cal_periods_attr fcpa_end_year
131: WHERE fcpa_start_year.cal_period_id = ' ||
132: l_start_cal_period_id || '
133: AND fcpa_start_year.attribute_id = ' ||
126: ELSE fcpa_start_year.number_assign_value + 1
127: END
128: INTO l_year_to_apply_re
129: FROM fem_cal_periods_attr fcpa_start_year,
130: fem_cal_periods_attr fcpa_end_year
131: WHERE fcpa_start_year.cal_period_id = ' ||
132: l_start_cal_period_id || '
133: AND fcpa_start_year.attribute_id = ' ||
134: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
153: ELSE
154: fcpa_start_year.number_assign_value + 1
155: END
156: INTO l_year_to_apply_re
157: FROM fem_cal_periods_attr fcpa_start_year,
158: fem_cal_periods_attr fcpa_end_year
159: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
160: AND fcpa_start_year.attribute_id =
161: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
154: fcpa_start_year.number_assign_value + 1
155: END
156: INTO l_year_to_apply_re
157: FROM fem_cal_periods_attr fcpa_start_year,
158: fem_cal_periods_attr fcpa_end_year
159: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
160: AND fcpa_start_year.attribute_id =
161: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
162: .attribute_id
522: THEN NULL
523: ELSE fcpa_start_year.number_assign_value + 1
524: END
525: INTO l_year_to_apply_re
526: FROM fem_cal_periods_attr fcpa_start_year,
527: fem_cal_periods_attr fcpa_end_year
528: WHERE fcpa_start_year.cal_period_id = ' ||
529: l_start_cal_period_id || '
530: AND fcpa_start_year.attribute_id = ' ||
523: ELSE fcpa_start_year.number_assign_value + 1
524: END
525: INTO l_year_to_apply_re
526: FROM fem_cal_periods_attr fcpa_start_year,
527: fem_cal_periods_attr fcpa_end_year
528: WHERE fcpa_start_year.cal_period_id = ' ||
529: l_start_cal_period_id || '
530: AND fcpa_start_year.attribute_id = ' ||
531: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
579: ELSE
580: fcpa_start_year.number_assign_value + 1
581: END
582: INTO l_year_to_apply_re
583: FROM fem_cal_periods_attr fcpa_start_year,
584: fem_cal_periods_attr fcpa_end_year
585: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
586: AND fcpa_start_year.attribute_id =
587: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
580: fcpa_start_year.number_assign_value + 1
581: END
582: INTO l_year_to_apply_re
583: FROM fem_cal_periods_attr fcpa_start_year,
584: fem_cal_periods_attr fcpa_end_year
585: WHERE fcpa_start_year.cal_period_id = l_start_cal_period_id
586: AND fcpa_start_year.attribute_id =
587: g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
588: .attribute_id