View: BEN_ELIG_TTL_CVG_VOL_PRTE

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ELIG_TTL_CVG_VOL_PRTE

View Text

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'))

Columns