[Home] [Help]
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'
151: AND gvs.dimension_id = dim.dimension_id
152: AND dim.table_name = 'FEM_BALANCES'
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'
198: AND gvs.dimension_id = dim.dimension_id
199: AND dim.table_name = 'FEM_BALANCES'
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'
244: AND dim.table_name = 'FEM_BALANCES'
245: AND gvs.dimension_id = dim.dimension_id
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'
297: AND gvs.dimension_id = dim.dimension_id
298: AND dim.table_name = 'FEM_BALANCES'