View: BEN_PER_TYP_RT_D

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

View Text

SELECT PTR.PER_TYP_RT_ID
, PTR.EFFECTIVE_START_DATE
, PTR.EFFECTIVE_END_DATE
, VPR.NAME
, PTR.PER_TYP_CD
, PTR.EXCLD_FLAG
, PTR.ORDR_NUM
, PTR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PER_TYP_RT_F PTR
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VPR
WHERE FUSER.USER_ID (+) = PTR.LAST_UPDATED_BY
AND PTR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID

Columns