View: BEN_ENRT_BNF_PLAN_V

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

View Text

SELECT PEN.PRTT_ENRT_RSLT_ID
, PEN.PL_ID
, PEN.OIPL_ID
, PEN.UOM
, PEN.ENRT_CVG_STRT_DT
, PEN.EFFECTIVE_START_DATE
, PEN.EFFECTIVE_END_DATE
, PEN.BUSINESS_GROUP_ID
, PEN.PERSON_ID
, PEN.ENRT_CVG_THRU_DT
, PEN.OBJECT_VERSION_NUMBER
, PEN.PER_IN_LER_ID
FROM BEN_PRTT_ENRT_RSLT_F PEN
, BEN_PL_F PL
, FND_SESSIONS SE
WHERE SE.EFFECTIVE_DATE BETWEEN PEN.EFFECTIVE_START_DATE
AND PEN.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE <= PEN.ENRT_CVG_THRU_DT
AND PEN.PRTT_ENRT_RSLT_STAT_CD IS NULL
AND PEN.PL_ID = PL.PL_ID
AND PEN.BUSINESS_GROUP_ID = PL.BUSINESS_GROUP_ID
AND PL.BNF_DSGN_CD IS NOT NULL
AND PL.PL_STAT_CD = 'A'
AND SE.EFFECTIVE_DATE BETWEEN PL.EFFECTIVE_START_DATE
AND PL.EFFECTIVE_END_DATE
AND (PL.SVGS_PL_FLAG <> 'Y' OR PEN.OIPL_ID IS NULL)
AND SE.SESSION_ID = USERENV('SESSIONID')

Columns