Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the rates calculated for a person for a plan or option in plan. It also identifies flexible credit values and imputed income values. |
Implementation/DBA Data: | APPS.BENBV_ENRT_RT_V |
SELECT ECR.RT_STRT_DT
, ECR.RT_STRT_DT_RL
, ECR.PROGRAM_UPDATE_DATE
, ECR.DFLT_VAL
, ECR.ANN_VAL
, ECR.ANN_MN_ELCN_VAL
, ECR.ANN_MX_ELCN_VAL
, ECR.VAL
, ECR.NNMNTRY_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, ECR.NNMNTRY_UOM)
, ECR.MX_ELCN_VAL
, ECR.MN_ELCN_VAL
, ECR.INCRMT_ELCN_VAL
, ECR.CMCD_MN_ELCN_VAL
, ECR.CMCD_MX_ELCN_VAL
, ECR.CMCD_VAL
, ECR.CMCD_DFLT_VAL
, ECR.ANN_DFLT_VAL
, ECR.DSPLY_MN_ELCN_VAL
, ECR.DSPLY_MX_ELCN_VAL
, ECR.ISS_VAL
, ECR.VAL_LAST_UPD_DATE
, ECR.PP_IN_YR_USED_NUM
, ECR.ORDR_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_RT:ECR'
, /* CODES */ ECR.ACTY_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_TYP'
, ECR.ACTY_TYP_CD)
, ECR.TX_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TX_TYP'
, ECR.TX_TYP_CD)
, ECR.RT_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_STRT'
, ECR.RT_STRT_DT_CD)
, ECR.RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP'
, ECR.RT_TYP_CD)
, ECR.CMCD_ACTY_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ'
, ECR.CMCD_ACTY_REF_PERD_CD)
, ECR.RT_USG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_USG'
, ECR.RT_USG_CD)
, ECR.BNFT_RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_RT_TYP'
, ECR.BNFT_RT_TYP_CD)
, ECR.RT_MLT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MLT'
, ECR.RT_MLT_CD)
, ECR.CTFN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.CTFN_RQD_FLAG)
, ECR.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.DFLT_FLAG)
, ECR.DFLT_PNDG_CTFN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.DFLT_PNDG_CTFN_FLAG)
, ECR.DSPLY_ON_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.DSPLY_ON_ENRT_FLAG)
, ECR.USE_TO_CALC_NET_FLX_CR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.USE_TO_CALC_NET_FLX_CR_FLAG)
, ECR.ENTR_VAL_AT_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.ENTR_VAL_AT_ENRT_FLAG)
, ECR.ASN_ON_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.ASN_ON_ENRT_FLAG)
, ECR.RL_CRS_ONLY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.RL_CRS_ONLY_FLAG)
, ECR.ENTR_ANN_VAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ECR.ENTR_ANN_VAL_FLAG)
, /* ID COLUMNS */ ECR.ENRT_RT_ID
, ECR.BUSINESS_GROUP_ID
, ECR.ACTY_BASE_RT_ID
, ECR.ELIG_PER_ELCTBL_CHC_ID
, ECR.SPCL_RT_ENRT_RT_ID
, ECR.ENRT_BNFT_ID
, ECR.CVG_AMT_CALC_MTHD_ID
, ECR.ACTL_PREM_ID
, ECR.COMP_LVL_FCTR_ID
, ECR.PTD_COMP_LVL_FCTR_ID
, ECR.CLM_COMP_LVL_FCTR_ID
, ECR.REQUEST_ID
, ECR.PROGRAM_APPLICATION_ID
, ECR.PROGRAM_ID
, ECR.DECR_BNFT_PRVDR_POOL_ID
, ECR.PRTT_RT_VAL_ID
, ECR.VAL_LAST_UPD_PERSON_ID
, /* WHO COLUMNS */ ECR.CREATED_BY
, ECR.CREATION_DATE
, ECR.LAST_UPDATED_BY
, ECR.LAST_UPDATE_DATE
FROM BEN_ENRT_RT ECR
WHERE ECR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ECR.BUSINESS_GROUP_ID) WITH READ ONLY