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_TTL_PRTT_PRTE

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

View Text

SELECT ETP.ROWID
, ETP.ELIG_TTL_PRTT_PRTE_ID
, ETP.EFFECTIVE_START_DATE
, ETP.EFFECTIVE_END_DATE
, ETP.BUSINESS_GROUP_ID
, ETP.EXCLD_FLAG
, ETP.NO_MN_PRTT_NUM_APLS_FLAG
, ETP.NO_MX_PRTT_NUM_APLS_FLAG
, ETP.ELIGY_PRFL_ID
, ETP.ETP_ATTRIBUTE_CATEGORY
, ETP.ETP_ATTRIBUTE1
, ETP.ETP_ATTRIBUTE2
, ETP.ETP_ATTRIBUTE3
, ETP.ETP_ATTRIBUTE4
, ETP.ETP_ATTRIBUTE5
, ETP.ETP_ATTRIBUTE6
, ETP.ETP_ATTRIBUTE7
, ETP.ETP_ATTRIBUTE8
, ETP.ETP_ATTRIBUTE9
, ETP.ETP_ATTRIBUTE10
, ETP.ETP_ATTRIBUTE11
, ETP.ETP_ATTRIBUTE12
, ETP.ETP_ATTRIBUTE13
, ETP.ETP_ATTRIBUTE14
, ETP.ETP_ATTRIBUTE15
, ETP.ETP_ATTRIBUTE16
, ETP.ETP_ATTRIBUTE17
, ETP.ETP_ATTRIBUTE18
, ETP.ETP_ATTRIBUTE19
, ETP.ETP_ATTRIBUTE20
, ETP.ETP_ATTRIBUTE21
, ETP.ETP_ATTRIBUTE22
, ETP.ETP_ATTRIBUTE23
, ETP.ETP_ATTRIBUTE24
, ETP.ETP_ATTRIBUTE25
, ETP.ETP_ATTRIBUTE26
, ETP.ETP_ATTRIBUTE27
, ETP.ETP_ATTRIBUTE28
, ETP.ETP_ATTRIBUTE29
, ETP.ETP_ATTRIBUTE30
, ETP.LAST_UPDATE_DATE
, ETP.LAST_UPDATED_BY
, ETP.LAST_UPDATE_LOGIN
, ETP.CREATED_BY
, ETP.CREATION_DATE
, ETP.OBJECT_VERSION_NUMBER
, ETP.ORDR_NUM
, ETP.MN_PRTT_NUM
, ETP.MX_PRTT_NUM
, ETP.PRTT_DET_CD
, ETP.PRTT_DET_RL
FROM BEN_ELIG_TTL_PRTT_PRTE_F ETP
WHERE ETP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ETP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ROW_ID
ELIG_TTL_PRTT_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
EXCLD_FLAG
NO_MN_PRTT_NUM_APLS_FLAG
NO_MX_PRTT_NUM_APLS_FLAG
ELIGY_PRFL_ID
ETP_ATTRIBUTE_CATEGORY
ETP_ATTRIBUTE1
ETP_ATTRIBUTE2
ETP_ATTRIBUTE3
ETP_ATTRIBUTE4
ETP_ATTRIBUTE5
ETP_ATTRIBUTE6
ETP_ATTRIBUTE7
ETP_ATTRIBUTE8
ETP_ATTRIBUTE9
ETP_ATTRIBUTE10
ETP_ATTRIBUTE11
ETP_ATTRIBUTE12
ETP_ATTRIBUTE13
ETP_ATTRIBUTE14
ETP_ATTRIBUTE15
ETP_ATTRIBUTE16
ETP_ATTRIBUTE17
ETP_ATTRIBUTE18
ETP_ATTRIBUTE19
ETP_ATTRIBUTE20
ETP_ATTRIBUTE21
ETP_ATTRIBUTE22
ETP_ATTRIBUTE23
ETP_ATTRIBUTE24
ETP_ATTRIBUTE25
ETP_ATTRIBUTE26
ETP_ATTRIBUTE27
ETP_ATTRIBUTE28
ETP_ATTRIBUTE29
ETP_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ORDR_NUM
MN_PRTT_NUM
MX_PRTT_NUM
PRTT_DET_CD
PRTT_DET_RL