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_PRTT_ANTHR_PL_PRTE

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

View Text

SELECT EPP.ELIG_PRTT_ANTHR_PL_PRTE_ID
, EPP.EFFECTIVE_START_DATE
, EPP.EFFECTIVE_END_DATE
, EPP.EXCLD_FLAG
, EPP.ORDR_NUM
, EPP.ELIGY_PRFL_ID
, EPP.PL_ID
, EPP.BUSINESS_GROUP_ID
, EPP.EPP_ATTRIBUTE_CATEGORY
, EPP.EPP_ATTRIBUTE1
, EPP.EPP_ATTRIBUTE2
, EPP.EPP_ATTRIBUTE3
, EPP.EPP_ATTRIBUTE4
, EPP.EPP_ATTRIBUTE5
, EPP.EPP_ATTRIBUTE6
, EPP.EPP_ATTRIBUTE7
, EPP.EPP_ATTRIBUTE8
, EPP.EPP_ATTRIBUTE9
, EPP.EPP_ATTRIBUTE10
, EPP.EPP_ATTRIBUTE11
, EPP.EPP_ATTRIBUTE12
, EPP.EPP_ATTRIBUTE13
, EPP.EPP_ATTRIBUTE14
, EPP.EPP_ATTRIBUTE15
, EPP.EPP_ATTRIBUTE16
, EPP.EPP_ATTRIBUTE17
, EPP.EPP_ATTRIBUTE18
, EPP.EPP_ATTRIBUTE19
, EPP.EPP_ATTRIBUTE20
, EPP.EPP_ATTRIBUTE21
, EPP.EPP_ATTRIBUTE22
, EPP.EPP_ATTRIBUTE23
, EPP.EPP_ATTRIBUTE24
, EPP.EPP_ATTRIBUTE25
, EPP.EPP_ATTRIBUTE26
, EPP.EPP_ATTRIBUTE27
, EPP.EPP_ATTRIBUTE28
, EPP.EPP_ATTRIBUTE29
, EPP.EPP_ATTRIBUTE30
, EPP.LAST_UPDATE_DATE
, EPP.LAST_UPDATED_BY
, EPP.LAST_UPDATE_LOGIN
, EPP.CREATED_BY
, EPP.CREATION_DATE
, EPP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP
WHERE EPP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ELIG_PRTT_ANTHR_PL_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
EXCLD_FLAG
ORDR_NUM
ELIGY_PRFL_ID
PL_ID
BUSINESS_GROUP_ID
EPP_ATTRIBUTE_CATEGORY
EPP_ATTRIBUTE1
EPP_ATTRIBUTE2
EPP_ATTRIBUTE3
EPP_ATTRIBUTE4
EPP_ATTRIBUTE5
EPP_ATTRIBUTE6
EPP_ATTRIBUTE7
EPP_ATTRIBUTE8
EPP_ATTRIBUTE9
EPP_ATTRIBUTE10
EPP_ATTRIBUTE11
EPP_ATTRIBUTE12
EPP_ATTRIBUTE13
EPP_ATTRIBUTE14
EPP_ATTRIBUTE15
EPP_ATTRIBUTE16
EPP_ATTRIBUTE17
EPP_ATTRIBUTE18
EPP_ATTRIBUTE19
EPP_ATTRIBUTE20
EPP_ATTRIBUTE21
EPP_ATTRIBUTE22
EPP_ATTRIBUTE23
EPP_ATTRIBUTE24
EPP_ATTRIBUTE25
EPP_ATTRIBUTE26
EPP_ATTRIBUTE27
EPP_ATTRIBUTE28
EPP_ATTRIBUTE29
EPP_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER