VIEW: APPS.BEN_BNFT_VRBL_RT

Source

View Text - Preformatted

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

View Text - HTML Formatted

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