VIEW: APPS.BEN_DPNT_OTHR_PTIP_RT_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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