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_AGE_CVG

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

View Text

SELECT EAC.ELIG_AGE_CVG_ID
, EAC.EFFECTIVE_START_DATE
, EAC.EFFECTIVE_END_DATE
, EAC.BUSINESS_GROUP_ID
, EAC.DPNT_CVG_ELIGY_PRFL_ID
, EAC.AGE_FCTR_ID
, EAC.CVG_STRT_CD
, EAC.CVG_STRT_RL
, EAC.CVG_THRU_CD
, EAC.CVG_THRU_RL
, EAC.EXCLD_FLAG
, EAC.EAC_ATTRIBUTE_CATEGORY
, EAC.EAC_ATTRIBUTE1
, EAC.EAC_ATTRIBUTE2
, EAC.EAC_ATTRIBUTE3
, EAC.EAC_ATTRIBUTE4
, EAC.EAC_ATTRIBUTE5
, EAC.EAC_ATTRIBUTE6
, EAC.EAC_ATTRIBUTE7
, EAC.EAC_ATTRIBUTE8
, EAC.EAC_ATTRIBUTE9
, EAC.EAC_ATTRIBUTE10
, EAC.EAC_ATTRIBUTE11
, EAC.EAC_ATTRIBUTE12
, EAC.EAC_ATTRIBUTE13
, EAC.EAC_ATTRIBUTE14
, EAC.EAC_ATTRIBUTE15
, EAC.EAC_ATTRIBUTE16
, EAC.EAC_ATTRIBUTE17
, EAC.EAC_ATTRIBUTE18
, EAC.EAC_ATTRIBUTE19
, EAC.EAC_ATTRIBUTE20
, EAC.EAC_ATTRIBUTE21
, EAC.EAC_ATTRIBUTE22
, EAC.EAC_ATTRIBUTE23
, EAC.EAC_ATTRIBUTE24
, EAC.EAC_ATTRIBUTE25
, EAC.EAC_ATTRIBUTE26
, EAC.EAC_ATTRIBUTE27
, EAC.EAC_ATTRIBUTE28
, EAC.EAC_ATTRIBUTE29
, EAC.EAC_ATTRIBUTE30
, EAC.LAST_UPDATE_DATE
, EAC.LAST_UPDATED_BY
, EAC.LAST_UPDATE_LOGIN
, EAC.CREATED_BY
, EAC.CREATION_DATE
, EAC.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_AGE_CVG_F EAC
WHERE EAC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EAC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ELIG_AGE_CVG_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
DPNT_CVG_ELIGY_PRFL_ID
AGE_FCTR_ID
CVG_STRT_CD
CVG_STRT_RL
CVG_THRU_CD
CVG_THRU_RL
EXCLD_FLAG
EAC_ATTRIBUTE_CATEGORY
EAC_ATTRIBUTE1
EAC_ATTRIBUTE2
EAC_ATTRIBUTE3
EAC_ATTRIBUTE4
EAC_ATTRIBUTE5
EAC_ATTRIBUTE6
EAC_ATTRIBUTE7
EAC_ATTRIBUTE8
EAC_ATTRIBUTE9
EAC_ATTRIBUTE10
EAC_ATTRIBUTE11
EAC_ATTRIBUTE12
EAC_ATTRIBUTE13
EAC_ATTRIBUTE14
EAC_ATTRIBUTE15
EAC_ATTRIBUTE16
EAC_ATTRIBUTE17
EAC_ATTRIBUTE18
EAC_ATTRIBUTE19
EAC_ATTRIBUTE20
EAC_ATTRIBUTE21
EAC_ATTRIBUTE22
EAC_ATTRIBUTE23
EAC_ATTRIBUTE24
EAC_ATTRIBUTE25
EAC_ATTRIBUTE26
EAC_ATTRIBUTE27
EAC_ATTRIBUTE28
EAC_ATTRIBUTE29
EAC_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER