View: BEN_ENRT_RSLT_LOV_INFO_LE_V

Product:	BEN - Advanced Benefits
Description:	A supplementary view used to simplify forms coding.
Implementation/DBA Data:	APPS.BEN_ENRT_RSLT_LOV_INFO_LE_V

View Text

SELECT PEN.PRTT_ENRT_RSLT_ID
, PEN.OIPL_ID
, PEN.PERSON_ID
, PEN.PGM_ID
, PEN.PL_ID
, PEN.PTIP_ID
, PEN.PL_TYP_ID
, PEN.LER_ID
, PEN.PER_IN_LER_ID
, PEN.SSPNDD_FLAG
, PLN.NAME
, PGM.NAME
, OPT.NAME
, TYP.NAME
, LER.NAME
, PEN.EFFECTIVE_START_DATE
, PEN.EFFECTIVE_END_DATE
, PEN.BUSINESS_GROUP_ID
, PEN.OBJECT_VERSION_NUMBER
FROM BEN_PRTT_ENRT_RSLT_F PEN
, BEN_PER_IN_LER PIL
, BEN_PL_F PLN
, BEN_PGM_F PGM
, BEN_PL_TYP_F TYP
, BEN_OIPL_F OIPL
, BEN_OPT_F OPT
, BEN_LER_F LER
, FND_SESSIONS SE
WHERE PEN.PER_IN_LER_ID = PIL.PER_IN_LER_ID
AND PIL.PER_IN_LER_STAT_CD = 'STRTD'
AND PEN.PRTT_ENRT_RSLT_STAT_CD IS NULL
AND SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PEN.EFFECTIVE_START_DATE
AND PEN.EFFECTIVE_END_DATE
AND PEN.PL_ID = PLN.PL_ID
AND PLN.PL_STAT_CD = 'A'
AND PIL.LF_EVT_OCRD_DT BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE
AND PEN.PL_TYP_ID = TYP.PL_TYP_ID
AND TYP.PL_TYP_STAT_CD = 'A'
AND PIL.LF_EVT_OCRD_DT BETWEEN TYP.EFFECTIVE_START_DATE
AND TYP.EFFECTIVE_END_DATE
AND PEN.LER_ID = LER.LER_ID
AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE
AND LER.EFFECTIVE_END_DATE
AND PEN.PGM_ID = PGM.PGM_ID(+)
AND PGM.PGM_STAT_CD(+) = 'A'
AND PIL.LF_EVT_OCRD_DT BETWEEN NVL(PGM.EFFECTIVE_START_DATE
, PIL.LF_EVT_OCRD_DT)
AND NVL(PGM.EFFECTIVE_END_DATE
, PIL.LF_EVT_OCRD_DT)
AND PEN.OIPL_ID = OIPL.OIPL_ID(+)
AND OIPL.OIPL_STAT_CD(+) = 'A'
AND PIL.LF_EVT_OCRD_DT BETWEEN NVL(OIPL.EFFECTIVE_START_DATE
, PIL.LF_EVT_OCRD_DT)
AND NVL(OIPL.EFFECTIVE_END_DATE
, PIL.LF_EVT_OCRD_DT)
AND OIPL.OPT_ID = OPT.OPT_ID(+)
AND PIL.LF_EVT_OCRD_DT BETWEEN NVL(OPT.EFFECTIVE_START_DATE
, PIL.LF_EVT_OCRD_DT)
AND NVL(OPT.EFFECTIVE_END_DATE
, PIL.LF_EVT_OCRD_DT)

Columns