View: BENBV_LER_BNFT_RSTRN_V

Product:	BEN - Advanced Benefits
Description:	This view identifies restrictions which may be imposed if a person elects to enroll in a compensation object as a result of a life event.
Implementation/DBA Data:	APPS.BENBV_LER_BNFT_RSTRN_V

View Text

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

Columns