VIEW: APPS.BEN_ACTL_PREM_VRBL_RT_RL_D

Source

View Text - Preformatted

SELECT ava.ROWID, ava.actl_prem_vrbl_rt_rl_id, ava.effective_start_date, ava.effective_end_date, actl_prem.NAME, vrbl_rl.formula_name, ava.ordr_to_aply_num, hr_general.decode_lookup ('BEN_RT_TRTMT', ava.rt_trtmt_cd), ava.last_update_date, fuser.user_name FROM ben_actl_prem_vrbl_rt_rl_f ava, fnd_user fuser, ff_formulas_f vrbl_rl, ben_actl_prem_f actl_prem WHERE fuser.user_id(+) = ava.last_updated_by AND vrbl_rl.formula_id(+) = ava.formula_id AND ava.effective_start_date BETWEEN vrbl_rl.effective_start_date(+) AND vrbl_rl.effective_end_date(+) AND actl_prem.actl_prem_id(+) = ava.actl_prem_id AND ava.effective_start_date BETWEEN actl_prem.effective_start_date(+) AND actl_prem.effective_end_date(+)

View Text - HTML Formatted

SELECT AVA.ROWID
, AVA.ACTL_PREM_VRBL_RT_RL_ID
, AVA.EFFECTIVE_START_DATE
, AVA.EFFECTIVE_END_DATE
, ACTL_PREM.NAME
, VRBL_RL.FORMULA_NAME
, AVA.ORDR_TO_APLY_NUM
, HR_GENERAL.DECODE_LOOKUP ('BEN_RT_TRTMT'
, AVA.RT_TRTMT_CD)
, AVA.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ACTL_PREM_VRBL_RT_RL_F AVA
, FND_USER FUSER
, FF_FORMULAS_F VRBL_RL
, BEN_ACTL_PREM_F ACTL_PREM
WHERE FUSER.USER_ID(+) = AVA.LAST_UPDATED_BY
AND VRBL_RL.FORMULA_ID(+) = AVA.FORMULA_ID
AND AVA.EFFECTIVE_START_DATE BETWEEN VRBL_RL.EFFECTIVE_START_DATE(+)
AND VRBL_RL.EFFECTIVE_END_DATE(+)
AND ACTL_PREM.ACTL_PREM_ID(+) = AVA.ACTL_PREM_ID
AND AVA.EFFECTIVE_START_DATE BETWEEN ACTL_PREM.EFFECTIVE_START_DATE(+)
AND ACTL_PREM.EFFECTIVE_END_DATE(+)