VIEW: APPS.BEN_ELIG_PER_F_V1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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