VIEW: APPS.BEN_DPNT_CVRD_OTHR_PTIP_RT_D

Source

View Text - Preformatted

SELECT dco.dpnt_cvrd_othr_ptip_rt_id, dco.effective_start_date, dco.effective_end_date, hr_general.decode_lookup ('YES_NO',dco.excld_flag), dco.ordr_num, hr_general.decode_lookup ('BEN_ENRL_DET_DT', dco.enrl_det_dt_cd), dco.only_pls_subj_cobra_flag, dco.ptip_id, vpf.NAME, dco.last_update_date, fuser.user_name FROM ben_dpnt_cvrd_othr_ptip_rt_f dco, fnd_user fuser, ben_vrbl_rt_prfl_f vpf WHERE fuser.user_id(+) = dco.last_updated_by AND dco.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id(+) AND dco.effective_start_date BETWEEN vpf.effective_start_date(+) AND vpf.effective_end_date(+)

View Text - HTML Formatted

SELECT DCO.DPNT_CVRD_OTHR_PTIP_RT_ID
, DCO.EFFECTIVE_START_DATE
, DCO.EFFECTIVE_END_DATE
, HR_GENERAL.DECODE_LOOKUP ('YES_NO'
, DCO.EXCLD_FLAG)
, DCO.ORDR_NUM
, HR_GENERAL.DECODE_LOOKUP ('BEN_ENRL_DET_DT'
, DCO.ENRL_DET_DT_CD)
, DCO.ONLY_PLS_SUBJ_COBRA_FLAG
, DCO.PTIP_ID
, VPF.NAME
, DCO.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_DPNT_CVRD_OTHR_PTIP_RT_F DCO
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VPF
WHERE FUSER.USER_ID(+) = DCO.LAST_UPDATED_BY
AND DCO.VRBL_RT_PRFL_ID = VPF.VRBL_RT_PRFL_ID(+)
AND DCO.EFFECTIVE_START_DATE BETWEEN VPF.EFFECTIVE_START_DATE(+)
AND VPF.EFFECTIVE_END_DATE(+)