VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PL_V

Source

View Text - Preformatted

SELECT eep.ROWID ROW_ID, 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, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between eep.effective_start_date and eep.effective_end_date

View Text - HTML Formatted

SELECT EEP.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EEP.EFFECTIVE_START_DATE
AND EEP.EFFECTIVE_END_DATE