DBA Data[Home] [Help]

APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_BUSAREA_HIER_VERSIONS

Line 324: from ZPB_BUSAREA_HIER_VERSIONS

320: cursor hier_spec_vers(l_vers number,
321: l_logical_dim_id number,
322: l_hier number) is
323: select HIER_VERSION_ID
324: from ZPB_BUSAREA_HIER_VERSIONS
325: where VERSION_ID = l_vers
326: and LOGICAL_DIM_ID = l_logical_dim_id
327: and HIERARCHY_ID = l_hier;
328:

Line 867: from ZPB_BUSAREA_HIER_VERSIONS A,

863: l_ret.VERSION_ID := each.VERSION_ID;
864: begin
865: select A.INCLUDE_ALL_TOP_MEMBERS
866: into l_top_mbrs
867: from ZPB_BUSAREA_HIER_VERSIONS A,
868: ZPB_BUSAREA_VERSIONS B
869: where A.VERSION_ID = B.VERSION_ID
870: and B.BUSINESS_AREA_ID = l_business_area
871: and B.VERSION_TYPE = p_version_type