482:
483: /****************************
484: Ledger
485: ***************************/
486: delete from fem_ledgers_attr where version_id in
487: (select version_id from fem_dim_attr_Versions_b
488: where attribute_id in (select attribute_id
489: from fem_dim_attributes_b A1, fem_dimensions_b D1
490: where A1.dimension_id = D1.dimension_id
608:
609: delete from fem_dsnp_ledgers_attr
610: where attribute_id = attr.attribute_id;
611:
612: delete from fem_ledgers_attr
613: where attribute_id = attr.attribute_id;
614:
615: delete from fem_dim_attr_versions_tl
616: where version_id in (select version_id
640:
641: delete from fem_dsnp_ledgers_attr
642: where attribute_id = attr.attribute_id;
643:
644: delete from fem_ledgers_attr
645: where attribute_id = attr.attribute_id;
646:
647: delete from fem_dim_attr_versions_tl
648: where version_id in (select version_id
672:
673: delete from fem_dsnp_ledgers_attr
674: where attribute_id = attr.attribute_id;
675:
676: delete from fem_ledgers_attr
677: where attribute_id = attr.attribute_id;
678:
679: delete from fem_dim_attr_versions_tl
680: where version_id in (select version_id
704:
705: delete from fem_dsnp_ledgers_attr
706: where attribute_id = attr.attribute_id;
707:
708: delete from fem_ledgers_attr
709: where attribute_id = attr.attribute_id;
710:
711: delete from fem_dim_attr_versions_tl
712: where version_id in (select version_id
736:
737: delete from fem_dsnp_ledgers_attr
738: where attribute_id = attr.attribute_id;
739:
740: delete from fem_ledgers_attr
741: where attribute_id = attr.attribute_id;
742:
743: delete from fem_dim_attr_versions_tl
744: where version_id in (select version_id