VIEW: APPS.BEN_BNFT_VRBL_RT_RL_V

Source

View Text - Preformatted

SELECT BRR.ROWID ROW_ID , 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, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN BRR.EFFECTIVE_START_DATE AND BRR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT BRR.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN BRR.EFFECTIVE_START_DATE
AND BRR.EFFECTIVE_END_DATE