[Home] [Help]
287: -- delete from fem_
288: delete from fem_cal_periods_attr
289: where cal_period_id in (
290: select cal_period_id
291: from fem_cal_periods_b
292: where personal_flag = 'Y'
293: and created_by = p_user_id
294: );
295:
296: -- delete from fem_
297: delete from fem_cal_periods_tl
298: where cal_period_id in (
299: select cal_period_id
300: from fem_cal_periods_b
301: where personal_flag = 'Y'
302: and created_by = p_user_id
303: );
304:
302: and created_by = p_user_id
303: );
304:
305: -- delete from fem_
306: delete from fem_cal_periods_b
307: where personal_flag = 'Y'
308: and created_by = p_user_id;
309:
310: elsif (l_dimension_varchar_label = 'NATURAL_ACCOUNT') then