APPS.GCS_BUILD_EPB_DIM_TR_PKG dependencies on FEM_VALUE_SETS_B

Line 146: FROM fem_value_sets_b

142: -- get the value set name
143: begin
144: SELECT value_set_display_code, value_set_id
145: INTO l_felm_value_set, l_fe_value_setid
146: FROM fem_value_sets_b
147: WHERE value_set_id = ( SELECT gvs.value_set_id
148: FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
149: WHERE gvs.global_vs_combo_id = l_global_vs_id
150: AND dim.fem_data_type_code = 'DIMENSION'

Line 193: FROM fem_value_sets_b

189: -- get the value set name
190: begin
191: SELECT value_set_display_code, value_set_id
192: INTO l_interco_value_set, l_interco_value_setid
193: FROM fem_value_sets_b
194: WHERE value_set_id = ( SELECT gvs.value_set_id
195: FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
196: WHERE gvs.global_vs_combo_id = l_global_vs_id
197: AND dim.fem_data_type_code = 'DIMENSION'

Line 239: FROM fem_value_sets_b

235: -- get the value set name
236: begin
237: SELECT value_set_display_code, value_set_id
238: INTO l_na_value_set, l_na_value_setid
239: FROM fem_value_sets_b
240: WHERE value_set_id = ( SELECT gvs.value_set_id
241: FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
242: WHERE gvs.global_vs_combo_id = l_global_vs_id
243: AND dim.fem_data_type_code = 'DIMENSION'

Line 292: FROM fem_value_sets_b

288: -- get the value set name
289: begin
290: SELECT value_set_display_code, value_set_id
291: INTO l_cat_value_set, l_cat_value_setid
292: FROM fem_value_sets_b
293: WHERE value_set_id = ( SELECT gvs.value_set_id
294: FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
295: WHERE gvs.global_vs_combo_id = l_global_vs_id
296: AND dim.fem_data_type_code = 'DIMENSION'