435: -- delete from fem_
436: delete from fem_cctr_orgs_attr
437: where company_cost_center_org_id in (
438: select company_cost_center_org_id
439: from fem_cctr_orgs_b
440: where personal_flag = 'Y'
441: and created_by = p_user_id
442: );
443:
444: -- delete from fem_
445: delete from fem_cctr_orgs_tl
446: where company_cost_center_org_id in (
447: select company_cost_center_org_id
448: from fem_cctr_orgs_b
449: where personal_flag = 'Y'
450: and created_by = p_user_id
451: );
452:
450: and created_by = p_user_id
451: );
452:
453: -- delete from fem_
454: delete from fem_cctr_orgs_b
455: where personal_flag = 'Y'
456: and created_by = p_user_id;
457:
458: elsif (l_dimension_varchar_label = 'CURRENCY') then