Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_BACK_OUT_CHC_BNFT_V |
SELECT EPE.PER_IN_LER_ID
, EPE.PIL_ELCTBL_CHC_POPL_ID
, EPE.BUSINESS_GROUP_ID
, EPE.PL_ID
, EPE.OIPL_ID
, ENB.VAL
, EPE.PL_TYP_ID
, ENB.NNMNTRY_UOM
, EPE.CRNTLY_ENRD_FLAG
, EPE.ENRT_CVG_STRT_DT_CD
, EPE.ENRT_CVG_STRT_DT
, EPE.DPNT_DSGN_CD
, EPE.LER_CHG_DPNT_CVG_CD
, EPE.DPNT_CVG_STRT_DT_CD
, ENB.BNFT_TYP_CD
, ENB.CVG_MLT_CD
, ENB.ENTR_VAL_AT_ENRT_FLAG
, ENB.MN_VAL
, ENB.MX_VAL
, ENB.INCRMT_VAL
, ENB.DFLT_VAL
, EPE.ELCTBL_FLAG
, EPE.CTFN_RQD_FLAG
, EPE.MUST_ENRL_ANTHR_PL_ID
, EPE.ELIG_PER_ELCTBL_CHC_ID
, DECODE(ENB.ENRT_BNFT_ID
, NULL
, EPE.ELIG_PER_ELCTBL_CHC_ID
, NULL) FAKE_CHOICE_ID
, EPE.ERLST_DEENRT_DT
, ENB.ENRT_BNFT_ID
, EPE.DFLT_FLAG
, EPE.MNDTRY_FLAG
, EPE.AUTO_ENRT_FLAG
, EPE.ROLL_CRS_FLAG
, EPE.PTIP_ORDR_NUM
, EPE.PLIP_ORDR_NUM
, EPE.PL_ORDR_NUM
, EPE.OIPL_ORDR_NUM
, ENB.ORDR_NUM ENB_ORDR_NUM
, EPE.EPE_ATTRIBUTE_CATEGORY
, EPE.EPE_ATTRIBUTE1
, EPE.EPE_ATTRIBUTE2
, EPE.EPE_ATTRIBUTE3
, EPE.EPE_ATTRIBUTE4
, EPE.EPE_ATTRIBUTE5
, EPE.EPE_ATTRIBUTE6
, EPE.EPE_ATTRIBUTE7
, EPE.EPE_ATTRIBUTE8
, EPE.EPE_ATTRIBUTE9
, EPE.EPE_ATTRIBUTE10
, EPE.EPE_ATTRIBUTE11
, EPE.EPE_ATTRIBUTE12
, EPE.EPE_ATTRIBUTE13
, EPE.EPE_ATTRIBUTE14
, EPE.EPE_ATTRIBUTE15
, EPE.EPE_ATTRIBUTE16
, EPE.EPE_ATTRIBUTE17
, EPE.EPE_ATTRIBUTE18
, EPE.EPE_ATTRIBUTE19
, EPE.EPE_ATTRIBUTE20
, EPE.EPE_ATTRIBUTE21
, EPE.EPE_ATTRIBUTE22
, EPE.EPE_ATTRIBUTE23
, EPE.EPE_ATTRIBUTE24
, EPE.EPE_ATTRIBUTE25
, EPE.EPE_ATTRIBUTE26
, EPE.EPE_ATTRIBUTE27
, EPE.EPE_ATTRIBUTE28
, EPE.EPE_ATTRIBUTE29
, EPE.EPE_ATTRIBUTE30
, EPE.LAST_UPDATE_DATE
, EPE.LAST_UPDATED_BY
, EPE.LAST_UPDATE_LOGIN
, EPE.CREATED_BY
, EPE.CREATION_DATE
, EPE.REQUEST_ID
, EPE.PROGRAM_APPLICATION_ID
, EPE.PROGRAM_ID
, EPE.PROGRAM_UPDATE_DATE
, EPE.OBJECT_VERSION_NUMBER
FROM BEN_ENRT_BNFT ENB
, BEN_ELIG_PER_ELCTBL_CHC EPE
WHERE ENB.ELIG_PER_ELCTBL_CHC_ID (+) = EPE.ELIG_PER_ELCTBL_CHC_ID