Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_ENRLD_ANTHR_PLIP |
SELECT EAI.ELIG_ENRLD_ANTHR_PLIP_ID
, EAI.EFFECTIVE_START_DATE
, EAI.EFFECTIVE_END_DATE
, EAI.EXCLD_FLAG
, EAI.ENRL_DET_DT_CD
, EAI.ORDR_NUM
, EAI.PLIP_ID
, EAI.ELIGY_PRFL_ID
, EAI.BUSINESS_GROUP_ID
, EAI.EAI_ATTRIBUTE_CATEGORY
, EAI.EAI_ATTRIBUTE1
, EAI.EAI_ATTRIBUTE2
, EAI.EAI_ATTRIBUTE3
, EAI.EAI_ATTRIBUTE4
, EAI.EAI_ATTRIBUTE5
, EAI.EAI_ATTRIBUTE6
, EAI.EAI_ATTRIBUTE7
, EAI.EAI_ATTRIBUTE8
, EAI.EAI_ATTRIBUTE9
, EAI.EAI_ATTRIBUTE10
, EAI.EAI_ATTRIBUTE11
, EAI.EAI_ATTRIBUTE12
, EAI.EAI_ATTRIBUTE13
, EAI.EAI_ATTRIBUTE14
, EAI.EAI_ATTRIBUTE15
, EAI.EAI_ATTRIBUTE16
, EAI.EAI_ATTRIBUTE17
, EAI.EAI_ATTRIBUTE18
, EAI.EAI_ATTRIBUTE19
, EAI.EAI_ATTRIBUTE20
, EAI.EAI_ATTRIBUTE21
, EAI.EAI_ATTRIBUTE22
, EAI.EAI_ATTRIBUTE23
, EAI.EAI_ATTRIBUTE24
, EAI.EAI_ATTRIBUTE25
, EAI.EAI_ATTRIBUTE26
, EAI.EAI_ATTRIBUTE27
, EAI.EAI_ATTRIBUTE28
, EAI.EAI_ATTRIBUTE29
, EAI.EAI_ATTRIBUTE30
, EAI.LAST_UPDATE_DATE
, EAI.LAST_UPDATED_BY
, EAI.LAST_UPDATE_LOGIN
, EAI.CREATED_BY
, EAI.CREATION_DATE
, EAI.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI
WHERE EAI.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EAI.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))