APPS.FEM_REFRESH_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

 |     del_obsolete_seed_data - this procedure calls all of the delete statements
 |     for removing obsolete seeded data from the database.  This seed data
 |     would otherwise get put back in by the refresh when it calls the ldt
 |     files to repopulate.  The reason for this being that the ldt files
 |     for backports are targeted - i.e, the main ldt file still contains the
 |     obsolete rows.
 |
 | MODIFICATION HISTORY
 |    Rob Flippo         07/06/2005   Created
 |    Rob Flippo         04/24/2006   Bug5002331 Remove refrence to
 |                                    DIM_PROPERTIES in delete statements
 |                                    for FEM_ADMIN_DIMESTUP_TASKS
 |    Rob Flippo         07/10/2006   Bug#5237422 Add deletes for attributes
 |                                    previously made optional
 |
  *=======================================================================*/


PROCEDURE del_obsolete_seed_data (x_status OUT NOCOPY VARCHAR2) IS

v_count number;

Line: 46

select attribute_id from fem_dim_attributes_b
where dimension_id = p_dimid
and attribute_varchar_label in ('LEDGER_CHANNEL_IS_POP_FLAG'
,'LEDGER_CUSTOMER_IS_POP_FLAG'
,'LEDGER_ENTITY_IS_POP_FLAG'
,'LEDGER_FIN_ELEM_IS_POP_FLAG'
,'LEDGER_GEOGRAPHY_IS_POP_FLAG'
,'LEDGER_LINE_ITEM_IS_POP_FLAG'
,'LEDGER_NAT_ACCT_IS_POP_FLAG'
,'LEDGER_PRODUCT_IS_POP_FLAG'
,'LEDGER_PROJECT_IS_POP_FLAG'
,'LEDGER_TASK_IS_POP_FLAG'
,'LEDGER_USER_DIM10_IS_POP_FLAG'
,'LEDGER_USER_DIM1_IS_POP_FLAG'
,'LEDGER_USER_DIM2_IS_POP_FLAG'
,'LEDGER_USER_DIM3_IS_POP_FLAG'
,'LEDGER_USER_DIM4_IS_POP_FLAG'
,'LEDGER_USER_DIM5_IS_POP_FLAG'
,'LEDGER_USER_DIM6_IS_POP_FLAG'
,'LEDGER_USER_DIM7_IS_POP_FLAG'
,'LEDGER_USER_DIM8_IS_POP_FLAG'
,'LEDGER_USER_DIM9_IS_POP_FLAG'
,'LEDGER_CCTR_IS_POP_FLAG' );

Line: 71

select attribute_id from fem_dim_attributes_b
where dimension_id = p_dimid
and attribute_varchar_label in ('FINANCIAL_CATEGORY_FLAG');

Line: 76

select attribute_id from fem_dim_attributes_b
where dimension_id = p_dimid
and attribute_varchar_label in ('HIDDEN_FLAG');

Line: 81

select attribute_id from fem_dim_attributes_b
where dimension_id = p_dimid
and attribute_varchar_label in ('CONSOLIDATION_FLAG');

Line: 86

select attribute_id from fem_dim_attributes_b
where dimension_id = p_dimid
and attribute_varchar_label in ('HIDDEN_FLAG','BUDGET_ALLOWED_FLAG');

Line: 96

delete from fem_sic_hier
where hierarchy_obj_def_id = 1501
and child_id = 1
and parent_id = 75;

Line: 101

delete from fem_sic_hier
where hierarchy_obj_def_id = 1501
and child_id = 5
and parent_id = 76;

Line: 109

   select count(*)
   into v_count
   from fem_tab_columns_b
   where table_name='FEM_CREDIT_LIMITS'
   and column_name = 'CREDIT_LIMIT_TYPE';

Line: 117

      delete from fem_tab_columns_b
      where table_name='FEM_CREDIT_LIMITS'
      and column_name in ('CREDIT_LIMIT_ID','CREDIT_LIMIT_TYPE');

Line: 121

      delete from fem_tab_columns_tl
      where table_name='FEM_CREDIT_LIMITS'
      and column_name in ('CREDIT_LIMIT_ID','CREDIT_LIMIT_TYPE');

Line: 129

delete from fem_folders_tl
where folder_id in (1200, 1300);

Line: 132

delete from fem_folders_b
where folder_id in (1200, 1300);

Line: 137

delete from FEM_TAB_COLUMNS_B
where table_name = 'FEM_CREDIT_LIMITS'
and column_name = 'CREDIT_LIMIT_AMOUNT';

Line: 141

delete from FEM_INT_COLUMN_MAP
where object_type_code = 'SOURCE_DATA_LOADER'
and target_column_name = 'CREDIT_LIMIT_AMOUNT'
and interface_column_name = 'CREDIT_LIMIT_AMOUNT';

Line: 148

*    FEM.C delete statements
*    Per Bug#3884353 Integration: Attribute Removal
*    and bug#4044974 DATAMODEL CHANGE TO SUPPORT DEFAULT HIERARCHY
*                    FOR CAL PERIOD DIMENSION

