View: BEN_MTCHG_RT_D

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

View Text

SELECT MTR.ROWID ROW_ID
, 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
, MTCHG_RT_CALC.FORMULA_NAME
, NO_MX_MTCH_AMT.MEANING
, NO_MX_PCT_OF_PY_NUM.MEANING
, CNTNU_MTCH_AFTR_MX_RL.MEANING
, NO_MX_AMT_OF_PY_NUM.MEANING
, ACTY_BASE_RT.NAME
, COMP_LVL_FCTR.NAME
, MTR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_MTCHG_RT_F MTR
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_COMP_LVL_FCTR COMP_LVL_FCTR
, HR_LOOKUPS NO_MX_MTCH_AMT
, HR_LOOKUPS NO_MX_PCT_OF_PY_NUM
, HR_LOOKUPS NO_MX_AMT_OF_PY_NUM
, FF_FORMULAS_F MTCHG_RT_CALC
, HR_LOOKUPS CNTNU_MTCH_AFTR_MX_RL
WHERE FUSER.USER_ID (+)= MTR .LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= MTR .ACTY_BASE_RT_ID
AND MTR.EFFECTIVE_START_DATE BETWEEN ACTY_BASE_RT.EFFECTIVE_START_DATE
AND ACTY_BASE_RT.EFFECTIVE_END_DATE
AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= MTR .COMP_LVL_FCTR_ID
AND NO_MX_MTCH_AMT.LOOKUP_CODE (+)= MTR .NO_MX_MTCH_AMT_FLAG
AND NO_MX_MTCH_AMT.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_CODE (+)= MTR .NO_MX_PCT_OF_PY_NUM_FLAG
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND CNTNU_MTCH_AFTR_MX_RL.LOOKUP_CODE (+)= MTR .CNTNU_MTCH_AFTR_MX_RL_FLAG
AND CNTNU_MTCH_AFTR_MX_RL.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_CODE (+)= MTR .NO_MX_AMT_OF_PY_NUM_FLAG
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND MTCHG_RT_CALC.FORMULA_ID (+)= MTR .MTCHG_RT_CALC_RL
AND MTR .EFFECTIVE_START_DATE BETWEEN MTCHG_RT_CALC.EFFECTIVE_START_DATE (+)
AND MTCHG_RT_CALC.EFFECTIVE_END_DATE (+)

Columns