APPS.GCS_CREATE_DYN_INDEX_PKG dependencies on FEM_TAB_COLUMN_PROP

Line 12: FROM fem_tab_column_prop ftcp,

8:
9: CURSOR v_active_dims IS
10: SELECT DECODE(ftcp.column_name, 'INTERCOMPANY_ID', 'INTERCOMPANY_DISPLAY_CODE',
11: dtc.column_name) active_columns
12: FROM fem_tab_column_prop ftcp,
13: fem_tab_columns_b ftcb,
14: fem_xdim_dimensions fxd,
15: dba_tab_columns dtc
16: WHERE ftcp.table_name = 'FEM_BALANCES'

Line 95: FROM FEM_TAB_COLUMN_PROP

91: --Bugfix 5498824: No longer check if processing key has been set. Check if rows exist in the data table
92: /*
93: SELECT count(*)
94: INTO rowcount
95: FROM FEM_TAB_COLUMN_PROP
96: WHERE table_name = l_data_table
97: AND column_property_code = 'PROCESSING_KEY';
98: */
99: EXECUTE IMMEDIATE 'select count(1) from ' || l_data_table INTO rowcount;

Line 108: DELETE FROM fem_tab_column_prop

104: IF (rowcount = 0) THEN
105:
106: --Bugfix 5498824: Clean up formatting and drop all indices in data directionary
107: -- generate the processing key
108: DELETE FROM fem_tab_column_prop
109: WHERE table_name = l_data_table
110: AND column_property_code = 'PROCESSING_KEY';
111:
112: INSERT INTO FEM_TAB_COLUMN_PROP

Line 112: INSERT INTO FEM_TAB_COLUMN_PROP

108: DELETE FROM fem_tab_column_prop
109: WHERE table_name = l_data_table
110: AND column_property_code = 'PROCESSING_KEY';
111:
112: INSERT INTO FEM_TAB_COLUMN_PROP
113: ( table_name,
114: column_name,
115: column_property_code,
116: creation_date, created_by,