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_COMP_LVL_PRTE

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

View Text

SELECT ECL.ELIG_COMP_LVL_PRTE_ID
, ECL.EFFECTIVE_START_DATE
, ECL.EFFECTIVE_END_DATE
, ECL.BUSINESS_GROUP_ID
, ECL.COMP_LVL_FCTR_ID
, ECL.ELIGY_PRFL_ID
, ECL.EXCLD_FLAG
, ECL.ORDR_NUM
, ECL.ECL_ATTRIBUTE_CATEGORY
, ECL.ECL_ATTRIBUTE1
, ECL.ECL_ATTRIBUTE2
, ECL.ECL_ATTRIBUTE3
, ECL.ECL_ATTRIBUTE4
, ECL.ECL_ATTRIBUTE5
, ECL.ECL_ATTRIBUTE6
, ECL.ECL_ATTRIBUTE7
, ECL.ECL_ATTRIBUTE8
, ECL.ECL_ATTRIBUTE9
, ECL.ECL_ATTRIBUTE10
, ECL.ECL_ATTRIBUTE11
, ECL.ECL_ATTRIBUTE12
, ECL.ECL_ATTRIBUTE13
, ECL.ECL_ATTRIBUTE14
, ECL.ECL_ATTRIBUTE15
, ECL.ECL_ATTRIBUTE16
, ECL.ECL_ATTRIBUTE17
, ECL.ECL_ATTRIBUTE18
, ECL.ECL_ATTRIBUTE19
, ECL.ECL_ATTRIBUTE20
, ECL.ECL_ATTRIBUTE21
, ECL.ECL_ATTRIBUTE22
, ECL.ECL_ATTRIBUTE23
, ECL.ECL_ATTRIBUTE24
, ECL.ECL_ATTRIBUTE25
, ECL.ECL_ATTRIBUTE26
, ECL.ECL_ATTRIBUTE27
, ECL.ECL_ATTRIBUTE28
, ECL.ECL_ATTRIBUTE29
, ECL.ECL_ATTRIBUTE30
, ECL.LAST_UPDATE_DATE
, ECL.LAST_UPDATED_BY
, ECL.LAST_UPDATE_LOGIN
, ECL.CREATED_BY
, ECL.CREATION_DATE
, ECL.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_COMP_LVL_PRTE_F ECL
WHERE ECL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ECL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ELIG_COMP_LVL_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
COMP_LVL_FCTR_ID
ELIGY_PRFL_ID
EXCLD_FLAG
ORDR_NUM
ECL_ATTRIBUTE_CATEGORY
ECL_ATTRIBUTE1
ECL_ATTRIBUTE2
ECL_ATTRIBUTE3
ECL_ATTRIBUTE4
ECL_ATTRIBUTE5
ECL_ATTRIBUTE6
ECL_ATTRIBUTE7
ECL_ATTRIBUTE8
ECL_ATTRIBUTE9
ECL_ATTRIBUTE10
ECL_ATTRIBUTE11
ECL_ATTRIBUTE12
ECL_ATTRIBUTE13
ECL_ATTRIBUTE14
ECL_ATTRIBUTE15
ECL_ATTRIBUTE16
ECL_ATTRIBUTE17
ECL_ATTRIBUTE18
ECL_ATTRIBUTE19
ECL_ATTRIBUTE20
ECL_ATTRIBUTE21
ECL_ATTRIBUTE22
ECL_ATTRIBUTE23
ECL_ATTRIBUTE24
ECL_ATTRIBUTE25
ECL_ATTRIBUTE26
ECL_ATTRIBUTE27
ECL_ATTRIBUTE28
ECL_ATTRIBUTE29
ECL_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER