View: BEN_ELIG_ENRLD_ANTHR_PL_V

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

View Text

SELECT EEP.ROWID ROW_ID
, EEP.ELIG_ENRLD_ANTHR_PL_ID
, EEP.EFFECTIVE_START_DATE
, EEP.EFFECTIVE_END_DATE
, EEP.ORDR_NUM
, EEP.EXCLD_FLAG
, EEP.ENRL_DET_DT_CD
, EEP.BUSINESS_GROUP_ID
, EEP.ELIGY_PRFL_ID
, EEP.PL_ID
, EEP.EEP_ATTRIBUTE_CATEGORY
, EEP.EEP_ATTRIBUTE1
, EEP.EEP_ATTRIBUTE2
, EEP.EEP_ATTRIBUTE3
, EEP.EEP_ATTRIBUTE4
, EEP.EEP_ATTRIBUTE5
, EEP.EEP_ATTRIBUTE6
, EEP.EEP_ATTRIBUTE7
, EEP.EEP_ATTRIBUTE8
, EEP.EEP_ATTRIBUTE9
, EEP.EEP_ATTRIBUTE10
, EEP.EEP_ATTRIBUTE11
, EEP.EEP_ATTRIBUTE12
, EEP.EEP_ATTRIBUTE13
, EEP.EEP_ATTRIBUTE14
, EEP.EEP_ATTRIBUTE15
, EEP.EEP_ATTRIBUTE16
, EEP.EEP_ATTRIBUTE17
, EEP.EEP_ATTRIBUTE18
, EEP.EEP_ATTRIBUTE19
, EEP.EEP_ATTRIBUTE20
, EEP.EEP_ATTRIBUTE21
, EEP.EEP_ATTRIBUTE22
, EEP.EEP_ATTRIBUTE23
, EEP.EEP_ATTRIBUTE24
, EEP.EEP_ATTRIBUTE25
, EEP.EEP_ATTRIBUTE26
, EEP.EEP_ATTRIBUTE27
, EEP.EEP_ATTRIBUTE28
, EEP.EEP_ATTRIBUTE29
, EEP.EEP_ATTRIBUTE30
, EEP.LAST_UPDATE_DATE
, EEP.LAST_UPDATED_BY
, EEP.LAST_UPDATE_LOGIN
, EEP.CREATED_BY
, EEP.CREATION_DATE
, EEP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ENRLD_ANTHR_PL_F EEP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EEP.EFFECTIVE_START_DATE
AND EEP.EFFECTIVE_END_DATE

Columns