Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_LER_BNFT_RSTRN_X |
SELECT LBR.LER_BNFT_RSTRN_ID
, LBR.EFFECTIVE_START_DATE
, LBR.EFFECTIVE_END_DATE
, LBR.NO_MX_CVG_AMT_APLS_FLAG
, LBR.NO_MN_CVG_INCR_APLS_FLAG
, LBR.NO_MX_CVG_INCR_APLS_FLAG
, 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
, LBR.CVG_INCR_R_DECR_ONLY_CD
, LBR.LER_ID
, LBR.PL_ID
, LBR.BUSINESS_GROUP_ID
, LBR.LBR_ATTRIBUTE_CATEGORY
, LBR.LBR_ATTRIBUTE1
, LBR.LBR_ATTRIBUTE2
, LBR.LBR_ATTRIBUTE3
, LBR.LBR_ATTRIBUTE4
, LBR.LBR_ATTRIBUTE5
, LBR.LBR_ATTRIBUTE6
, LBR.LBR_ATTRIBUTE7
, LBR.LBR_ATTRIBUTE8
, LBR.LBR_ATTRIBUTE9
, LBR.LBR_ATTRIBUTE10
, LBR.LBR_ATTRIBUTE11
, LBR.LBR_ATTRIBUTE12
, LBR.LBR_ATTRIBUTE13
, LBR.LBR_ATTRIBUTE14
, LBR.LBR_ATTRIBUTE15
, LBR.LBR_ATTRIBUTE16
, LBR.LBR_ATTRIBUTE17
, LBR.LBR_ATTRIBUTE18
, LBR.LBR_ATTRIBUTE19
, LBR.LBR_ATTRIBUTE20
, LBR.LBR_ATTRIBUTE21
, LBR.LBR_ATTRIBUTE22
, LBR.LBR_ATTRIBUTE23
, LBR.LBR_ATTRIBUTE24
, LBR.LBR_ATTRIBUTE25
, LBR.LBR_ATTRIBUTE26
, LBR.LBR_ATTRIBUTE27
, LBR.LBR_ATTRIBUTE28
, LBR.LBR_ATTRIBUTE29
, LBR.LBR_ATTRIBUTE30
, LBR.LAST_UPDATE_DATE
, LBR.LAST_UPDATED_BY
, LBR.LAST_UPDATE_LOGIN
, LBR.CREATED_BY
, LBR.CREATION_DATE
, LBR.OBJECT_VERSION_NUMBER
, LBR.DFLT_TO_ASN_PNDG_CTFN_CD
, LBR.DFLT_TO_ASN_PNDG_CTFN_RL
, LBR.UNSSPND_ENRT_CD
, LBR.PLIP_ID
FROM BEN_LER_BNFT_RSTRN_F LBR
WHERE TRUNC(SYSDATE) BETWEEN LBR.EFFECTIVE_START_DATE
AND LBR.EFFECTIVE_END_DATE