APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_TAB_COLUMNS_B

Line 2908: -- FEM_ALLOC_BR_DIMENSIONS, FEM_TAB_COLUMNS_B, and FEM_XDIM_DIMENSIONS

2904: -- set all parameters to NULL.
2905: --
2906: -- If mapping rule type is By Dimension and preview group is Source,
2907: -- then get the parameter values from these tables:
2908: -- FEM_ALLOC_BR_DIMENSIONS, FEM_TAB_COLUMNS_B, and FEM_XDIM_DIMENSIONS
2909: --
2910: -------------------------------------------------------------------------------
2911: PROCEDURE GetByDimParams(
2912: p_preview_obj_def_id IN NUMBER,

Line 2945: FROM fem_alloc_br_dimensions abd, fem_tab_columns_b tc,

2941: SELECT abd.alloc_dim_col_name, xd.dimension_id,
2942: decode(xd.member_data_type_code,'NUMBER',abd.dimension_value,
2943: abd.dimension_value_char)
2944: INTO x_by_dimension_column, x_by_dimension_id, x_by_dimension_value
2945: FROM fem_alloc_br_dimensions abd, fem_tab_columns_b tc,
2946: fem_xdim_dimensions xd
2947: WHERE abd.object_definition_id = p_map_obj_def_id
2948: AND abd.function_cd = C_BYDIM_FUNCIONCD
2949: AND tc.table_name = p_fact_table_name