View: BEN_ELIG_PER_F_V1

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

View Text

SELECT PEP.PGM_ID
, NAME
, PEP.PERSON_ID
, PEP.BUSINESS_GROUP_ID
FROM BEN_ELIG_PER_F PEP
, BEN_PER_IN_LER PIL
, BEN_PGM_F PGM
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PEP.EFFECTIVE_START_DATE
AND PEP.EFFECTIVE_END_DATE
AND PEP.PGM_ID (+) = PGM.PGM_ID
AND SE.EFFECTIVE_DATE BETWEEN PGM.EFFECTIVE_START_DATE
AND PGM.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID(+)=PEP.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PEP.BUSINESS_GROUP_ID+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL ) GROUP BY PEP.PGM_ID
, NAME
, PEP.PERSON_ID
, PEP.BUSINESS_GROUP_ID

Columns