410: -- delete from fem_
411: delete from fem_ledgers_attr
412: where ledger_id in (
413: select ledger_id
414: from fem_ledgers_b
415: where personal_flag = 'Y'
416: and created_by = p_user_id
417: );
418:
419: -- delete from fem_
420: delete from fem_ledgers_tl
421: where ledger_id in (
422: select ledger_id
423: from fem_ledgers_b
424: where personal_flag = 'Y'
425: and created_by = p_user_id
426: );
427:
425: and created_by = p_user_id
426: );
427:
428: -- delete from fem_
429: delete from fem_ledgers_b
430: where personal_flag = 'Y'
431: and created_by = p_user_id;
432:
433: elsif (l_dimension_varchar_label = 'COMPANY_COST_CENTER_ORG') then