**********************************************************************

/****************************
  Calendar
***************************/
delete from fem_calendars_attr
where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'CALENDAR'
and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
)));

Line: 168

delete from fem_dim_attr_versions_tl where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'CALENDAR'
and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
)));

Line: 177

delete from fem_dim_attr_versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'CALENDAR'
and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
));

Line: 185

delete from fem_dim_attributes_tl
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'CALENDAR'
and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
));

Line: 193

delete from fem_dim_attributes_priv
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'CALENDAR'
and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
));

Line: 201

delete from fem_dim_attributes_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'CALENDAR'
and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
,'DIVISIBLE_FLAG'));

Line: 213

delete from fem_fin_elems_attr
where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG')));

Line: 223

delete from fem_dim_attr_versions_tl where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG')));

Line: 232

delete from fem_dim_attr_versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG'));

Line: 240

delete from fem_dim_attributes_tl
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG'));

Line: 248

delete from fem_dim_attributes_priv
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG'));

Line: 256

delete from fem_dim_attr_grps
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG'));

Line: 264

delete from fem_dim_attributes_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
,'DIVISIBLE_FLAG'));

Line: 276

delete from fem_ln_items_attr
where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
)));

Line: 292

delete from fem_dim_attr_versions_tl where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
)));

Line: 306

delete from fem_dim_attr_versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
));

Line: 319

delete from fem_dim_attributes_tl
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
));

Line: 332

delete from fem_dim_attributes_priv
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
));

Line: 345

delete from fem_dim_attr_grps
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
));

Line: 358

delete from fem_dim_attributes_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LINE_ITEM'
and A1.attribute_varchar_label in ('BAL_SHEET_MODEL_CODE'
,'TP_METHOD_CODE'
,'NEW_TIMING_PCT'
,'WEIGHTING_AVG_PERIOD'
,'ACTIVATION_FLAG'
,'OFFSET_CCTR_ORG'
));

Line: 375

delete from fem_products_attr where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG')));

Line: 384

delete from fem_dim_attr_versions_tl where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG')));

Line: 392

delete from fem_dim_attr_versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG'));

Line: 399

delete from fem_dim_attributes_tl
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG'));

Line: 406

delete from fem_dim_attributes_priv
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG'));

Line: 413

delete from fem_dim_attr_grps
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG'));

Line: 420

delete from fem_dim_attributes_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'PRODUCT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG'));

Line: 431

delete from fem_nat_accts_attr where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG')));

Line: 440

delete from fem_dim_attr_versions_tl where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG')));

Line: 448

delete from fem_dim_attr_versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));

Line: 455

delete from fem_dim_attributes_tl
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));

Line: 462

delete from fem_dim_attributes_priv
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));

Line: 469

delete from fem_dim_attr_grps
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));

Line: 476

delete from fem_dim_attributes_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));

Line: 486

delete from fem_ledgers_attr where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG')));

Line: 494

delete from fem_dim_attr_versions_tl where version_id in
(select version_id from fem_dim_attr_Versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG')));

Line: 502

delete from fem_dim_attr_versions_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));

Line: 509

delete from fem_dim_attributes_tl
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));

Line: 516

delete from fem_dim_attributes_priv
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));

Line: 523

delete from fem_dim_attr_grps
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));

Line: 530

delete from fem_dim_attributes_b
where attribute_id in (select attribute_id
from fem_dim_attributes_b A1, fem_dimensions_b D1
where A1.dimension_id = D1.dimension_id
and D1.dimension_varchar_label = 'LEDGER'
and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));

Line: 539

delete from fem_admin_dimsetup_tasks
where dimsetup_task  in
('DIM_ASSOCIATIONS');

Line: 545

delete from fem_entity_types_tl
where entity_type_code in ('CONSOLIDATION','ELIMINATION','OPERATING');

Line: 547

delete from fem_entity_types_b
where entity_type_code in ('CONSOLIDATION','ELIMINATION','OPERATING');

Line: 553

delete from fem_ext_Acct_types_attr where attribute_id in
(select attribute_id from fem_dim_attributes_b
where attribute_varchar_label in ('DEBIT_SIGN','LOAD_SIGN'));

Line: 557

delete from fem_dim_attr_Versions_vl
where attribute_id in (select attribute_id from fem_dim_attributes_b
where attribute_Varchar_label in ('DEBIT_SIGN','LOAD_SIGN'));

Line: 561

delete from fem_dim_attributes_vl where attribute_varchar_label in ('DEBIT_SIGN','LOAD_SIGN');

Line: 563

delete from fem_ln_items_attr where attribute_id in
(select attribute_id from fem_dim_attributes_b
where attribute_Varchar_label = 'STATISTICS_TYPE_FLAG');

Line: 567

delete from fem_dim_attr_Versions_vl
where attribute_id in
(select attribute_id from fem_dim_attributes_b
where attribute_Varchar_label = 'STATISTICS_TYPE_FLAG');

