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_PYRL_PRTE

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

View Text

SELECT EPY.ELIG_PYRL_PRTE_ID
, EPY.EFFECTIVE_START_DATE
, EPY.EFFECTIVE_END_DATE
, EPY.BUSINESS_GROUP_ID
, EPY.PAYROLL_ID
, EPY.EXCLD_FLAG
, EPY.ORDR_NUM
, EPY.ELIGY_PRFL_ID
, EPY.EPY_ATTRIBUTE_CATEGORY
, EPY.EPY_ATTRIBUTE1
, EPY.EPY_ATTRIBUTE2
, EPY.EPY_ATTRIBUTE3
, EPY.EPY_ATTRIBUTE4
, EPY.EPY_ATTRIBUTE5
, EPY.EPY_ATTRIBUTE6
, EPY.EPY_ATTRIBUTE7
, EPY.EPY_ATTRIBUTE8
, EPY.EPY_ATTRIBUTE9
, EPY.EPY_ATTRIBUTE10
, EPY.EPY_ATTRIBUTE11
, EPY.EPY_ATTRIBUTE12
, EPY.EPY_ATTRIBUTE13
, EPY.EPY_ATTRIBUTE14
, EPY.EPY_ATTRIBUTE15
, EPY.EPY_ATTRIBUTE16
, EPY.EPY_ATTRIBUTE17
, EPY.EPY_ATTRIBUTE18
, EPY.EPY_ATTRIBUTE19
, EPY.EPY_ATTRIBUTE20
, EPY.EPY_ATTRIBUTE21
, EPY.EPY_ATTRIBUTE22
, EPY.EPY_ATTRIBUTE23
, EPY.EPY_ATTRIBUTE24
, EPY.EPY_ATTRIBUTE25
, EPY.EPY_ATTRIBUTE26
, EPY.EPY_ATTRIBUTE27
, EPY.EPY_ATTRIBUTE28
, EPY.EPY_ATTRIBUTE29
, EPY.EPY_ATTRIBUTE30
, EPY.LAST_UPDATE_DATE
, EPY.LAST_UPDATED_BY
, EPY.LAST_UPDATE_LOGIN
, EPY.CREATED_BY
, EPY.CREATION_DATE
, EPY.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PYRL_PRTE_F EPY
WHERE EPY.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPY.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ELIG_PYRL_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
PAYROLL_ID
EXCLD_FLAG
ORDR_NUM
ELIGY_PRFL_ID
EPY_ATTRIBUTE_CATEGORY
EPY_ATTRIBUTE1
EPY_ATTRIBUTE2
EPY_ATTRIBUTE3
EPY_ATTRIBUTE4
EPY_ATTRIBUTE5
EPY_ATTRIBUTE6
EPY_ATTRIBUTE7
EPY_ATTRIBUTE8
EPY_ATTRIBUTE9
EPY_ATTRIBUTE10
EPY_ATTRIBUTE11
EPY_ATTRIBUTE12
EPY_ATTRIBUTE13
EPY_ATTRIBUTE14
EPY_ATTRIBUTE15
EPY_ATTRIBUTE16
EPY_ATTRIBUTE17
EPY_ATTRIBUTE18
EPY_ATTRIBUTE19
EPY_ATTRIBUTE20
EPY_ATTRIBUTE21
EPY_ATTRIBUTE22
EPY_ATTRIBUTE23
EPY_ATTRIBUTE24
EPY_ATTRIBUTE25
EPY_ATTRIBUTE26
EPY_ATTRIBUTE27
EPY_ATTRIBUTE28
EPY_ATTRIBUTE29
EPY_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER