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_ENRLD_ANTHR_PGM_RT

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

View Text

SELECT EPM.ROWID ROW_ID
, EPM.ENRLD_ANTHR_PGM_RT_ID
, EPM.EFFECTIVE_START_DATE
, EPM.EFFECTIVE_END_DATE
, EPM.ORDR_NUM
, EPM.EXCLD_FLAG
, EPM.ENRL_DET_DT_CD
, EPM.PGM_ID
, EPM.VRBL_RT_PRFL_ID
, EPM.BUSINESS_GROUP_ID
, EPM.EPM_ATTRIBUTE_CATEGORY
, EPM.EPM_ATTRIBUTE1
, EPM.EPM_ATTRIBUTE2
, EPM.EPM_ATTRIBUTE3
, EPM.EPM_ATTRIBUTE4
, EPM.EPM_ATTRIBUTE5
, EPM.EPM_ATTRIBUTE6
, EPM.EPM_ATTRIBUTE7
, EPM.EPM_ATTRIBUTE8
, EPM.EPM_ATTRIBUTE9
, EPM.EPM_ATTRIBUTE10
, EPM.EPM_ATTRIBUTE11
, EPM.EPM_ATTRIBUTE12
, EPM.EPM_ATTRIBUTE13
, EPM.EPM_ATTRIBUTE14
, EPM.EPM_ATTRIBUTE15
, EPM.EPM_ATTRIBUTE16
, EPM.EPM_ATTRIBUTE17
, EPM.EPM_ATTRIBUTE18
, EPM.EPM_ATTRIBUTE19
, EPM.EPM_ATTRIBUTE20
, EPM.EPM_ATTRIBUTE21
, EPM.EPM_ATTRIBUTE22
, EPM.EPM_ATTRIBUTE23
, EPM.EPM_ATTRIBUTE24
, EPM.EPM_ATTRIBUTE25
, EPM.EPM_ATTRIBUTE26
, EPM.EPM_ATTRIBUTE27
, EPM.EPM_ATTRIBUTE28
, EPM.EPM_ATTRIBUTE29
, EPM.EPM_ATTRIBUTE30
, EPM.LAST_UPDATE_DATE
, EPM.LAST_UPDATED_BY
, EPM.LAST_UPDATE_LOGIN
, EPM.CREATED_BY
, EPM.CREATION_DATE
, EPM.OBJECT_VERSION_NUMBER
FROM BEN_ENRLD_ANTHR_PGM_RT_F EPM
WHERE EPM.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPM.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
ROW_ID
ENRLD_ANTHR_PGM_RT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ORDR_NUM
EXCLD_FLAG
ENRL_DET_DT_CD
PGM_ID
VRBL_RT_PRFL_ID
BUSINESS_GROUP_ID
EPM_ATTRIBUTE_CATEGORY
EPM_ATTRIBUTE1
EPM_ATTRIBUTE2
EPM_ATTRIBUTE3
EPM_ATTRIBUTE4
EPM_ATTRIBUTE5
EPM_ATTRIBUTE6
EPM_ATTRIBUTE7
EPM_ATTRIBUTE8
EPM_ATTRIBUTE9
EPM_ATTRIBUTE10
EPM_ATTRIBUTE11
EPM_ATTRIBUTE12
EPM_ATTRIBUTE13
EPM_ATTRIBUTE14
EPM_ATTRIBUTE15
EPM_ATTRIBUTE16
EPM_ATTRIBUTE17
EPM_ATTRIBUTE18
EPM_ATTRIBUTE19
EPM_ATTRIBUTE20
EPM_ATTRIBUTE21
EPM_ATTRIBUTE22
EPM_ATTRIBUTE23
EPM_ATTRIBUTE24
EPM_ATTRIBUTE25
EPM_ATTRIBUTE26
EPM_ATTRIBUTE27
EPM_ATTRIBUTE28
EPM_ATTRIBUTE29
EPM_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER