VIEW: APPS.BEN_ELCTBL_CHC_ENRT_RT_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')