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_ELIG_LBR_MMBR_PRTE

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

View Text

SELECT ELU.ELIG_LBR_MMBR_PRTE_ID
, ELU.EFFECTIVE_START_DATE
, ELU.EFFECTIVE_END_DATE
, ELU.ELIGY_PRFL_ID
, ELU.EXCLD_FLAG
, ELU.LBR_MMBR_FLAG
, ELU.ORDR_NUM
, ELU.BUSINESS_GROUP_ID
, ELU.ELU_ATTRIBUTE_CATEGORY
, ELU.ELU_ATTRIBUTE1
, ELU.ELU_ATTRIBUTE2
, ELU.ELU_ATTRIBUTE3
, ELU.ELU_ATTRIBUTE4
, ELU.ELU_ATTRIBUTE5
, ELU.ELU_ATTRIBUTE6
, ELU.ELU_ATTRIBUTE7
, ELU.ELU_ATTRIBUTE8
, ELU.ELU_ATTRIBUTE9
, ELU.ELU_ATTRIBUTE10
, ELU.ELU_ATTRIBUTE11
, ELU.ELU_ATTRIBUTE12
, ELU.ELU_ATTRIBUTE13
, ELU.ELU_ATTRIBUTE14
, ELU.ELU_ATTRIBUTE15
, ELU.ELU_ATTRIBUTE16
, ELU.ELU_ATTRIBUTE17
, ELU.ELU_ATTRIBUTE18
, ELU.ELU_ATTRIBUTE19
, ELU.ELU_ATTRIBUTE20
, ELU.ELU_ATTRIBUTE21
, ELU.ELU_ATTRIBUTE22
, ELU.ELU_ATTRIBUTE23
, ELU.ELU_ATTRIBUTE24
, ELU.ELU_ATTRIBUTE25
, ELU.ELU_ATTRIBUTE26
, ELU.ELU_ATTRIBUTE27
, ELU.ELU_ATTRIBUTE28
, ELU.ELU_ATTRIBUTE29
, ELU.ELU_ATTRIBUTE30
, ELU.LAST_UPDATE_DATE
, ELU.LAST_UPDATED_BY
, ELU.LAST_UPDATE_LOGIN
, ELU.CREATED_BY
, ELU.CREATION_DATE
, ELU.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_LBR_MMBR_PRTE_F ELU
WHERE ELU.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ELU.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ELIG_LBR_MMBR_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ELIGY_PRFL_ID
EXCLD_FLAG
LBR_MMBR_FLAG
ORDR_NUM
BUSINESS_GROUP_ID
ELU_ATTRIBUTE_CATEGORY
ELU_ATTRIBUTE1
ELU_ATTRIBUTE2
ELU_ATTRIBUTE3
ELU_ATTRIBUTE4
ELU_ATTRIBUTE5
ELU_ATTRIBUTE6
ELU_ATTRIBUTE7
ELU_ATTRIBUTE8
ELU_ATTRIBUTE9
ELU_ATTRIBUTE10
ELU_ATTRIBUTE11
ELU_ATTRIBUTE12
ELU_ATTRIBUTE13
ELU_ATTRIBUTE14
ELU_ATTRIBUTE15
ELU_ATTRIBUTE16
ELU_ATTRIBUTE17
ELU_ATTRIBUTE18
ELU_ATTRIBUTE19
ELU_ATTRIBUTE20
ELU_ATTRIBUTE21
ELU_ATTRIBUTE22
ELU_ATTRIBUTE23
ELU_ATTRIBUTE24
ELU_ATTRIBUTE25
ELU_ATTRIBUTE26
ELU_ATTRIBUTE27
ELU_ATTRIBUTE28
ELU_ATTRIBUTE29
ELU_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER