[Home] [Help]
View: BEN_LGL_ENTY_RT_D
View Text
SELECT LGL.LGL_ENTY_RT_ID
, LGL.EFFECTIVE_START_DATE
, LGL.EFFECTIVE_END_DATE
, VRP.NAME
, LGL.ORGANIZATION_ID
, HRU.NAME
, LGL.EXCLD_FLAG
, LGL.ORDR_NUM
, LGL.LAST_UPDATE_DATE
, LGL.LAST_UPDATED_BY
FROM BEN_LGL_ENTY_RT_F LGL
, FND_USER
, HR_ORGANIZATION_UNITS HRU
, BEN_VRBL_RT_PRFL_F VRP
WHERE FND_USER.USER_ID (+) = LGL.LAST_UPDATED_BY
AND LGL.VRBL_RT_PRFL_ID = VRP.VRBL_RT_PRFL_ID
AND LGL.ORGANIZATION_ID = HRU.ORGANIZATION_ID
Columns
Name |
LGL_ENTY_RT_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
VRBL_RT_PRFL_NAME |
ORGANIZATION_ID |
ORG_NAME |
EXCLD_FLAG |
ORDR_NUM |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |