166: UPDATE bsc_kpi_periodicities
167: SET current_period = p_Calendar_Record.Fiscal_Year
168: WHERE periodicity_id IN
169: ( SELECT periodicity_id
170: FROM bsc_sys_periodicities
171: WHERE calendar_id = p_Calendar_Record.Calendar_Id
172: AND periodicity_type = 1
173: );
174:
218: DELETE bsc_sys_periods_tl
219: WHERE periodicity_id IN
220: (
221: SELECT periodicity_id
222: FROM bsc_sys_periodicities
223: WHERE calendar_id = p_Calendar_Record.Calendar_Id
224: );
225:
226: DELETE bsc_sys_periods
226: DELETE bsc_sys_periods
227: WHERE periodicity_id IN
228: (
229: SELECT periodicity_id
230: FROM bsc_sys_periodicities
231: WHERE calendar_id = p_Calendar_Record.Calendar_Id
232: );
233:
234: DELETE bsc_sys_periodicities_tl
230: FROM bsc_sys_periodicities
231: WHERE calendar_id = p_Calendar_Record.Calendar_Id
232: );
233:
234: DELETE bsc_sys_periodicities_tl
235: WHERE periodicity_id IN
236: (
237: SELECT periodicity_id
238: FROM bsc_sys_periodicities
234: DELETE bsc_sys_periodicities_tl
235: WHERE periodicity_id IN
236: (
237: SELECT periodicity_id
238: FROM bsc_sys_periodicities
239: WHERE calendar_id = p_Calendar_Record.Calendar_Id
240: );
241:
242: DELETE bsc_sys_periodicities
238: FROM bsc_sys_periodicities
239: WHERE calendar_id = p_Calendar_Record.Calendar_Id
240: );
241:
242: DELETE bsc_sys_periodicities
243: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
244:
245: DELETE bsc_sys_calendars_tl
246: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
323: SELECT BSCPER.short_name
324: ,BSCPER.name
325: ,BSCDIM.dim_level_id
326: ,BISDIM.level_id
327: FROM bsc_sys_periodicities_vl BSCPER,
328: bsc_sys_dim_levels_vl BSCDIM,
329: bis_levels_vl BISDIM
330: WHERE BSCPER.short_name = BSCDIM.short_name
331: AND BSCPER.short_name = BISDIM.short_name