Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the coverage or benefit provided by the electable choices available to an eligible person as a result of a life event or open enrollment. |
Implementation/DBA Data: | APPS.BENBV_ENRT_BNFT_V |
SELECT ENB.PROGRAM_UPDATE_DATE
, ENB.VAL
, ENB.NNMNTRY_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, ENB.NNMNTRY_UOM)
, ENB.MN_VAL
, ENB.MX_VAL
, ENB.INCRMT_VAL
, ENB.ORDR_NUM
, ENB.DFLT_VAL
, ENB.MX_WOUT_CTFN_VAL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_BNFT:ENB'
, /* CODES */ ENB.BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD'
, ENB.BNDRY_PERD_CD)
, ENB.BNFT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_TYP'
, ENB.BNFT_TYP_CD)
, ENB.RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP'
, ENB.RT_TYP_CD)
, ENB.CVG_MLT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CVG_MLT'
, ENB.CVG_MLT_CD)
, ENB.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENB.DFLT_FLAG)
, ENB.VAL_HAS_BN_PRORTD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENB.VAL_HAS_BN_PRORTD_FLAG)
, ENB.CTFN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENB.CTFN_RQD_FLAG)
, ENB.CRNTLY_ENRLD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENB.CRNTLY_ENRLD_FLAG)
, ENB.ENTR_VAL_AT_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENB.ENTR_VAL_AT_ENRT_FLAG)
, ENB.MX_WO_CTFN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENB.MX_WO_CTFN_FLAG)
, /* ID COLUMNS */ ENB.ENRT_BNFT_ID
, ENB.BUSINESS_GROUP_ID
, ENB.ELIG_PER_ELCTBL_CHC_ID
, ENB.COMP_LVL_FCTR_ID
, ENB.REQUEST_ID
, ENB.PROGRAM_APPLICATION_ID
, ENB.PROGRAM_ID
, ENB.PRTT_ENRT_RSLT_ID
, /* WHO COLUMNS */ ENB.LAST_UPDATE_DATE
, ENB.LAST_UPDATED_BY
, ENB.CREATED_BY
, ENB.CREATION_DATE
FROM BEN_ENRT_BNFT ENB
WHERE ENB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ENB.BUSINESS_GROUP_ID) WITH READ ONLY