VIEW: APPS.BEN_ENRT_PGM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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