eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_BNFT_VRBL_RT

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

View Text

SELECT BVR.BNFT_VRBL_RT_ID
, BVR.EFFECTIVE_START_DATE
, BVR.EFFECTIVE_END_DATE
, BVR.CVG_AMT_CALC_MTHD_ID
, BVR.VRBL_RT_PRFL_ID
, BVR.BUSINESS_GROUP_ID
, BVR.BVR_ATTRIBUTE_CATEGORY
, BVR.BVR_ATTRIBUTE1
, BVR.BVR_ATTRIBUTE2
, BVR.BVR_ATTRIBUTE3
, BVR.BVR_ATTRIBUTE4
, BVR.BVR_ATTRIBUTE5
, BVR.BVR_ATTRIBUTE6
, BVR.BVR_ATTRIBUTE7
, BVR.BVR_ATTRIBUTE8
, BVR.BVR_ATTRIBUTE9
, BVR.BVR_ATTRIBUTE10
, BVR.BVR_ATTRIBUTE11
, BVR.BVR_ATTRIBUTE12
, BVR.BVR_ATTRIBUTE13
, BVR.BVR_ATTRIBUTE14
, BVR.BVR_ATTRIBUTE15
, BVR.BVR_ATTRIBUTE16
, BVR.BVR_ATTRIBUTE17
, BVR.BVR_ATTRIBUTE18
, BVR.BVR_ATTRIBUTE19
, BVR.BVR_ATTRIBUTE20
, BVR.BVR_ATTRIBUTE21
, BVR.BVR_ATTRIBUTE22
, BVR.BVR_ATTRIBUTE23
, BVR.BVR_ATTRIBUTE24
, BVR.BVR_ATTRIBUTE25
, BVR.BVR_ATTRIBUTE26
, BVR.BVR_ATTRIBUTE27
, BVR.BVR_ATTRIBUTE28
, BVR.BVR_ATTRIBUTE29
, BVR.BVR_ATTRIBUTE30
, BVR.LAST_UPDATE_DATE
, BVR.LAST_UPDATED_BY
, BVR.LAST_UPDATE_LOGIN
, BVR.CREATED_BY
, BVR.CREATION_DATE
, BVR.OBJECT_VERSION_NUMBER
, ORDR_NUM
FROM BEN_BNFT_VRBL_RT_F BVR
WHERE BVR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND BVR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
BNFT_VRBL_RT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
CVG_AMT_CALC_MTHD_ID
VRBL_RT_PRFL_ID
BUSINESS_GROUP_ID
BVR_ATTRIBUTE_CATEGORY
BVR_ATTRIBUTE1
BVR_ATTRIBUTE2
BVR_ATTRIBUTE3
BVR_ATTRIBUTE4
BVR_ATTRIBUTE5
BVR_ATTRIBUTE6
BVR_ATTRIBUTE7
BVR_ATTRIBUTE8
BVR_ATTRIBUTE9
BVR_ATTRIBUTE10
BVR_ATTRIBUTE11
BVR_ATTRIBUTE12
BVR_ATTRIBUTE13
BVR_ATTRIBUTE14
BVR_ATTRIBUTE15
BVR_ATTRIBUTE16
BVR_ATTRIBUTE17
BVR_ATTRIBUTE18
BVR_ATTRIBUTE19
BVR_ATTRIBUTE20
BVR_ATTRIBUTE21
BVR_ATTRIBUTE22
BVR_ATTRIBUTE23
BVR_ATTRIBUTE24
BVR_ATTRIBUTE25
BVR_ATTRIBUTE26
BVR_ATTRIBUTE27
BVR_ATTRIBUTE28
BVR_ATTRIBUTE29
BVR_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ORDR_NUM