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_PRTN_ELIG

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

View Text

SELECT EPA.PRTN_ELIG_ID
, EPA.EFFECTIVE_START_DATE
, EPA.EFFECTIVE_END_DATE
, EPA.BUSINESS_GROUP_ID
, EPA.PGM_ID
, EPA.PL_ID
, EPA.OIPL_ID
, EPA.PRTN_EFF_STRT_DT_CD
, EPA.PRTN_EFF_END_DT_CD
, EPA.PRTN_EFF_STRT_DT_RL
, EPA.PRTN_EFF_END_DT_RL
, EPA.WAIT_PERD_VAL
, EPA.WAIT_PERD_UOM
, EPA.TRK_SCR_FOR_INELG_FLAG
, EPA.EPA_ATTRIBUTE_CATEGORY
, EPA.EPA_ATTRIBUTE1
, EPA.EPA_ATTRIBUTE2
, EPA.EPA_ATTRIBUTE3
, EPA.EPA_ATTRIBUTE4
, EPA.EPA_ATTRIBUTE5
, EPA.EPA_ATTRIBUTE6
, EPA.EPA_ATTRIBUTE7
, EPA.EPA_ATTRIBUTE8
, EPA.EPA_ATTRIBUTE9
, EPA.EPA_ATTRIBUTE10
, EPA.EPA_ATTRIBUTE11
, EPA.EPA_ATTRIBUTE12
, EPA.EPA_ATTRIBUTE13
, EPA.EPA_ATTRIBUTE14
, EPA.EPA_ATTRIBUTE15
, EPA.EPA_ATTRIBUTE16
, EPA.EPA_ATTRIBUTE17
, EPA.EPA_ATTRIBUTE18
, EPA.EPA_ATTRIBUTE19
, EPA.EPA_ATTRIBUTE20
, EPA.EPA_ATTRIBUTE21
, EPA.EPA_ATTRIBUTE22
, EPA.EPA_ATTRIBUTE23
, EPA.EPA_ATTRIBUTE24
, EPA.EPA_ATTRIBUTE25
, EPA.EPA_ATTRIBUTE26
, EPA.EPA_ATTRIBUTE27
, EPA.EPA_ATTRIBUTE28
, EPA.EPA_ATTRIBUTE29
, EPA.EPA_ATTRIBUTE30
, EPA.LAST_UPDATE_DATE
, EPA.LAST_UPDATED_BY
, EPA.LAST_UPDATE_LOGIN
, EPA.CREATED_BY
, EPA.CREATION_DATE
, EPA.OBJECT_VERSION_NUMBER
, EPA.PTIP_ID
, EPA.PLIP_ID
, EPA.WAIT_PERD_DT_TO_USE_CD
, EPA.WAIT_PERD_DT_TO_USE_RL
, EPA.WAIT_PERD_RL
, EPA.MX_POE_UOM
, EPA.MX_POE_VAL
, EPA.MX_POE_RL
, EPA.MX_POE_APLS_CD
, EPA.MX_POE_DET_DT_CD
, EPA.MX_POE_DET_DT_RL
FROM BEN_PRTN_ELIG_F EPA
WHERE EPA.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPA.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
PRTN_ELIG_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
PGM_ID
PL_ID
OIPL_ID
PRTN_EFF_STRT_DT_CD
PRTN_EFF_END_DT_CD
PRTN_EFF_STRT_DT_RL
PRTN_EFF_END_DT_RL
WAIT_PERD_VAL
WAIT_PERD_UOM
TRK_SCR_FOR_INELG_FLAG
EPA_ATTRIBUTE_CATEGORY
EPA_ATTRIBUTE1
EPA_ATTRIBUTE2
EPA_ATTRIBUTE3
EPA_ATTRIBUTE4
EPA_ATTRIBUTE5
EPA_ATTRIBUTE6
EPA_ATTRIBUTE7
EPA_ATTRIBUTE8
EPA_ATTRIBUTE9
EPA_ATTRIBUTE10
EPA_ATTRIBUTE11
EPA_ATTRIBUTE12
EPA_ATTRIBUTE13
EPA_ATTRIBUTE14
EPA_ATTRIBUTE15
EPA_ATTRIBUTE16
EPA_ATTRIBUTE17
EPA_ATTRIBUTE18
EPA_ATTRIBUTE19
EPA_ATTRIBUTE20
EPA_ATTRIBUTE21
EPA_ATTRIBUTE22
EPA_ATTRIBUTE23
EPA_ATTRIBUTE24
EPA_ATTRIBUTE25
EPA_ATTRIBUTE26
EPA_ATTRIBUTE27
EPA_ATTRIBUTE28
EPA_ATTRIBUTE29
EPA_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
PTIP_ID
PLIP_ID
WAIT_PERD_DT_TO_USE_CD
WAIT_PERD_DT_TO_USE_RL
WAIT_PERD_RL
MX_POE_UOM
MX_POE_VAL
MX_POE_RL
MX_POE_APLS_CD
MX_POE_DET_DT_CD
MX_POE_DET_DT_RL