Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_VRBL_MTCHG_RT_D |
SELECT VMR.ROWID ROW_ID
, VMR.VRBL_MTCHG_RT_ID
, VMR.EFFECTIVE_END_DATE
, VMR.EFFECTIVE_START_DATE
, NO_MX_PCT_OF_PY_NUM.MEANING
, VMR.TO_PCT_VAL
, NO_MX_AMT_OF_PY_NUM.MEANING
, VMR.MX_PCT_OF_PY_NUM
, NO_MX_MTCH_AMT.MEANING
, VMR.ORDR_NUM
, VMR.PCT_VAL
, VMR.MX_MTCH_AMT
, VMR.MX_AMT_OF_PY_NUM
, VMR.MN_MTCH_AMT
, MTCHG_RT_CALC.FORMULA_NAME
, CNTNU_MTCH_AFTR_MAX_RL.MEANING
, VMR.FROM_PCT_VAL
, VRBL_RT_PRFL.NAME
, VMR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_VRBL_MTCHG_RT_F VMR
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL
, HR_LOOKUPS NO_MX_PCT_OF_PY_NUM
, HR_LOOKUPS NO_MX_AMT_OF_PY_NUM
, HR_LOOKUPS NO_MX_MTCH_AMT
, FF_FORMULAS_F MTCHG_RT_CALC
, HR_LOOKUPS CNTNU_MTCH_AFTR_MAX_RL
WHERE FUSER.USER_ID (+)= VMR.LAST_UPDATED_BY
AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= VMR.VRBL_RT_PRFL_ID
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_CODE (+)= VMR.NO_MX_PCT_OF_PY_NUM_FLAG
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_CODE (+)= VMR.NO_MX_AMT_OF_PY_NUM_FLAG
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_MTCH_AMT.LOOKUP_CODE (+)= VMR.NO_MX_MTCH_AMT_FLAG
AND NO_MX_MTCH_AMT.LOOKUP_TYPE (+)= 'YES_NO'
AND CNTNU_MTCH_AFTR_MAX_RL.LOOKUP_CODE (+)= VMR.CNTNU_MTCH_AFTR_MAX_RL_FLAG
AND CNTNU_MTCH_AFTR_MAX_RL.LOOKUP_TYPE (+)= 'YES_NO'
AND MTCHG_RT_CALC.FORMULA_ID (+)= VMR.MTCHG_RT_CALC_RL