VIEW: APPS.BEN_REGN_FOR_REGY_BODY_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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