Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_ENRLD_ANTHR_PLIP_V |
SELECT EAI.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EAI.EFFECTIVE_START_DATE
AND EAI.EFFECTIVE_END_DATE