DBA Data[Home] [Help]

APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_TAB_INDX_INFO_GT

Line 2660: FROM fem_tab_indx_info_gt tiig,

2656: ---------------------------------
2657: --need to think abt this
2658: SELECT tiig.table_name, tig.owner
2659: INTO x_tab_name,x_tab_owner
2660: FROM fem_tab_indx_info_gt tiig,
2661: fem_tables_b ftb,
2662: fem_tab_info_gt tig
2663: WHERE ftb.table_name = p_view_name
2664: AND ftb.PROC_KEY_INDEX_NAME = tiig.INDEX_NAME

Line 2728: FROM fem_tab_indx_info_gt tiig,

2724: ---------------------------------
2725:
2726: SELECT tiig.table_name, tig.owner
2727: INTO x_tab_name,x_tab_owner
2728: FROM fem_tab_indx_info_gt tiig,
2729: fem_tab_info_gt tig
2730: WHERE tig.table_name = tiig.table_name
2731: AND tiig.INDEX_NAME = p_index_name
2732: AND tig.owner is NOT NULL