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_APLD_DPNT_CVG_ELIG_PRFL

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

View Text

SELECT ADE.APLD_DPNT_CVG_ELIG_PRFL_ID
, ADE.EFFECTIVE_START_DATE
, ADE.EFFECTIVE_END_DATE
, ADE.BUSINESS_GROUP_ID
, ADE.APLD_DPNT_CVG_ELIG_RL
, ADE.MNDTRY_FLAG
, ADE.DPNT_CVG_ELIGY_PRFL_ID
, ADE.PGM_ID
, ADE.PL_ID
, ADE.PTIP_ID
, ADE.ADE_ATTRIBUTE_CATEGORY
, ADE.ADE_ATTRIBUTE1
, ADE.ADE_ATTRIBUTE2
, ADE.ADE_ATTRIBUTE3
, ADE.ADE_ATTRIBUTE4
, ADE.ADE_ATTRIBUTE5
, ADE.ADE_ATTRIBUTE6
, ADE.ADE_ATTRIBUTE7
, ADE.ADE_ATTRIBUTE8
, ADE.ADE_ATTRIBUTE9
, ADE.ADE_ATTRIBUTE10
, ADE.ADE_ATTRIBUTE11
, ADE.ADE_ATTRIBUTE12
, ADE.ADE_ATTRIBUTE13
, ADE.ADE_ATTRIBUTE14
, ADE.ADE_ATTRIBUTE15
, ADE.ADE_ATTRIBUTE16
, ADE.ADE_ATTRIBUTE17
, ADE.ADE_ATTRIBUTE18
, ADE.ADE_ATTRIBUTE19
, ADE.ADE_ATTRIBUTE20
, ADE.ADE_ATTRIBUTE21
, ADE.ADE_ATTRIBUTE22
, ADE.ADE_ATTRIBUTE23
, ADE.ADE_ATTRIBUTE24
, ADE.ADE_ATTRIBUTE25
, ADE.ADE_ATTRIBUTE26
, ADE.ADE_ATTRIBUTE27
, ADE.ADE_ATTRIBUTE28
, ADE.ADE_ATTRIBUTE29
, ADE.ADE_ATTRIBUTE30
, ADE.LAST_UPDATE_DATE
, ADE.LAST_UPDATED_BY
, ADE.LAST_UPDATE_LOGIN
, ADE.CREATED_BY
, ADE.CREATION_DATE
, ADE.OBJECT_VERSION_NUMBER
FROM BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE
WHERE ADE.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ADE.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
APLD_DPNT_CVG_ELIG_PRFL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
APLD_DPNT_CVG_ELIG_RL
MNDTRY_FLAG
DPNT_CVG_ELIGY_PRFL_ID
PGM_ID
PL_ID
PTIP_ID
ADE_ATTRIBUTE_CATEGORY
ADE_ATTRIBUTE1
ADE_ATTRIBUTE2
ADE_ATTRIBUTE3
ADE_ATTRIBUTE4
ADE_ATTRIBUTE5
ADE_ATTRIBUTE6
ADE_ATTRIBUTE7
ADE_ATTRIBUTE8
ADE_ATTRIBUTE9
ADE_ATTRIBUTE10
ADE_ATTRIBUTE11
ADE_ATTRIBUTE12
ADE_ATTRIBUTE13
ADE_ATTRIBUTE14
ADE_ATTRIBUTE15
ADE_ATTRIBUTE16
ADE_ATTRIBUTE17
ADE_ATTRIBUTE18
ADE_ATTRIBUTE19
ADE_ATTRIBUTE20
ADE_ATTRIBUTE21
ADE_ATTRIBUTE22
ADE_ATTRIBUTE23
ADE_ATTRIBUTE24
ADE_ATTRIBUTE25
ADE_ATTRIBUTE26
ADE_ATTRIBUTE27
ADE_ATTRIBUTE28
ADE_ATTRIBUTE29
ADE_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER