VIEW: APPS.BEN_LGL_ENTY_RT_D

Source

View Text - Preformatted

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 AND lgl.effective_start_date between vrp.effective_start_date(+) and vrp.effective_end_date(+)

View Text - HTML Formatted

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
AND LGL.EFFECTIVE_START_DATE BETWEEN VRP.EFFECTIVE_START_DATE(+)
AND VRP.EFFECTIVE_END_DATE(+)