View: BEN_LER_BNFT_RSTRN_CTFN_X

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_LER_BNFT_RSTRN_CTFN_X

View Text

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

Columns