View: BEN_LER_PER_INFO_CS_LER_X

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

View Text

SELECT LPL.LER_PER_INFO_CS_LER_ID
, LPL.EFFECTIVE_START_DATE
, LPL.EFFECTIVE_END_DATE
, LPL.LER_PER_INFO_CS_LER_RL
, LPL.PER_INFO_CHG_CS_LER_ID
, LPL.LER_ID
, LPL.BUSINESS_GROUP_ID
, LPL.LPL_ATTRIBUTE_CATEGORY
, LPL.LPL_ATTRIBUTE1
, LPL.LPL_ATTRIBUTE2
, LPL.LPL_ATTRIBUTE3
, LPL.LPL_ATTRIBUTE4
, LPL.LPL_ATTRIBUTE5
, LPL.LPL_ATTRIBUTE6
, LPL.LPL_ATTRIBUTE7
, LPL.LPL_ATTRIBUTE8
, LPL.LPL_ATTRIBUTE9
, LPL.LPL_ATTRIBUTE10
, LPL.LPL_ATTRIBUTE11
, LPL.LPL_ATTRIBUTE12
, LPL.LPL_ATTRIBUTE13
, LPL.LPL_ATTRIBUTE14
, LPL.LPL_ATTRIBUTE15
, LPL.LPL_ATTRIBUTE16
, LPL.LPL_ATTRIBUTE17
, LPL.LPL_ATTRIBUTE18
, LPL.LPL_ATTRIBUTE19
, LPL.LPL_ATTRIBUTE20
, LPL.LPL_ATTRIBUTE21
, LPL.LPL_ATTRIBUTE22
, LPL.LPL_ATTRIBUTE23
, LPL.LPL_ATTRIBUTE24
, LPL.LPL_ATTRIBUTE25
, LPL.LPL_ATTRIBUTE26
, LPL.LPL_ATTRIBUTE27
, LPL.LPL_ATTRIBUTE28
, LPL.LPL_ATTRIBUTE29
, LPL.LPL_ATTRIBUTE30
, LPL.LAST_UPDATE_DATE
, LPL.LAST_UPDATED_BY
, LPL.LAST_UPDATE_LOGIN
, LPL.CREATED_BY
, LPL.CREATION_DATE
, LPL.OBJECT_VERSION_NUMBER
, LPL.CHG_MANDATORY_CD
FROM BEN_LER_PER_INFO_CS_LER_F LPL
WHERE TRUNC(SYSDATE) BETWEEN LPL.EFFECTIVE_START_DATE
AND LPL.EFFECTIVE_END_DATE

Columns