DBA Data[Home] [Help]

APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_COND_DIM_COMPONENTS

Line 2125: FROM fem_cond_dim_components D,

2121:
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:

Line 2143: FROM fem_dim_attributes_vl A, fem_cond_dim_cmp_dtl D, fem_cond_dim_components C

2139:
2140: cursor c_attr (p_cond_obj_def_id IN NUMBER, p_dimension_id IN NUMBER) IS
2141: SELECT A.attribute_id, A.attribute_name, A.attribute_dimension_id,
2142: A.attribute_data_type_code, D.dim_attr_value
2143: FROM fem_dim_attributes_vl A, fem_cond_dim_cmp_dtl D, fem_cond_dim_components C
2144: WHERE A.dimension_id = p_dimension_id
2145: AND A.dimension_id = C.dim_id
2146: AND D.cond_dim_cmp_obj_def_id = p_cond_obj_def_id
2147: AND D.cond_dim_cmp_obj_def_id = C.cond_dim_cmp_obj_def_id