VIEW: APPS.BEN_LER_BNFT_RSTRN_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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