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_OPTD_MDCR_PRTE

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

View Text

SELECT EOM.ELIG_OPTD_MDCR_PRTE_ID
, EOM.EFFECTIVE_START_DATE
, EOM.EFFECTIVE_END_DATE
, EOM.OPTD_MDCR_FLAG
, EOM.EXLCD_FLAG
, EOM.ELIGY_PRFL_ID
, EOM.BUSINESS_GROUP_ID
, EOM.EOM_ATTRIBUTE_CATEGORY
, EOM.EOM_ATTRIBUTE1
, EOM.EOM_ATTRIBUTE2
, EOM.EOM_ATTRIBUTE3
, EOM.EOM_ATTRIBUTE4
, EOM.EOM_ATTRIBUTE5
, EOM.EOM_ATTRIBUTE6
, EOM.EOM_ATTRIBUTE7
, EOM.EOM_ATTRIBUTE8
, EOM.EOM_ATTRIBUTE9
, EOM.EOM_ATTRIBUTE10
, EOM.EOM_ATTRIBUTE11
, EOM.EOM_ATTRIBUTE12
, EOM.EOM_ATTRIBUTE13
, EOM.EOM_ATTRIBUTE14
, EOM.EOM_ATTRIBUTE15
, EOM.EOM_ATTRIBUTE16
, EOM.EOM_ATTRIBUTE17
, EOM.EOM_ATTRIBUTE18
, EOM.EOM_ATTRIBUTE19
, EOM.EOM_ATTRIBUTE20
, EOM.EOM_ATTRIBUTE21
, EOM.EOM_ATTRIBUTE22
, EOM.EOM_ATTRIBUTE23
, EOM.EOM_ATTRIBUTE24
, EOM.EOM_ATTRIBUTE25
, EOM.EOM_ATTRIBUTE26
, EOM.EOM_ATTRIBUTE27
, EOM.EOM_ATTRIBUTE28
, EOM.EOM_ATTRIBUTE29
, EOM.EOM_ATTRIBUTE30
, EOM.LAST_UPDATE_DATE
, EOM.LAST_UPDATED_BY
, EOM.LAST_UPDATE_LOGIN
, EOM.CREATED_BY
, EOM.CREATION_DATE
, EOM.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_OPTD_MDCR_PRTE_F EOM
WHERE EOM.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EOM.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ELIG_OPTD_MDCR_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
OPTD_MDCR_FLAG
EXLCD_FLAG
ELIGY_PRFL_ID
BUSINESS_GROUP_ID
EOM_ATTRIBUTE_CATEGORY
EOM_ATTRIBUTE1
EOM_ATTRIBUTE2
EOM_ATTRIBUTE3
EOM_ATTRIBUTE4
EOM_ATTRIBUTE5
EOM_ATTRIBUTE6
EOM_ATTRIBUTE7
EOM_ATTRIBUTE8
EOM_ATTRIBUTE9
EOM_ATTRIBUTE10
EOM_ATTRIBUTE11
EOM_ATTRIBUTE12
EOM_ATTRIBUTE13
EOM_ATTRIBUTE14
EOM_ATTRIBUTE15
EOM_ATTRIBUTE16
EOM_ATTRIBUTE17
EOM_ATTRIBUTE18
EOM_ATTRIBUTE19
EOM_ATTRIBUTE20
EOM_ATTRIBUTE21
EOM_ATTRIBUTE22
EOM_ATTRIBUTE23
EOM_ATTRIBUTE24
EOM_ATTRIBUTE25
EOM_ATTRIBUTE26
EOM_ATTRIBUTE27
EOM_ATTRIBUTE28
EOM_ATTRIBUTE29
EOM_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER