VIEW: APPS.BEN_ELIG_DSBLD_STAT_PRTE

Source

View Text - Preformatted

SELECT eds.DSBLD_CD ,eds.ELIG_DSBLD_STAT_PRTE_ID ,eds.EFFECTIVE_START_DATE ,eds.EFFECTIVE_END_DATE ,eds.EXCLD_FLAG ,eds.ORDR_NUM ,eds.ELIGY_PRFL_ID ,eds.BUSINESS_GROUP_ID ,eds.EDS_ATTRIBUTE_CATEGORY ,eds.EDS_ATTRIBUTE1 ,eds.EDS_ATTRIBUTE2 ,eds.EDS_ATTRIBUTE3 ,eds.EDS_ATTRIBUTE4 ,eds.EDS_ATTRIBUTE5 ,eds.EDS_ATTRIBUTE6 ,eds.EDS_ATTRIBUTE7 ,eds.EDS_ATTRIBUTE8 ,eds.EDS_ATTRIBUTE9 ,eds.EDS_ATTRIBUTE10 ,eds.EDS_ATTRIBUTE11 ,eds.EDS_ATTRIBUTE12 ,eds.EDS_ATTRIBUTE13 ,eds.EDS_ATTRIBUTE14 ,eds.EDS_ATTRIBUTE15 ,eds.EDS_ATTRIBUTE16 ,eds.EDS_ATTRIBUTE17 ,eds.EDS_ATTRIBUTE18 ,eds.EDS_ATTRIBUTE19 ,eds.EDS_ATTRIBUTE20 ,eds.EDS_ATTRIBUTE21 ,eds.EDS_ATTRIBUTE22 ,eds.EDS_ATTRIBUTE23 ,eds.EDS_ATTRIBUTE24 ,eds.EDS_ATTRIBUTE25 ,eds.EDS_ATTRIBUTE26 ,eds.EDS_ATTRIBUTE27 ,eds.EDS_ATTRIBUTE28 ,eds.EDS_ATTRIBUTE29 ,eds.EDS_ATTRIBUTE30 ,eds.LAST_UPDATE_DATE ,eds.LAST_UPDATED_BY ,eds.LAST_UPDATE_LOGIN ,eds.CREATED_BY ,eds.CREATION_DATE ,eds.OBJECT_VERSION_NUMBER from BEN_ELIG_DSBLD_STAT_PRTE_F eds WHERE eds.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and eds.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT EDS.DSBLD_CD
, EDS.ELIG_DSBLD_STAT_PRTE_ID
, EDS.EFFECTIVE_START_DATE
, EDS.EFFECTIVE_END_DATE
, EDS.EXCLD_FLAG
, EDS.ORDR_NUM
, EDS.ELIGY_PRFL_ID
, EDS.BUSINESS_GROUP_ID
, EDS.EDS_ATTRIBUTE_CATEGORY
, EDS.EDS_ATTRIBUTE1
, EDS.EDS_ATTRIBUTE2
, EDS.EDS_ATTRIBUTE3
, EDS.EDS_ATTRIBUTE4
, EDS.EDS_ATTRIBUTE5
, EDS.EDS_ATTRIBUTE6
, EDS.EDS_ATTRIBUTE7
, EDS.EDS_ATTRIBUTE8
, EDS.EDS_ATTRIBUTE9
, EDS.EDS_ATTRIBUTE10
, EDS.EDS_ATTRIBUTE11
, EDS.EDS_ATTRIBUTE12
, EDS.EDS_ATTRIBUTE13
, EDS.EDS_ATTRIBUTE14
, EDS.EDS_ATTRIBUTE15
, EDS.EDS_ATTRIBUTE16
, EDS.EDS_ATTRIBUTE17
, EDS.EDS_ATTRIBUTE18
, EDS.EDS_ATTRIBUTE19
, EDS.EDS_ATTRIBUTE20
, EDS.EDS_ATTRIBUTE21
, EDS.EDS_ATTRIBUTE22
, EDS.EDS_ATTRIBUTE23
, EDS.EDS_ATTRIBUTE24
, EDS.EDS_ATTRIBUTE25
, EDS.EDS_ATTRIBUTE26
, EDS.EDS_ATTRIBUTE27
, EDS.EDS_ATTRIBUTE28
, EDS.EDS_ATTRIBUTE29
, EDS.EDS_ATTRIBUTE30
, EDS.LAST_UPDATE_DATE
, EDS.LAST_UPDATED_BY
, EDS.LAST_UPDATE_LOGIN
, EDS.CREATED_BY
, EDS.CREATION_DATE
, EDS.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLD_STAT_PRTE_F EDS
WHERE EDS.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EDS.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))