View: BEN_OPTIP_D

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

View Text

SELECT OTP.ROWID ROW_ID
, OTP.OPTIP_ID
, OTP.EFFECTIVE_START_DATE
, OTP.EFFECTIVE_END_DATE
, OTP.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, OTP.LEGISLATION_CODE
, OTP.LEGISLATION_SUBGROUP
FROM BEN_OPTIP_F OTP
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= OTP.LAST_UPDATED_BY

Columns