VIEW: APPS.BEN_ACTL_PREM_VRBL_RT_D

Source

View Text - Preformatted

SELECT apv.ROWID row_id, apv.actl_prem_vrbl_rt_id, apv.effective_start_date, apv.effective_end_date, actl_prem.NAME, vrbl_rt_prfl.NAME, apv.last_update_date, fuser.user_name, apv.ordr_num FROM ben_actl_prem_vrbl_rt_f apv, fnd_user fuser, ben_actl_prem_f actl_prem, ben_vrbl_rt_prfl_f vrbl_rt_prfl WHERE fuser.user_id(+) = apv.last_updated_by AND actl_prem.actl_prem_id(+) = apv.actl_prem_id AND vrbl_rt_prfl.vrbl_rt_prfl_id(+) = apv.vrbl_rt_prfl_id AND apv.effective_start_date BETWEEN actl_prem.effective_start_date(+) AND actl_prem.effective_end_date(+) AND apv.effective_start_date BETWEEN vrbl_rt_prfl.effective_start_date(+) AND vrbl_rt_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT APV.ROWID ROW_ID
, APV.ACTL_PREM_VRBL_RT_ID
, APV.EFFECTIVE_START_DATE
, APV.EFFECTIVE_END_DATE
, ACTL_PREM.NAME
, VRBL_RT_PRFL.NAME
, APV.LAST_UPDATE_DATE
, FUSER.USER_NAME
, APV.ORDR_NUM
FROM BEN_ACTL_PREM_VRBL_RT_F APV
, FND_USER FUSER
, BEN_ACTL_PREM_F ACTL_PREM
, BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL
WHERE FUSER.USER_ID(+) = APV.LAST_UPDATED_BY
AND ACTL_PREM.ACTL_PREM_ID(+) = APV.ACTL_PREM_ID
AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID(+) = APV.VRBL_RT_PRFL_ID
AND APV.EFFECTIVE_START_DATE BETWEEN ACTL_PREM.EFFECTIVE_START_DATE(+)
AND ACTL_PREM.EFFECTIVE_END_DATE(+)
AND APV.EFFECTIVE_START_DATE BETWEEN VRBL_RT_PRFL.EFFECTIVE_START_DATE(+)
AND VRBL_RT_PRFL.EFFECTIVE_END_DATE(+)