Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_MTCHG_RT |
SELECT MTR.MTCHG_RT_ID
, MTR.EFFECTIVE_START_DATE
, MTR.EFFECTIVE_END_DATE
, MTR.ORDR_NUM
, MTR.FROM_PCT_VAL
, MTR.TO_PCT_VAL
, MTR.PCT_VAL
, MTR.MX_AMT_OF_PY_NUM
, MTR.MX_PCT_OF_PY_NUM
, MTR.MX_MTCH_AMT
, MTR.MN_MTCH_AMT
, MTR.MTCHG_RT_CALC_RL
, MTR.NO_MX_MTCH_AMT_FLAG
, MTR.NO_MX_PCT_OF_PY_NUM_FLAG
, MTR.CNTNU_MTCH_AFTR_MX_RL_FLAG
, MTR.NO_MX_AMT_OF_PY_NUM_FLAG
, MTR.ACTY_BASE_RT_ID
, MTR.COMP_LVL_FCTR_ID
, MTR.BUSINESS_GROUP_ID
, MTR.MTR_ATTRIBUTE_CATEGORY
, MTR.MTR_ATTRIBUTE1
, MTR.MTR_ATTRIBUTE2
, MTR.MTR_ATTRIBUTE3
, MTR.MTR_ATTRIBUTE4
, MTR.MTR_ATTRIBUTE5
, MTR.MTR_ATTRIBUTE6
, MTR.MTR_ATTRIBUTE7
, MTR.MTR_ATTRIBUTE8
, MTR.MTR_ATTRIBUTE9
, MTR.MTR_ATTRIBUTE10
, MTR.MTR_ATTRIBUTE11
, MTR.MTR_ATTRIBUTE12
, MTR.MTR_ATTRIBUTE13
, MTR.MTR_ATTRIBUTE14
, MTR.MTR_ATTRIBUTE15
, MTR.MTR_ATTRIBUTE16
, MTR.MTR_ATTRIBUTE17
, MTR.MTR_ATTRIBUTE18
, MTR.MTR_ATTRIBUTE19
, MTR.MTR_ATTRIBUTE20
, MTR.MTR_ATTRIBUTE21
, MTR.MTR_ATTRIBUTE22
, MTR.MTR_ATTRIBUTE23
, MTR.MTR_ATTRIBUTE24
, MTR.MTR_ATTRIBUTE25
, MTR.MTR_ATTRIBUTE26
, MTR.MTR_ATTRIBUTE27
, MTR.MTR_ATTRIBUTE28
, MTR.MTR_ATTRIBUTE29
, MTR.MTR_ATTRIBUTE30
, MTR.LAST_UPDATE_DATE
, MTR.LAST_UPDATED_BY
, MTR.LAST_UPDATE_LOGIN
, MTR.CREATED_BY
, MTR.CREATION_DATE
, MTR.OBJECT_VERSION_NUMBER
FROM BEN_MTCHG_RT_F MTR
WHERE MTR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND MTR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))