APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_COST_CENTERS_B

Line 1553: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COST_CENTERS_B');

1549: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_INTG_AOL_VALSET_MAP');
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);

Line 1566: 'FEM_COST_CENTERS_B',

1562: from all_indexes where table_name in('FEM_INTG_AOL_VALSET_MAP',
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)

Line 2685: DELETE FROM FEM_COST_CENTERS_B WHERE value_set_id = cctr_val_set_id;

2681: (p_severity => pc_log_level_statement,
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