APPS.ZPB_FEM_UTILS_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 250: from FEM_XDIM_DIMENSIONS A, FEM_HIERARCHIES B, FEM_OBJECT_DEFINITION_B C

246: l_ret := ZPB_MEMBER_TABLE_OBJ(null, null, null, null);
247:
248: select A.DIMENSION_ID, A.VALUE_SET_REQUIRED_FLAG, A.HIERARCHY_TABLE_NAME
249: into l_dimension_id, l_vs_req, l_hier_table
250: from FEM_XDIM_DIMENSIONS A, FEM_HIERARCHIES B, FEM_OBJECT_DEFINITION_B C
251: where A.DIMENSION_ID = B.DIMENSION_ID
252: and B.HIERARCHY_OBJ_ID = C.OBJECT_ID
253: and C.OBJECT_DEFINITION_ID = p_hier_vers_id;
254:

Line 312: FEM_OBJECT_DEFINITION_B C

308: select A.HIERARCHY_ID, C.OBJECT_DEFINITION_ID, A.KEEP_VERSION,
309: A.NUMBER_OF_VERSIONS, A.VERSION_ID,
310: A.LOGICAL_DIM_ID
311: from ZPB_BUSAREA_HIERARCHIES A, ZPB_BUSAREA_VERSIONS B,
312: FEM_OBJECT_DEFINITION_B C
313: where A.VERSION_ID = B.VERSION_ID
314: and B.VERSION_TYPE = p_version_type
315: and B.BUSINESS_AREA_ID = l_business_area
316: and A.HIERARCHY_ID = C.OBJECT_ID

Line 331: from FEM_OBJECT_DEFINITION_B

327: and HIERARCHY_ID = l_hier;
328:
329: cursor hier_last_vers(l_hier number) is
330: select OBJECT_DEFINITION_ID
331: from FEM_OBJECT_DEFINITION_B
332: where OBJECT_ID = l_hier
333: and EFFECTIVE_START_DATE < sysdate
334: order by EFFECTIVE_END_DATE DESC;
335: begin