VIEW: APPS.BEN_ELIG_TTL_CVG_VOL_PRTE

Source

View Text - Preformatted

SELECT ETC.ROWID, ETC.ELIG_TTL_CVG_VOL_PRTE_ID , ETC.EFFECTIVE_START_DATE , ETC.EFFECTIVE_END_DATE , ETC.BUSINESS_GROUP_ID , ETC.EXCLD_FLAG , ETC.NO_MN_CVG_VOL_AMT_APLS_FLAG, ETC.NO_MX_CVG_VOL_AMT_APLS_FLAG, ETC.ELIGY_PRFL_ID , ETC.ETC_ATTRIBUTE_CATEGORY , ETC.ETC_ATTRIBUTE1 , ETC.ETC_ATTRIBUTE2 , ETC.ETC_ATTRIBUTE3 , ETC.ETC_ATTRIBUTE4 , ETC.ETC_ATTRIBUTE5 , ETC.ETC_ATTRIBUTE6 , ETC.ETC_ATTRIBUTE7 , ETC.ETC_ATTRIBUTE8 , ETC.ETC_ATTRIBUTE9 , ETC.ETC_ATTRIBUTE10 , ETC.ETC_ATTRIBUTE11 , ETC.ETC_ATTRIBUTE12 , ETC.ETC_ATTRIBUTE13 , ETC.ETC_ATTRIBUTE14 , ETC.ETC_ATTRIBUTE15 , ETC.ETC_ATTRIBUTE16 , ETC.ETC_ATTRIBUTE17 , ETC.ETC_ATTRIBUTE18 , ETC.ETC_ATTRIBUTE19 , ETC.ETC_ATTRIBUTE20 , ETC.ETC_ATTRIBUTE21 , ETC.ETC_ATTRIBUTE22 , ETC.ETC_ATTRIBUTE23 , ETC.ETC_ATTRIBUTE24 , ETC.ETC_ATTRIBUTE25 , ETC.ETC_ATTRIBUTE26 , ETC.ETC_ATTRIBUTE27 , ETC.ETC_ATTRIBUTE28 , ETC.ETC_ATTRIBUTE29 , ETC.ETC_ATTRIBUTE30 , ETC.LAST_UPDATE_DATE , ETC.LAST_UPDATED_BY , ETC.LAST_UPDATE_LOGIN , ETC.CREATED_BY , ETC.CREATION_DATE , ETC.OBJECT_VERSION_NUMBER , ETC.ORDR_NUM , ETC.MN_CVG_VOL_AMT , ETC.MX_CVG_VOL_AMT , ETC.CVG_VOL_DET_CD , ETC.CVG_VOL_DET_RL FROM     BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC WHERE ETC.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and ETC.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT ETC.ROWID
, ETC.ELIG_TTL_CVG_VOL_PRTE_ID
, ETC.EFFECTIVE_START_DATE
, ETC.EFFECTIVE_END_DATE
, ETC.BUSINESS_GROUP_ID
, ETC.EXCLD_FLAG
, ETC.NO_MN_CVG_VOL_AMT_APLS_FLAG
, ETC.NO_MX_CVG_VOL_AMT_APLS_FLAG
, ETC.ELIGY_PRFL_ID
, ETC.ETC_ATTRIBUTE_CATEGORY
, ETC.ETC_ATTRIBUTE1
, ETC.ETC_ATTRIBUTE2
, ETC.ETC_ATTRIBUTE3
, ETC.ETC_ATTRIBUTE4
, ETC.ETC_ATTRIBUTE5
, ETC.ETC_ATTRIBUTE6
, ETC.ETC_ATTRIBUTE7
, ETC.ETC_ATTRIBUTE8
, ETC.ETC_ATTRIBUTE9
, ETC.ETC_ATTRIBUTE10
, ETC.ETC_ATTRIBUTE11
, ETC.ETC_ATTRIBUTE12
, ETC.ETC_ATTRIBUTE13
, ETC.ETC_ATTRIBUTE14
, ETC.ETC_ATTRIBUTE15
, ETC.ETC_ATTRIBUTE16
, ETC.ETC_ATTRIBUTE17
, ETC.ETC_ATTRIBUTE18
, ETC.ETC_ATTRIBUTE19
, ETC.ETC_ATTRIBUTE20
, ETC.ETC_ATTRIBUTE21
, ETC.ETC_ATTRIBUTE22
, ETC.ETC_ATTRIBUTE23
, ETC.ETC_ATTRIBUTE24
, ETC.ETC_ATTRIBUTE25
, ETC.ETC_ATTRIBUTE26
, ETC.ETC_ATTRIBUTE27
, ETC.ETC_ATTRIBUTE28
, ETC.ETC_ATTRIBUTE29
, ETC.ETC_ATTRIBUTE30
, ETC.LAST_UPDATE_DATE
, ETC.LAST_UPDATED_BY
, ETC.LAST_UPDATE_LOGIN
, ETC.CREATED_BY
, ETC.CREATION_DATE
, ETC.OBJECT_VERSION_NUMBER
, ETC.ORDR_NUM
, ETC.MN_CVG_VOL_AMT
, ETC.MX_CVG_VOL_AMT
, ETC.CVG_VOL_DET_CD
, ETC.CVG_VOL_DET_RL
FROM BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC
WHERE ETC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ETC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))