DBA Data[Home] [Help]

APPS.ZPB_FEM_UTILS_PKG dependencies on ZPB_BUSAREA_HIER_MEMBERS

Line 734: from ZPB_BUSAREA_HIER_MEMBERS A,

730:
731: cursor members(p_hierarchy NUMBER,p_hier_vers NUMBER,p_vset VARCHAR2) is
732: select decode(p_vset, 'Y', A.VALUE_SET_ID||'_'||A.MEMBER_ID,
733: A.MEMBER_ID) MEMBER_ID
734: from ZPB_BUSAREA_HIER_MEMBERS A,
735: ZPB_BUSAREA_VERSIONS B
736: where A.HIERARCHY_ID = p_hierarchy
737: and nvl(A.HIER_VERSION_ID, -1) = nvl(p_hier_vers, -1)
738: and A.VERSION_ID = B.VERSION_ID