VIEW: APPS.BEN_VRBL_RT_RL_X

Source

View Text - Preformatted

SELECT VRR.VRBL_RT_RL_ID , VRR.EFFECTIVE_START_DATE , VRR.EFFECTIVE_END_DATE , VRR.DRVBL_FCTR_APLS_FLAG , VRR.RT_TRTMT_CD , VRR.ORDR_TO_APLY_NUM , VRR.FORMULA_ID , VRR.ACTY_BASE_RT_ID , VRR.BUSINESS_GROUP_ID , VRR.VRR_ATTRIBUTE_CATEGORY , VRR.VRR_ATTRIBUTE1 , VRR.VRR_ATTRIBUTE2 , VRR.VRR_ATTRIBUTE3 , VRR.VRR_ATTRIBUTE4 , VRR.VRR_ATTRIBUTE5 , VRR.VRR_ATTRIBUTE6 , VRR.VRR_ATTRIBUTE7 , VRR.VRR_ATTRIBUTE8 , VRR.VRR_ATTRIBUTE9 , VRR.VRR_ATTRIBUTE10 , VRR.VRR_ATTRIBUTE11 , VRR.VRR_ATTRIBUTE12 , VRR.VRR_ATTRIBUTE13 , VRR.VRR_ATTRIBUTE14 , VRR.VRR_ATTRIBUTE15 , VRR.VRR_ATTRIBUTE16 , VRR.VRR_ATTRIBUTE17 , VRR.VRR_ATTRIBUTE18 , VRR.VRR_ATTRIBUTE19 , VRR.VRR_ATTRIBUTE20 , VRR.VRR_ATTRIBUTE21 , VRR.VRR_ATTRIBUTE22 , VRR.VRR_ATTRIBUTE23 , VRR.VRR_ATTRIBUTE24 , VRR.VRR_ATTRIBUTE25 , VRR.VRR_ATTRIBUTE26 , VRR.VRR_ATTRIBUTE27 , VRR.VRR_ATTRIBUTE28 , VRR.VRR_ATTRIBUTE29 , VRR.VRR_ATTRIBUTE30 , VRR.LAST_UPDATE_DATE , VRR.LAST_UPDATED_BY , VRR.LAST_UPDATE_LOGIN , VRR.CREATED_BY , VRR.CREATION_DATE , VRR.OBJECT_VERSION_NUMBER FROM BEN_VRBL_RT_RL_F VRR WHERE TRUNC(SYSDATE) BETWEEN VRR.EFFECTIVE_START_DATE AND VRR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT VRR.VRBL_RT_RL_ID
, VRR.EFFECTIVE_START_DATE
, VRR.EFFECTIVE_END_DATE
, VRR.DRVBL_FCTR_APLS_FLAG
, VRR.RT_TRTMT_CD
, VRR.ORDR_TO_APLY_NUM
, VRR.FORMULA_ID
, VRR.ACTY_BASE_RT_ID
, VRR.BUSINESS_GROUP_ID
, VRR.VRR_ATTRIBUTE_CATEGORY
, VRR.VRR_ATTRIBUTE1
, VRR.VRR_ATTRIBUTE2
, VRR.VRR_ATTRIBUTE3
, VRR.VRR_ATTRIBUTE4
, VRR.VRR_ATTRIBUTE5
, VRR.VRR_ATTRIBUTE6
, VRR.VRR_ATTRIBUTE7
, VRR.VRR_ATTRIBUTE8
, VRR.VRR_ATTRIBUTE9
, VRR.VRR_ATTRIBUTE10
, VRR.VRR_ATTRIBUTE11
, VRR.VRR_ATTRIBUTE12
, VRR.VRR_ATTRIBUTE13
, VRR.VRR_ATTRIBUTE14
, VRR.VRR_ATTRIBUTE15
, VRR.VRR_ATTRIBUTE16
, VRR.VRR_ATTRIBUTE17
, VRR.VRR_ATTRIBUTE18
, VRR.VRR_ATTRIBUTE19
, VRR.VRR_ATTRIBUTE20
, VRR.VRR_ATTRIBUTE21
, VRR.VRR_ATTRIBUTE22
, VRR.VRR_ATTRIBUTE23
, VRR.VRR_ATTRIBUTE24
, VRR.VRR_ATTRIBUTE25
, VRR.VRR_ATTRIBUTE26
, VRR.VRR_ATTRIBUTE27
, VRR.VRR_ATTRIBUTE28
, VRR.VRR_ATTRIBUTE29
, VRR.VRR_ATTRIBUTE30
, VRR.LAST_UPDATE_DATE
, VRR.LAST_UPDATED_BY
, VRR.LAST_UPDATE_LOGIN
, VRR.CREATED_BY
, VRR.CREATION_DATE
, VRR.OBJECT_VERSION_NUMBER
FROM BEN_VRBL_RT_RL_F VRR
WHERE TRUNC(SYSDATE) BETWEEN VRR.EFFECTIVE_START_DATE
AND VRR.EFFECTIVE_END_DATE