VIEW: APPS.BEN_BNFT_VRBL_RT_RL_D

Source

View Text - Preformatted

SELECT brr.ROWID, brr.bnft_vrbl_rt_rl_id, brr.effective_start_date, brr.effective_end_date, brr.ordr_to_aply_num, ccm.NAME, vrbl_rl.formula_name, brr.last_update_date, fuser.user_name FROM ben_bnft_vrbl_rt_rl_f brr, fnd_user fuser, ff_formulas_f vrbl_rl, ben_cvg_amt_calc_mthd_f ccm WHERE fuser.user_id(+) = brr.last_updated_by AND vrbl_rl.formula_id(+) = brr.formula_id AND brr.effective_start_date BETWEEN vrbl_rl.effective_start_date(+) AND vrbl_rl.effective_end_date(+) AND brr.cvg_amt_calc_mthd_id = ccm.cvg_amt_calc_mthd_id(+) AND brr.effective_start_date BETWEEN ccm.effective_start_date(+) AND ccm.effective_end_date(+)

View Text - HTML Formatted

SELECT BRR.ROWID
, BRR.BNFT_VRBL_RT_RL_ID
, BRR.EFFECTIVE_START_DATE
, BRR.EFFECTIVE_END_DATE
, BRR.ORDR_TO_APLY_NUM
, CCM.NAME
, VRBL_RL.FORMULA_NAME
, BRR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_BNFT_VRBL_RT_RL_F BRR
, FND_USER FUSER
, FF_FORMULAS_F VRBL_RL
, BEN_CVG_AMT_CALC_MTHD_F CCM
WHERE FUSER.USER_ID(+) = BRR.LAST_UPDATED_BY
AND VRBL_RL.FORMULA_ID(+) = BRR.FORMULA_ID
AND BRR.EFFECTIVE_START_DATE BETWEEN VRBL_RL.EFFECTIVE_START_DATE(+)
AND VRBL_RL.EFFECTIVE_END_DATE(+)
AND BRR.CVG_AMT_CALC_MTHD_ID = CCM.CVG_AMT_CALC_MTHD_ID(+)
AND BRR.EFFECTIVE_START_DATE BETWEEN CCM.EFFECTIVE_START_DATE(+)
AND CCM.EFFECTIVE_END_DATE(+)