Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_ENRLD_ANTHR_OIPL |
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 EEI.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EEI.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))