[Home] [Help]
View: 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
Name |
ROW_ID |
PL_REGY_PRPS_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
PL_REGY_PRPS_MEANING |
PL_REGY_BOD_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |