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