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_RL

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

View Text

SELECT BRR.BNFT_VRBL_RT_RL_ID
, BRR.EFFECTIVE_START_DATE
, BRR.EFFECTIVE_END_DATE
, BRR.ORDR_TO_APLY_NUM
, BRR.CVG_AMT_CALC_MTHD_ID
, BRR.FORMULA_ID
, BRR.BUSINESS_GROUP_ID
, BRR.BRR_ATTRIBUTE_CATEGORY
, BRR.BRR_ATTRIBUTE1
, BRR.BRR_ATTRIBUTE2
, BRR.BRR_ATTRIBUTE3
, BRR.BRR_ATTRIBUTE4
, BRR.BRR_ATTRIBUTE5
, BRR.BRR_ATTRIBUTE6
, BRR.BRR_ATTRIBUTE7
, BRR.BRR_ATTRIBUTE8
, BRR.BRR_ATTRIBUTE9
, BRR.BRR_ATTRIBUTE10
, BRR.BRR_ATTRIBUTE11
, BRR.BRR_ATTRIBUTE12
, BRR.BRR_ATTRIBUTE13
, BRR.BRR_ATTRIBUTE14
, BRR.BRR_ATTRIBUTE15
, BRR.BRR_ATTRIBUTE16
, BRR.BRR_ATTRIBUTE17
, BRR.BRR_ATTRIBUTE18
, BRR.BRR_ATTRIBUTE19
, BRR.BRR_ATTRIBUTE20
, BRR.BRR_ATTRIBUTE21
, BRR.BRR_ATTRIBUTE22
, BRR.BRR_ATTRIBUTE23
, BRR.BRR_ATTRIBUTE24
, BRR.BRR_ATTRIBUTE25
, BRR.BRR_ATTRIBUTE26
, BRR.BRR_ATTRIBUTE27
, BRR.BRR_ATTRIBUTE28
, BRR.BRR_ATTRIBUTE29
, BRR.BRR_ATTRIBUTE30
, BRR.LAST_UPDATE_DATE
, BRR.LAST_UPDATED_BY
, BRR.LAST_UPDATE_LOGIN
, BRR.CREATED_BY
, BRR.CREATION_DATE
, BRR.OBJECT_VERSION_NUMBER
FROM BEN_BNFT_VRBL_RT_RL_F BRR
WHERE BRR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND BRR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
BNFT_VRBL_RT_RL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ORDR_TO_APLY_NUM
CVG_AMT_CALC_MTHD_ID
FORMULA_ID
BUSINESS_GROUP_ID
BRR_ATTRIBUTE_CATEGORY
BRR_ATTRIBUTE1
BRR_ATTRIBUTE2
BRR_ATTRIBUTE3
BRR_ATTRIBUTE4
BRR_ATTRIBUTE5
BRR_ATTRIBUTE6
BRR_ATTRIBUTE7
BRR_ATTRIBUTE8
BRR_ATTRIBUTE9
BRR_ATTRIBUTE10
BRR_ATTRIBUTE11
BRR_ATTRIBUTE12
BRR_ATTRIBUTE13
BRR_ATTRIBUTE14
BRR_ATTRIBUTE15
BRR_ATTRIBUTE16
BRR_ATTRIBUTE17
BRR_ATTRIBUTE18
BRR_ATTRIBUTE19
BRR_ATTRIBUTE20
BRR_ATTRIBUTE21
BRR_ATTRIBUTE22
BRR_ATTRIBUTE23
BRR_ATTRIBUTE24
BRR_ATTRIBUTE25
BRR_ATTRIBUTE26
BRR_ATTRIBUTE27
BRR_ATTRIBUTE28
BRR_ATTRIBUTE29
BRR_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER