VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PLIP

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))