APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_COND_DIM_CMP_DTL

Line 2134: FROM fem_cond_dim_cmp_dtl D

2130:
2131: cursor c_hier (p_cond_obj_def_id IN NUMBER) IS
2132: SELECT D.hierarchy_obj_id, O.object_name
2133: FROM (SELECT DISTINCT hierarchy_obj_id
2134: FROM fem_cond_dim_cmp_dtl D
2135: WHERE cond_dim_cmp_obj_def_id = p_cond_obj_def_id) D,
2136: fem_object_catalog_vl O
2137: WHERE D.hierarchy_obj_id = O.object_id;
2138:

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