VIEW: APPS.BEN_ELIG_DPNT_CVRD_OTHR_PL

Source

View Text - Preformatted

SELECT edp.ELIG_DPNT_CVRD_OTHR_PL_ID ,edp.EFFECTIVE_START_DATE ,edp.EFFECTIVE_END_DATE ,edp.ORDR_NUM ,edp.EXCLD_FLAG ,edp.CVG_DET_DT_CD ,edp.BUSINESS_GROUP_ID ,edp.ELIGY_PRFL_ID ,edp.PL_ID ,edp.EDP_ATTRIBUTE_CATEGORY ,edp.EDP_ATTRIBUTE1 ,edp.EDP_ATTRIBUTE2 ,edp.EDP_ATTRIBUTE3 ,edp.EDP_ATTRIBUTE4 ,edp.EDP_ATTRIBUTE5 ,edp.EDP_ATTRIBUTE6 ,edp.EDP_ATTRIBUTE7 ,edp.EDP_ATTRIBUTE8 ,edp.EDP_ATTRIBUTE9 ,edp.EDP_ATTRIBUTE10 ,edp.EDP_ATTRIBUTE11 ,edp.EDP_ATTRIBUTE12 ,edp.EDP_ATTRIBUTE13 ,edp.EDP_ATTRIBUTE14 ,edp.EDP_ATTRIBUTE15 ,edp.EDP_ATTRIBUTE16 ,edp.EDP_ATTRIBUTE17 ,edp.EDP_ATTRIBUTE18 ,edp.EDP_ATTRIBUTE19 ,edp.EDP_ATTRIBUTE20 ,edp.EDP_ATTRIBUTE21 ,edp.EDP_ATTRIBUTE22 ,edp.EDP_ATTRIBUTE23 ,edp.EDP_ATTRIBUTE24 ,edp.EDP_ATTRIBUTE25 ,edp.EDP_ATTRIBUTE26 ,edp.EDP_ATTRIBUTE27 ,edp.EDP_ATTRIBUTE28 ,edp.EDP_ATTRIBUTE29 ,edp.EDP_ATTRIBUTE30 ,edp.LAST_UPDATE_DATE ,edp.LAST_UPDATED_BY ,edp.LAST_UPDATE_LOGIN ,edp.CREATED_BY ,edp.CREATION_DATE ,edp.OBJECT_VERSION_NUMBER from BEN_ELIG_DPNT_CVRD_OTHR_PL_F edp WHERE edp.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and edp.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT EDP.ELIG_DPNT_CVRD_OTHR_PL_ID
, EDP.EFFECTIVE_START_DATE
, EDP.EFFECTIVE_END_DATE
, EDP.ORDR_NUM
, EDP.EXCLD_FLAG
, EDP.CVG_DET_DT_CD
, EDP.BUSINESS_GROUP_ID
, EDP.ELIGY_PRFL_ID
, EDP.PL_ID
, EDP.EDP_ATTRIBUTE_CATEGORY
, EDP.EDP_ATTRIBUTE1
, EDP.EDP_ATTRIBUTE2
, EDP.EDP_ATTRIBUTE3
, EDP.EDP_ATTRIBUTE4
, EDP.EDP_ATTRIBUTE5
, EDP.EDP_ATTRIBUTE6
, EDP.EDP_ATTRIBUTE7
, EDP.EDP_ATTRIBUTE8
, EDP.EDP_ATTRIBUTE9
, EDP.EDP_ATTRIBUTE10
, EDP.EDP_ATTRIBUTE11
, EDP.EDP_ATTRIBUTE12
, EDP.EDP_ATTRIBUTE13
, EDP.EDP_ATTRIBUTE14
, EDP.EDP_ATTRIBUTE15
, EDP.EDP_ATTRIBUTE16
, EDP.EDP_ATTRIBUTE17
, EDP.EDP_ATTRIBUTE18
, EDP.EDP_ATTRIBUTE19
, EDP.EDP_ATTRIBUTE20
, EDP.EDP_ATTRIBUTE21
, EDP.EDP_ATTRIBUTE22
, EDP.EDP_ATTRIBUTE23
, EDP.EDP_ATTRIBUTE24
, EDP.EDP_ATTRIBUTE25
, EDP.EDP_ATTRIBUTE26
, EDP.EDP_ATTRIBUTE27
, EDP.EDP_ATTRIBUTE28
, EDP.EDP_ATTRIBUTE29
, EDP.EDP_ATTRIBUTE30
, EDP.LAST_UPDATE_DATE
, EDP.LAST_UPDATED_BY
, EDP.LAST_UPDATE_LOGIN
, EDP.CREATED_BY
, EDP.CREATION_DATE
, EDP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP
WHERE EDP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EDP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))