DBA Data[Home] [Help]

APPS.ZPB_FEM_UTILS_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 546: from FEM_GLOBAL_VS_COMBO_DEFS A, ZPB_BUSAREA_LEDGERS B,

542:
543: if (l_vs_req = 'Y') then
544: select distinct (A.VALUE_SET_ID)
545: into l_vset_id
546: from FEM_GLOBAL_VS_COMBO_DEFS A, ZPB_BUSAREA_LEDGERS B,
547: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
548: FEM_DIM_ATTR_VERSIONS_B E, ZPB_BUSAREA_VERSIONS F
549: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
550: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID

Line 690: l_vset_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%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:
693: l_curs EPB_CURS_TYPE;
694: l_member_hash MEMBER_HASH_TYPE;

Line 779: from FEM_GLOBAL_VS_COMBO_DEFS A, ZPB_BUSAREA_LEDGERS B,

775:
776: if (l_vs_req = 'Y') then
777: select distinct (A.VALUE_SET_ID)
778: into l_vset_id
779: from FEM_GLOBAL_VS_COMBO_DEFS A, ZPB_BUSAREA_LEDGERS B,
780: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
781: FEM_DIM_ATTR_VERSIONS_B E, ZPB_BUSAREA_VERSIONS F
782: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
783: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID