View: BEN_FLX_ENRT_UOM_INFO_V

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_FLX_ENRT_UOM_INFO_V

View Text

SELECT DISTINCT PEL.UOM
, PEL.ACTY_REF_PERD_CD
, HL1.MEANING
, PIL.PERSON_ID
, PIL.LER_ID
, EPE.PER_IN_LER_ID
, EPE.PGM_ID
, EPE.BUSINESS_GROUP_ID
FROM BEN_ELIG_PER_ELCTBL_CHC EPE
, BEN_PIL_ELCTBL_CHC_POPL PEL
, BEN_PER_IN_LER PIL
, HR_LOOKUPS HL1
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN NVL(HL1.START_DATE_ACTIVE
, SE.EFFECTIVE_DATE)
AND NVL(HL1.END_DATE_ACTIVE
, SE.EFFECTIVE_DATE)
AND HL1.ENABLED_FLAG = 'Y'
AND HL1.LOOKUP_TYPE = 'BEN_ACTY_REF_PERD'
AND PEL.ACTY_REF_PERD_CD = HL1.LOOKUP_CODE
AND PIL.PER_IN_LER_ID = PEL.PER_IN_LER_ID
AND PEL.PGM_ID = EPE.PGM_ID
AND PIL.PER_IN_LER_ID=EPE.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID+0=EPE.BUSINESS_GROUP_ID+0
AND PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT')

Columns