APPS.ZPB_FEM_UTILS_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 498: FEM_DIM_ATTR_VERSIONS_B D

494: B.LOGICAL_DIM_ID, B.DIMENSION_ID
495: from
496: ZPB_BUSAREA_CONDITIONS_V B,
497: ZPB_BUSAREA_VERSIONS C,
498: FEM_DIM_ATTR_VERSIONS_B D
499: where
500: B.ATTRIBUTE_ID = D.ATTRIBUTE_ID
501: and D.DEFAULT_VERSION_FLAG = 'Y'
502: and B.VERSION_ID = C.VERSION_ID

Line 548: FEM_DIM_ATTR_VERSIONS_B E, ZPB_BUSAREA_VERSIONS F

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
551: and E.DEFAULT_VERSION_FLAG = 'Y'
552: and E.AW_SNAPSHOT_FLAG = 'N'

Line 721: FEM_DIM_ATTR_VERSIONS_B D

717: B.ATTRIBUTE_VALUE_COLUMN_NAME COL_NAME, B.OPERATION
718: from
719: ZPB_BUSAREA_CONDITIONS_V B,
720: ZPB_BUSAREA_VERSIONS C,
721: FEM_DIM_ATTR_VERSIONS_B D
722: where
723: B.ATTRIBUTE_ID = D.ATTRIBUTE_ID
724: and D.DEFAULT_VERSION_FLAG = 'Y'
725: and B.VERSION_ID = C.VERSION_ID

Line 781: FEM_DIM_ATTR_VERSIONS_B E, ZPB_BUSAREA_VERSIONS F

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
784: and E.DEFAULT_VERSION_FLAG = 'Y'
785: and E.AW_SNAPSHOT_FLAG = 'N'