eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_LER_CHG_PGM_ENRT

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

View Text

SELECT LGE.LER_CHG_PGM_ENRT_ID
, LGE.EFFECTIVE_START_DATE
, LGE.EFFECTIVE_END_DATE
, LGE.AUTO_ENRT_MTHD_RL
, LGE.CRNT_ENRT_PRCLDS_CHG_FLAG
, LGE.BUSINESS_GROUP_ID
, LGE.PGM_ID
, LGE.LER_ID
, LGE.DFLT_ENRT_CD
, LGE.DFLT_ENRT_RL
, LGE.ENRT_CD
, LGE.ENRT_MTHD_CD
, LGE.ENRT_RL
, LGE.STL_ELIG_CANT_CHG_FLAG
, LGE.LGE_ATTRIBUTE_CATEGORY
, LGE.LGE_ATTRIBUTE1
, LGE.LGE_ATTRIBUTE2
, LGE.LGE_ATTRIBUTE3
, LGE.LGE_ATTRIBUTE4
, LGE.LGE_ATTRIBUTE5
, LGE.LGE_ATTRIBUTE6
, LGE.LGE_ATTRIBUTE7
, LGE.LGE_ATTRIBUTE8
, LGE.LGE_ATTRIBUTE9
, LGE.LGE_ATTRIBUTE10
, LGE.LGE_ATTRIBUTE11
, LGE.LGE_ATTRIBUTE12
, LGE.LGE_ATTRIBUTE13
, LGE.LGE_ATTRIBUTE14
, LGE.LGE_ATTRIBUTE15
, LGE.LGE_ATTRIBUTE16
, LGE.LGE_ATTRIBUTE17
, LGE.LGE_ATTRIBUTE18
, LGE.LGE_ATTRIBUTE19
, LGE.LGE_ATTRIBUTE20
, LGE.LGE_ATTRIBUTE21
, LGE.LGE_ATTRIBUTE22
, LGE.LGE_ATTRIBUTE23
, LGE.LGE_ATTRIBUTE24
, LGE.LGE_ATTRIBUTE25
, LGE.LGE_ATTRIBUTE26
, LGE.LGE_ATTRIBUTE27
, LGE.LGE_ATTRIBUTE28
, LGE.LGE_ATTRIBUTE29
, LGE.LGE_ATTRIBUTE30
, LGE.LAST_UPDATE_DATE
, LGE.LAST_UPDATED_BY
, LGE.LAST_UPDATE_LOGIN
, LGE.CREATED_BY
, LGE.CREATION_DATE
, LGE.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_PGM_ENRT_F LGE
WHERE LGE.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LGE.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
LER_CHG_PGM_ENRT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
AUTO_ENRT_MTHD_RL
CRNT_ENRT_PRCLDS_CHG_FLAG
BUSINESS_GROUP_ID
PGM_ID
LER_ID
DFLT_ENRT_CD
DFLT_ENRT_RL
ENRT_CD
ENRT_MTHD_CD
ENRT_RL
STL_ELIG_CANT_CHG_FLAG
LGE_ATTRIBUTE_CATEGORY
LGE_ATTRIBUTE1
LGE_ATTRIBUTE2
LGE_ATTRIBUTE3
LGE_ATTRIBUTE4
LGE_ATTRIBUTE5
LGE_ATTRIBUTE6
LGE_ATTRIBUTE7
LGE_ATTRIBUTE8
LGE_ATTRIBUTE9
LGE_ATTRIBUTE10
LGE_ATTRIBUTE11
LGE_ATTRIBUTE12
LGE_ATTRIBUTE13
LGE_ATTRIBUTE14
LGE_ATTRIBUTE15
LGE_ATTRIBUTE16
LGE_ATTRIBUTE17
LGE_ATTRIBUTE18
LGE_ATTRIBUTE19
LGE_ATTRIBUTE20
LGE_ATTRIBUTE21
LGE_ATTRIBUTE22
LGE_ATTRIBUTE23
LGE_ATTRIBUTE24
LGE_ATTRIBUTE25
LGE_ATTRIBUTE26
LGE_ATTRIBUTE27
LGE_ATTRIBUTE28
LGE_ATTRIBUTE29
LGE_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER