View: BEN_ELIG_ENRLD_ANTHR_OIPL_X

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

View Text

SELECT EEI.ELIG_ENRLD_ANTHR_OIPL_ID
, EEI.EFFECTIVE_START_DATE
, EEI.EFFECTIVE_END_DATE
, EEI.ORDR_NUM
, EEI.EXCLD_FLAG
, EEI.ENRL_DET_DT_CD
, EEI.BUSINESS_GROUP_ID
, EEI.OIPL_ID
, EEI.ELIGY_PRFL_ID
, EEI.EEI_ATTRIBUTE_CATEGORY
, EEI.EEI_ATTRIBUTE1
, EEI.EEI_ATTRIBUTE2
, EEI.EEI_ATTRIBUTE3
, EEI.EEI_ATTRIBUTE4
, EEI.EEI_ATTRIBUTE5
, EEI.EEI_ATTRIBUTE6
, EEI.EEI_ATTRIBUTE7
, EEI.EEI_ATTRIBUTE8
, EEI.EEI_ATTRIBUTE9
, EEI.EEI_ATTRIBUTE10
, EEI.EEI_ATTRIBUTE11
, EEI.EEI_ATTRIBUTE12
, EEI.EEI_ATTRIBUTE13
, EEI.EEI_ATTRIBUTE14
, EEI.EEI_ATTRIBUTE15
, EEI.EEI_ATTRIBUTE16
, EEI.EEI_ATTRIBUTE17
, EEI.EEI_ATTRIBUTE18
, EEI.EEI_ATTRIBUTE19
, EEI.EEI_ATTRIBUTE20
, EEI.EEI_ATTRIBUTE21
, EEI.EEI_ATTRIBUTE22
, EEI.EEI_ATTRIBUTE23
, EEI.EEI_ATTRIBUTE24
, EEI.EEI_ATTRIBUTE25
, EEI.EEI_ATTRIBUTE26
, EEI.EEI_ATTRIBUTE27
, EEI.EEI_ATTRIBUTE28
, EEI.EEI_ATTRIBUTE29
, EEI.EEI_ATTRIBUTE30
, EEI.LAST_UPDATE_DATE
, EEI.LAST_UPDATED_BY
, EEI.LAST_UPDATE_LOGIN
, EEI.CREATED_BY
, EEI.CREATION_DATE
, EEI.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ENRLD_ANTHR_OIPL_F EEI
WHERE TRUNC(SYSDATE) BETWEEN EEI.EFFECTIVE_START_DATE
AND EEI.EFFECTIVE_END_DATE

Columns