DBA Data[Home] [Help]

APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_DIMENSIONS_VL

Line 2126: fem_dimensions_vl T

2122: cursor c_dimcomp (p_cond_comp_obj_def_id IN NUMBER) IS
2123: SELECT D.dim_comp_type, D.dim_id, D.dim_column, D.value,
2124: T.dimension_name
2125: FROM fem_cond_dim_components D,
2126: fem_dimensions_vl T
2127: WHERE D.cond_dim_cmp_obj_def_id = p_cond_comp_obj_def_id
2128: AND D.dim_id = T.dimension_id;
2129:
2130:

Line 2934: FROM fem_dimensions_vl D, fem_factor_table_dims F

2930:
2931: -- Identify the factor table dimensions for that Factor Table Object:
2932: cursor c_dim (p_object_definition_id IN NUMBER) IS
2933: SELECT D.dimension_name, F.hier_object_id, F.hier_group_id, F.hier_relation_code
2934: FROM fem_dimensions_vl D, fem_factor_table_dims F
2935: WHERE F.dimension_id = D.dimension_id
2936: AND F.object_definition_id = p_object_definition_id
2937: AND F.dim_usage_code = 'MATCH';
2938: