View: BEN_PL_REGY_PRP_D

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

View Text

SELECT PRP.ROWID ROW_ID
, PRP.PL_REGY_PRPS_ID
, PRP.EFFECTIVE_START_DATE
, PRP.EFFECTIVE_END_DATE
, PL_REGY_PRPS.MEANING
, PL_REGY_BOD.REGY_PL_NAME
, PRP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PL_REGY_PRP_F PRP
, FND_USER_VIEW FUSER
, BEN_PL_REGY_BOD_F PL_REGY_BOD
, HR_LOOKUPS PL_REGY_PRPS
WHERE FUSER.USER_ID (+)= PRP .LAST_UPDATED_BY
AND PL_REGY_BOD.PL_REGY_BOD_ID (+)= PRP .PL_REGY_BOD_ID
AND PL_REGY_PRPS.LOOKUP_CODE (+)= PRP .PL_REGY_PRPS_CD
AND PL_REGY_PRPS.LOOKUP_TYPE (+)= 'BEN_REGY_PRPS'

Columns