VIEW: APPS.BEN_PYRL_RT_D

Source

View Text - Preformatted

SELECT PYR.PYRL_RT_ID , PYR.EFFECTIVE_START_DATE , PYR.EFFECTIVE_END_DATE , PYR.VRBL_RT_PRFL_ID , PYR.PAYROLL_ID , PYR.ORDR_NUM , PYR.EXCLD_FLAG , PYR.LAST_UPDATE_DATE , fuser.user_name FROM BEN_PYRL_RT_F PYR, fnd_user fuser WHERE fuser.user_id(+) = pyr.last_updated_by

View Text - HTML Formatted

SELECT PYR.PYRL_RT_ID
, PYR.EFFECTIVE_START_DATE
, PYR.EFFECTIVE_END_DATE
, PYR.VRBL_RT_PRFL_ID
, PYR.PAYROLL_ID
, PYR.ORDR_NUM
, PYR.EXCLD_FLAG
, PYR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PYRL_RT_F PYR
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = PYR.LAST_UPDATED_BY