View: BEN_ELCTBL_CHC_ENRT_RT_V

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

View Text

SELECT OPT.NAME NAME
, EPE.ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID_EPE
, EPE.CRNTLY_ENRD_FLAG
, EPE.DFLT_FLAG DFLT_FLAG_EPE
, EPE.ELCTBL_FLAG
, EPE.PL_ID
, EPE.OIPL_ID
, EPE.PER_IN_LER_ID
, EPE.BUSINESS_GROUP_ID
, ECR.ENRT_RT_ID
, ECR.ACTY_TYP_CD
, ECR.TX_TYP_CD
, ECR.CTFN_RQD_FLAG
, ECR.DSPLY_ON_ENRT_FLAG
, ECR.ENTR_VAL_AT_ENRT_FLAG
, NVL(ECR.DFLT_VAL
, ECR.VAL) VAL
, ECR.MX_ELCN_VAL
, ECR.MN_ELCN_VAL
, ECR.INCRMT_ELCN_VAL
, EPE.OIPL_ORDR_NUM
FROM BEN_ELIG_PER_ELCTBL_CHC EPE
, BEN_PER_IN_LER PIL
, BEN_ENRT_RT ECR
, BEN_OIPL_F COP
, BEN_OPT_F OPT
, FND_SESSIONS FND
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND EPE.ELIG_PER_ELCTBL_CHC_ID = ECR.ELIG_PER_ELCTBL_CHC_ID(+)
AND EPE.BUSINESS_GROUP_ID = ECR.BUSINESS_GROUP_ID(+)
AND EPE.ELCTBL_FLAG = 'Y'
AND EPE.OIPL_ID = COP.OIPL_ID
AND COP.OIPL_STAT_CD = 'A'
AND FND.EFFECTIVE_DATE BETWEEN COP.EFFECTIVE_START_DATE
AND COP.EFFECTIVE_END_DATE
AND EPE.BUSINESS_GROUP_ID = COP.BUSINESS_GROUP_ID
AND COP.OPT_ID = OPT.OPT_ID
AND COP.BUSINESS_GROUP_ID = OPT.BUSINESS_GROUP_ID
AND FND.EFFECTIVE_DATE BETWEEN OPT.EFFECTIVE_START_DATE
AND OPT.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID=EPE.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID=EPE.BUSINESS_GROUP_ID
AND PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT')

Columns