APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_COST_CENTERS_TL

Line 1554: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COST_CENTERS_TL');

1550: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_INTG_OGL_CCID_MAP');
1551: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COMPANIES_B');
1552: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COMPANIES_TL');
1553: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COST_CENTERS_B');
1554: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COST_CENTERS_TL');
1555:
1556: fnd_stats.GATHER_TABLE_STATS('FEM', pv_member_b_table_name);
1557: fnd_stats.GATHER_TABLE_STATS('FEM', pv_member_tl_table_name);
1558: fnd_stats.GATHER_TABLE_STATS('FEM', pv_attr_table_name);

Line 1567: 'FEM_COST_CENTERS_TL',

1563: 'FEM_INTG_OGL_CCID_MAP',
1564: 'FEM_COMPANIES_B',
1565: 'FEM_COMPANIES_TL',
1566: 'FEM_COST_CENTERS_B',
1567: 'FEM_COST_CENTERS_TL',
1568: pv_member_b_table_name,
1569: pv_member_tl_table_name,
1570: pv_attr_table_name)
1571: AND table_owner = 'FEM' and owner = 'FEM';

Line 2686: DELETE FROM FEM_COST_CENTERS_TL WHERE value_set_id = cctr_val_set_id;

2682: p_module => pc_module_name || l_func_name ,
2683: p_msg_text => 'deleting the cost center value sets');
2684:
2685: DELETE FROM FEM_COST_CENTERS_B WHERE value_set_id = cctr_val_set_id;
2686: DELETE FROM FEM_COST_CENTERS_TL WHERE value_set_id = cctr_val_set_id;
2687: DELETE FROM FEM_COST_CENTERS_ATTR WHERE value_set_id = cctr_val_set_id;
2688:
2689: -- deleting the cost center value sets
2690: delete from fem_value_sets_b where value_set_id = cctr_val_set_id;