View: BEN_DPNT_OTHR_PTIP_RT_D

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

View Text

SELECT DOT.DPNT_OTHR_PTIP_RT_ID
, DOT.EFFECTIVE_START_DATE
, DOT.EFFECTIVE_END_DATE
, DOT.EXCLD_FLAG
, DOT.ORDR_NUM
, PGM.NAME||'-'||PLTYP.NAME
, VPF.NAME
, DOT.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_DPNT_OTHR_PTIP_RT_F DOT
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VPF
, BEN_PTIP_F PTIP
, BEN_PL_TYP_F PLTYP
, BEN_PGM_F PGM
WHERE DOT.LAST_UPDATED_BY = FUSER.USER_ID (+)
AND DOT.VRBL_RT_PRFL_ID = VPF.VRBL_RT_PRFL_ID
AND DOT.PTIP_ID = PTIP.PTIP_ID
AND PTIP.PL_TYP_ID = PLTYP.PL_TYP_ID
AND PTIP.PGM_ID = PGM.PGM_ID
AND DOT.EFFECTIVE_START_DATE BETWEEN PTIP.EFFECTIVE_START_DATE
AND PTIP.EFFECTIVE_END_DATE

Columns