VIEW: APPS.BENBV_ENRT_RT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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