VIEW: APPS.BENBV_ENRT_BNFT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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