VIEW: APPS.BEN_ELIG_OPTD_MDCR_PRTE

Source

View Text - Preformatted

SELECT eom.ELIG_OPTD_MDCR_PRTE_ID ,eom.EFFECTIVE_START_DATE ,eom.EFFECTIVE_END_DATE ,eom.OPTD_MDCR_FLAG ,eom.EXLCD_FLAG ,eom.ELIGY_PRFL_ID ,eom.BUSINESS_GROUP_ID ,eom.EOM_ATTRIBUTE_CATEGORY ,eom.EOM_ATTRIBUTE1 ,eom.EOM_ATTRIBUTE2 ,eom.EOM_ATTRIBUTE3 ,eom.EOM_ATTRIBUTE4 ,eom.EOM_ATTRIBUTE5 ,eom.EOM_ATTRIBUTE6 ,eom.EOM_ATTRIBUTE7 ,eom.EOM_ATTRIBUTE8 ,eom.EOM_ATTRIBUTE9 ,eom.EOM_ATTRIBUTE10 ,eom.EOM_ATTRIBUTE11 ,eom.EOM_ATTRIBUTE12 ,eom.EOM_ATTRIBUTE13 ,eom.EOM_ATTRIBUTE14 ,eom.EOM_ATTRIBUTE15 ,eom.EOM_ATTRIBUTE16 ,eom.EOM_ATTRIBUTE17 ,eom.EOM_ATTRIBUTE18 ,eom.EOM_ATTRIBUTE19 ,eom.EOM_ATTRIBUTE20 ,eom.EOM_ATTRIBUTE21 ,eom.EOM_ATTRIBUTE22 ,eom.EOM_ATTRIBUTE23 ,eom.EOM_ATTRIBUTE24 ,eom.EOM_ATTRIBUTE25 ,eom.EOM_ATTRIBUTE26 ,eom.EOM_ATTRIBUTE27 ,eom.EOM_ATTRIBUTE28 ,eom.EOM_ATTRIBUTE29 ,eom.EOM_ATTRIBUTE30 ,eom.LAST_UPDATE_DATE ,eom.LAST_UPDATED_BY ,eom.LAST_UPDATE_LOGIN ,eom.CREATED_BY ,eom.CREATION_DATE ,eom.OBJECT_VERSION_NUMBER from BEN_ELIG_OPTD_MDCR_PRTE_F eom WHERE eom.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and eom.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT EOM.ELIG_OPTD_MDCR_PRTE_ID
, EOM.EFFECTIVE_START_DATE
, EOM.EFFECTIVE_END_DATE
, EOM.OPTD_MDCR_FLAG
, EOM.EXLCD_FLAG
, EOM.ELIGY_PRFL_ID
, EOM.BUSINESS_GROUP_ID
, EOM.EOM_ATTRIBUTE_CATEGORY
, EOM.EOM_ATTRIBUTE1
, EOM.EOM_ATTRIBUTE2
, EOM.EOM_ATTRIBUTE3
, EOM.EOM_ATTRIBUTE4
, EOM.EOM_ATTRIBUTE5
, EOM.EOM_ATTRIBUTE6
, EOM.EOM_ATTRIBUTE7
, EOM.EOM_ATTRIBUTE8
, EOM.EOM_ATTRIBUTE9
, EOM.EOM_ATTRIBUTE10
, EOM.EOM_ATTRIBUTE11
, EOM.EOM_ATTRIBUTE12
, EOM.EOM_ATTRIBUTE13
, EOM.EOM_ATTRIBUTE14
, EOM.EOM_ATTRIBUTE15
, EOM.EOM_ATTRIBUTE16
, EOM.EOM_ATTRIBUTE17
, EOM.EOM_ATTRIBUTE18
, EOM.EOM_ATTRIBUTE19
, EOM.EOM_ATTRIBUTE20
, EOM.EOM_ATTRIBUTE21
, EOM.EOM_ATTRIBUTE22
, EOM.EOM_ATTRIBUTE23
, EOM.EOM_ATTRIBUTE24
, EOM.EOM_ATTRIBUTE25
, EOM.EOM_ATTRIBUTE26
, EOM.EOM_ATTRIBUTE27
, EOM.EOM_ATTRIBUTE28
, EOM.EOM_ATTRIBUTE29
, EOM.EOM_ATTRIBUTE30
, EOM.LAST_UPDATE_DATE
, EOM.LAST_UPDATED_BY
, EOM.LAST_UPDATE_LOGIN
, EOM.CREATED_BY
, EOM.CREATION_DATE
, EOM.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_OPTD_MDCR_PRTE_F EOM
WHERE EOM.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EOM.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))