View: BEN_ENRT_PGM_V

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

View Text

SELECT DISTINCT PEN.PGM_ID
, NVL(PGM.NAME
, H.MEANING)
, PEN.PERSON_ID
, PEN.BUSINESS_GROUP_ID
FROM BEN_PRTT_ENRT_RSLT_F PEN
, BEN_PGM_F PGM
, FND_SESSIONS SE
, HR_LOOKUPS H
WHERE PEN.PRTT_ENRT_RSLT_STAT_CD IS NULL
AND PEN.PGM_ID = PGM.PGM_ID(+)
AND PEN.BUSINESS_GROUP_ID = NVL(PGM.BUSINESS_GROUP_ID
, PEN.BUSINESS_GROUP_ID)
AND SE.EFFECTIVE_DATE BETWEEN NVL(PGM.EFFECTIVE_START_DATE
, SE.EFFECTIVE_DATE)
AND NVL(PGM.EFFECTIVE_END_DATE
, SE.EFFECTIVE_DATE)
AND SE.SESSION_ID = USERENV('SESSIONID')
AND H.LOOKUP_TYPE = 'BEN_PL'
AND H.LOOKUP_CODE = 'MYNTBPGM' ORDER BY 2

Columns