View: BEN_REGN_FOR_REGY_BODY_D

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

View Text

SELECT RRB.REGN_FOR_REGY_BODY_ID
, RRB.EFFECTIVE_START_DATE
, RRB.EFFECTIVE_END_DATE
, HL1.MEANING
, RRB.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_REGN_FOR_REGY_BODY_F RRB
, HR_LOOKUPS HL1
, FND_USER FUSER
WHERE HL1.LOOKUP_CODE (+) = RRB.REGN_ADMIN_CD
AND HL1.LOOKUP_TYPE (+) = 'REGN_ADMIN'
AND FUSER.USER_ID (+) = RRB.LAST_UPDATED_BY

Columns