VIEW: APPS.BEN_LER_BNFT_RSTRN_CTFN_X

Source

View Text - Preformatted

SELECT lbc.LER_BNFT_RSTRN_CTFN_ID ,lbc.EFFECTIVE_START_DATE ,lbc.EFFECTIVE_END_DATE ,lbc.RQD_FLAG ,lbc.ENRT_CTFN_TYP_CD ,lbc.CTFN_RQD_WHEN_RL ,lbc.LER_BNFT_RSTRN_ID ,lbc.BUSINESS_GROUP_ID ,lbc.LBC_ATTRIBUTE_CATEGORY ,lbc.LBC_ATTRIBUTE1 ,lbc.LBC_ATTRIBUTE2 ,lbc.LBC_ATTRIBUTE3 ,lbc.LBC_ATTRIBUTE4 ,lbc.LBC_ATTRIBUTE5 ,lbc.LBC_ATTRIBUTE6 ,lbc.LBC_ATTRIBUTE7 ,lbc.LBC_ATTRIBUTE8 ,lbc.LBC_ATTRIBUTE9 ,lbc.LBC_ATTRIBUTE10 ,lbc.LBC_ATTRIBUTE11 ,lbc.LBC_ATTRIBUTE12 ,lbc.LBC_ATTRIBUTE13 ,lbc.LBC_ATTRIBUTE14 ,lbc.LBC_ATTRIBUTE15 ,lbc.LBC_ATTRIBUTE16 ,lbc.LBC_ATTRIBUTE17 ,lbc.LBC_ATTRIBUTE18 ,lbc.LBC_ATTRIBUTE19 ,lbc.LBC_ATTRIBUTE20 ,lbc.LBC_ATTRIBUTE21 ,lbc.LBC_ATTRIBUTE22 ,lbc.LBC_ATTRIBUTE23 ,lbc.LBC_ATTRIBUTE24 ,lbc.LBC_ATTRIBUTE25 ,lbc.LBC_ATTRIBUTE26 ,lbc.LBC_ATTRIBUTE27 ,lbc.LBC_ATTRIBUTE28 ,lbc.LBC_ATTRIBUTE29 ,lbc.LBC_ATTRIBUTE30 ,lbc.LAST_UPDATE_DATE ,lbc.LAST_UPDATED_BY ,lbc.LAST_UPDATE_LOGIN ,lbc.CREATED_BY ,lbc.CREATION_DATE ,lbc.OBJECT_VERSION_NUMBER from BEN_LER_BNFT_RSTRN_CTFN_F lbc WHERE trunc(sysdate) between lbc.effective_start_date and lbc.effective_end_date

View Text - HTML Formatted

SELECT LBC.LER_BNFT_RSTRN_CTFN_ID
, LBC.EFFECTIVE_START_DATE
, LBC.EFFECTIVE_END_DATE
, LBC.RQD_FLAG
, LBC.ENRT_CTFN_TYP_CD
, LBC.CTFN_RQD_WHEN_RL
, LBC.LER_BNFT_RSTRN_ID
, LBC.BUSINESS_GROUP_ID
, LBC.LBC_ATTRIBUTE_CATEGORY
, LBC.LBC_ATTRIBUTE1
, LBC.LBC_ATTRIBUTE2
, LBC.LBC_ATTRIBUTE3
, LBC.LBC_ATTRIBUTE4
, LBC.LBC_ATTRIBUTE5
, LBC.LBC_ATTRIBUTE6
, LBC.LBC_ATTRIBUTE7
, LBC.LBC_ATTRIBUTE8
, LBC.LBC_ATTRIBUTE9
, LBC.LBC_ATTRIBUTE10
, LBC.LBC_ATTRIBUTE11
, LBC.LBC_ATTRIBUTE12
, LBC.LBC_ATTRIBUTE13
, LBC.LBC_ATTRIBUTE14
, LBC.LBC_ATTRIBUTE15
, LBC.LBC_ATTRIBUTE16
, LBC.LBC_ATTRIBUTE17
, LBC.LBC_ATTRIBUTE18
, LBC.LBC_ATTRIBUTE19
, LBC.LBC_ATTRIBUTE20
, LBC.LBC_ATTRIBUTE21
, LBC.LBC_ATTRIBUTE22
, LBC.LBC_ATTRIBUTE23
, LBC.LBC_ATTRIBUTE24
, LBC.LBC_ATTRIBUTE25
, LBC.LBC_ATTRIBUTE26
, LBC.LBC_ATTRIBUTE27
, LBC.LBC_ATTRIBUTE28
, LBC.LBC_ATTRIBUTE29
, LBC.LBC_ATTRIBUTE30
, LBC.LAST_UPDATE_DATE
, LBC.LAST_UPDATED_BY
, LBC.LAST_UPDATE_LOGIN
, LBC.CREATED_BY
, LBC.CREATION_DATE
, LBC.OBJECT_VERSION_NUMBER
FROM BEN_LER_BNFT_RSTRN_CTFN_F LBC
WHERE TRUNC(SYSDATE) BETWEEN LBC.EFFECTIVE_START_DATE
AND LBC.EFFECTIVE_END_DATE