APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_BUSAREA_HIERARCHIES

Line 311: from ZPB_BUSAREA_HIERARCHIES A, ZPB_BUSAREA_VERSIONS B,

307: cursor hiers is
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

Line 688: l_top_mbrs ZPB_BUSAREA_HIERARCHIES.INCLUDE_ALL_TOP_MEMBERS%type;

684: l_pers_flag FEM_XDIM_DIMENSIONS.HIER_EDITOR_MANAGED_FLAG%type;
685: l_use_cond ZPB_BUSAREA_DIMENSIONS.USE_MEMBER_CONDITIONS%type;
686: l_cond_anc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_ANC%type;
687: l_cond_desc ZPB_BUSAREA_DIMENSIONS.CONDITIONS_INCL_DESC%type;
688: l_top_mbrs ZPB_BUSAREA_HIERARCHIES.INCLUDE_ALL_TOP_MEMBERS%type;
689: l_operation ZPB_BUSAREA_CONDITIONS.OPERATION%type;
690: l_vset_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%type;
691: l_ret ZPB_HIER_MEMBER_OBJ;
692:

Line 705: ZPB_BUSAREA_HIERARCHIES C,

701: C.INCLUDE_ALL_TOP_MEMBERS, C.INCLUDE_ALL_LEVELS,
702: A.LOGICAL_DIM_ID
703: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES
704: (l_business_area, p_version_type)) A,
705: ZPB_BUSAREA_HIERARCHIES C,
706: ZPB_BUSAREA_VERSIONS D
707: where
708: A.LOGICAL_DIM_ID = p_logical_dim_id
709: and A.HIERARCHY_ID = C.HIERARCHY_ID