VIEW: APPS.BEN_BACK_OUT_CHC_BNFT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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