APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on FEM_COMPANIES_TL

Line 1552: fnd_stats.GATHER_TABLE_STATS('FEM','FEM_COMPANIES_TL');

1548: -- Bug 5084804
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);

Line 1565: 'FEM_COMPANIES_TL',

1561: INTO pv_index_name
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,

Line 2668: DELETE FROM FEM_COMPANIES_TL WHERE value_set_id = comp_val_set_id;

2664: p_module => pc_module_name || l_func_name ,
2665: p_msg_text => 'deleting the company value sets');
2666:
2667: DELETE FROM FEM_COMPANIES_B WHERE value_set_id = comp_val_set_id;
2668: DELETE FROM FEM_COMPANIES_TL WHERE value_set_id = comp_val_set_id;
2669: DELETE FROM FEM_COMPANIES_ATTR WHERE value_set_id = comp_val_set_id;
2670:
2671: -- deleting the company value sets
2672: