VIEW: APPS.BENBV_LER_BNFT_RSTRN_V

Source

View Text - Preformatted

SELECT LBR.EFFECTIVE_START_DATE, LBR.EFFECTIVE_END_DATE, LBR.DFLT_TO_ASN_PNDG_CTFN_RL, LBR.MX_CVG_INCR_WCF_ALWD_AMT, LBR.MX_CVG_INCR_ALWD_AMT, LBR.MX_CVG_ALWD_AMT, LBR.MX_CVG_MLT_INCR_NUM, LBR.MX_CVG_MLT_INCR_WCF_NUM, LBR.MX_CVG_RL, LBR.MX_CVG_WCFN_AMT, LBR.MX_CVG_WCFN_MLT_NUM, LBR.MN_CVG_AMT, LBR.MN_CVG_RL, /* descriptive flexfield */ '_DF:BEN:BEN_LER_BNFT_RSTRN_F:LBR', /* codes */ LBR.DFLT_TO_ASN_PNDG_CTFN_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_DFLT_TO_ASN_PNDG_CTFN',LBR.DFLT_TO_ASN_PNDG_CTFN_CD), LBR.CVG_INCR_R_DECR_ONLY_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CVG_INCR_R_DECR_ONLY',LBR.CVG_INCR_R_DECR_ONLY_CD), LBR.UNSSPND_ENRT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_UNSSPND_ENRT',LBR.UNSSPND_ENRT_CD), LBR.NO_MN_CVG_INCR_APLS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',LBR.NO_MN_CVG_INCR_APLS_FLAG), LBR.NO_MX_CVG_AMT_APLS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',LBR.NO_MX_CVG_AMT_APLS_FLAG), LBR.NO_MX_CVG_INCR_APLS_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',LBR.NO_MX_CVG_INCR_APLS_FLAG), /* id columns */ LBR.LER_BNFT_RSTRN_ID, LBR.LER_ID, LBR.BUSINESS_GROUP_ID, LBR.PL_ID, LBR.PLIP_ID, /* who columns */ LBR.LAST_UPDATE_DATE, LBR.LAST_UPDATED_BY, LBR.CREATED_BY, LBR.CREATION_DATE FROM BEN_LER_BNFT_RSTRN_F LBR WHERE LBR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, LBR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT LBR.EFFECTIVE_START_DATE
, LBR.EFFECTIVE_END_DATE
, LBR.DFLT_TO_ASN_PNDG_CTFN_RL
, LBR.MX_CVG_INCR_WCF_ALWD_AMT
, LBR.MX_CVG_INCR_ALWD_AMT
, LBR.MX_CVG_ALWD_AMT
, LBR.MX_CVG_MLT_INCR_NUM
, LBR.MX_CVG_MLT_INCR_WCF_NUM
, LBR.MX_CVG_RL
, LBR.MX_CVG_WCFN_AMT
, LBR.MX_CVG_WCFN_MLT_NUM
, LBR.MN_CVG_AMT
, LBR.MN_CVG_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_LER_BNFT_RSTRN_F:LBR'
, /* CODES */ LBR.DFLT_TO_ASN_PNDG_CTFN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DFLT_TO_ASN_PNDG_CTFN'
, LBR.DFLT_TO_ASN_PNDG_CTFN_CD)
, LBR.CVG_INCR_R_DECR_ONLY_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CVG_INCR_R_DECR_ONLY'
, LBR.CVG_INCR_R_DECR_ONLY_CD)
, LBR.UNSSPND_ENRT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_UNSSPND_ENRT'
, LBR.UNSSPND_ENRT_CD)
, LBR.NO_MN_CVG_INCR_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LBR.NO_MN_CVG_INCR_APLS_FLAG)
, LBR.NO_MX_CVG_AMT_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LBR.NO_MX_CVG_AMT_APLS_FLAG)
, LBR.NO_MX_CVG_INCR_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, LBR.NO_MX_CVG_INCR_APLS_FLAG)
, /* ID COLUMNS */ LBR.LER_BNFT_RSTRN_ID
, LBR.LER_ID
, LBR.BUSINESS_GROUP_ID
, LBR.PL_ID
, LBR.PLIP_ID
, /* WHO COLUMNS */ LBR.LAST_UPDATE_DATE
, LBR.LAST_UPDATED_BY
, LBR.CREATED_BY
, LBR.CREATION_DATE
FROM BEN_LER_BNFT_RSTRN_F LBR
WHERE LBR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, LBR.BUSINESS_GROUP_ID) WITH READ ONLY