Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_VRBL_RT_RL_X |
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