Line: 571

delete from fem_dim_attributes_vl
where attribute_varchar_label = 'STATISTICS_TYPE_FLAG';

Line: 580

select dimension_id
into v_ledger_dim_id
from fem_dimensions_b
where dimension_varchar_label = 'LEDGER';

Line: 585

select dimension_id
into v_natrl_dim_id
from fem_dimensions_b
where dimension_varchar_label = 'NATURAL_ACCOUNT';

Line: 590

select dimension_id
into v_cctr_dim_id
from fem_dimensions_b
where dimension_varchar_label = 'COMPANY_COST_CENTER_ORG';

Line: 595

select dimension_id
into v_finelem_dim_id
from fem_dimensions_b
where dimension_varchar_label = 'FINANCIAL_ELEMENT';

Line: 600

select dimension_id
into v_lnitem_dim_id
from fem_dimensions_b
where dimension_varchar_label = 'LINE_ITEM';

Line: 609

delete from fem_dsnp_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 612

delete from fem_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 615

delete from fem_dim_attr_versions_tl
where version_id in (select version_id
from fem_dim_attr_Versions_b
where attribute_id = attr.attribute_id);

Line: 620

delete from fem_dim_attr_versions_b
where attribute_id = attr.attribute_id;

Line: 623

delete from fem_dim_attributes_tl
where attribute_id = attr.attribute_id;

Line: 626

delete from fem_dim_attributes_b
where attribute_id = attr.attribute_id;

Line: 629

delete from fem_dim_attr_grps
where attribute_id=attr.attribute_id;

Line: 632

delete from fem_dim_attributes_priv
where attribute_id = attr.attribute_id;

Line: 641

delete from fem_dsnp_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 644

delete from fem_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 647

delete from fem_dim_attr_versions_tl
where version_id in (select version_id
from fem_dim_attr_Versions_b
where attribute_id = attr.attribute_id);

Line: 652

delete from fem_dim_attr_versions_b
where attribute_id = attr.attribute_id;

Line: 655

delete from fem_dim_attributes_tl
where attribute_id = attr.attribute_id;

Line: 658

delete from fem_dim_attributes_b
where attribute_id = attr.attribute_id;

Line: 661

delete from fem_dim_attr_grps
where attribute_id=attr.attribute_id;

Line: 664

delete from fem_dim_attributes_priv
where attribute_id = attr.attribute_id;

Line: 673

delete from fem_dsnp_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 676

delete from fem_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 679

delete from fem_dim_attr_versions_tl
where version_id in (select version_id
from fem_dim_attr_Versions_b
where attribute_id = attr.attribute_id);

Line: 684

delete from fem_dim_attr_versions_b
where attribute_id = attr.attribute_id;

Line: 687

delete from fem_dim_attributes_tl
where attribute_id = attr.attribute_id;

Line: 690

delete from fem_dim_attributes_b
where attribute_id = attr.attribute_id;

Line: 693

delete from fem_dim_attr_grps
where attribute_id=attr.attribute_id;

Line: 696

delete from fem_dim_attributes_priv
where attribute_id = attr.attribute_id;

Line: 705

delete from fem_dsnp_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 708

delete from fem_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 711

delete from fem_dim_attr_versions_tl
where version_id in (select version_id
from fem_dim_attr_Versions_b
where attribute_id = attr.attribute_id);

Line: 716

delete from fem_dim_attr_versions_b
where attribute_id = attr.attribute_id;

Line: 719

delete from fem_dim_attributes_tl
where attribute_id = attr.attribute_id;

Line: 722

delete from fem_dim_attributes_b
where attribute_id = attr.attribute_id;

Line: 725

delete from fem_dim_attr_grps
where attribute_id=attr.attribute_id;

Line: 728

delete from fem_dim_attributes_priv
where attribute_id = attr.attribute_id;

Line: 737

delete from fem_dsnp_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 740

delete from fem_ledgers_attr
where attribute_id = attr.attribute_id;

Line: 743

delete from fem_dim_attr_versions_tl
where version_id in (select version_id
from fem_dim_attr_Versions_b
where attribute_id = attr.attribute_id);

Line: 748

delete from fem_dim_attr_versions_b
where attribute_id = attr.attribute_id;

Line: 751

delete from fem_dim_attributes_tl
where attribute_id = attr.attribute_id;

Line: 754

delete from fem_dim_attributes_b
where attribute_id = attr.attribute_id;

Line: 757

delete from fem_dim_attr_grps
where attribute_id=attr.attribute_id;

Line: 760

delete from fem_dim_attributes_priv
where attribute_id = attr.attribute_id;

Line: 767

delete from fem_data_types_tl
where fem_data_type_code = 'VARCHAR2';

Line: 770

delete from fem_data_types_b
where fem_data_type_code = 'VARCHAR2';

Line: 773

delete from fem_data_types_attr
where fem_data_type_code = 'VARCHAR2';