View: BEN_VRBL_MTCHG_RT

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

View Text

SELECT VMR.VRBL_MTCHG_RT_ID
, VMR.EFFECTIVE_END_DATE
, VMR.EFFECTIVE_START_DATE
, VMR.NO_MX_PCT_OF_PY_NUM_FLAG
, VMR.TO_PCT_VAL
, VMR.NO_MX_AMT_OF_PY_NUM_FLAG
, VMR.MX_PCT_OF_PY_NUM
, VMR.NO_MX_MTCH_AMT_FLAG
, VMR.ORDR_NUM
, VMR.PCT_VAL
, VMR.MX_MTCH_AMT
, VMR.MX_AMT_OF_PY_NUM
, VMR.MN_MTCH_AMT
, VMR.MTCHG_RT_CALC_RL
, VMR.CNTNU_MTCH_AFTR_MAX_RL_FLAG
, VMR.FROM_PCT_VAL
, VMR.VRBL_RT_PRFL_ID
, VMR.BUSINESS_GROUP_ID
, VMR.VMR_ATTRIBUTE_CATEGORY
, VMR.VMR_ATTRIBUTE1
, VMR.VMR_ATTRIBUTE2
, VMR.VMR_ATTRIBUTE3
, VMR.VMR_ATTRIBUTE4
, VMR.VMR_ATTRIBUTE5
, VMR.VMR_ATTRIBUTE6
, VMR.VMR_ATTRIBUTE7
, VMR.VMR_ATTRIBUTE8
, VMR.VMR_ATTRIBUTE9
, VMR.VMR_ATTRIBUTE10
, VMR.VMR_ATTRIBUTE11
, VMR.VMR_ATTRIBUTE12
, VMR.VMR_ATTRIBUTE13
, VMR.VMR_ATTRIBUTE14
, VMR.VMR_ATTRIBUTE15
, VMR.VMR_ATTRIBUTE16
, VMR.VMR_ATTRIBUTE17
, VMR.VMR_ATTRIBUTE18
, VMR.VMR_ATTRIBUTE19
, VMR.VMR_ATTRIBUTE20
, VMR.VMR_ATTRIBUTE21
, VMR.VMR_ATTRIBUTE22
, VMR.VMR_ATTRIBUTE23
, VMR.VMR_ATTRIBUTE24
, VMR.VMR_ATTRIBUTE25
, VMR.VMR_ATTRIBUTE26
, VMR.VMR_ATTRIBUTE27
, VMR.VMR_ATTRIBUTE28
, VMR.VMR_ATTRIBUTE29
, VMR.VMR_ATTRIBUTE30
, VMR.LAST_UPDATE_DATE
, VMR.LAST_UPDATED_BY
, VMR.LAST_UPDATE_LOGIN
, VMR.CREATED_BY
, VMR.CREATION_DATE
, VMR.OBJECT_VERSION_NUMBER
FROM BEN_VRBL_MTCHG_RT_F VMR
WHERE VMR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND VMR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns