View: BEN_LER_PER_INFO_CS_LER_D

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

View Text

SELECT LPL.ROWID ROW_ID
, LPL.LER_PER_INFO_CS_LER_ID
, LPL.EFFECTIVE_START_DATE
, LPL.EFFECTIVE_END_DATE
, LER_PER_INFO_CS_LER.FORMULA_NAME
, PER_INFO_CHG_CS_LER_F.NEW_VAL
, LER.NAME
, LPL.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_LER_PER_INFO_CS_LER_F LPL
, FND_USER FUSER
, BEN_PER_INFO_CHG_CS_LER_F PER_INFO_CHG_CS_LER_F
, BEN_LER_F LER
, FF_FORMULAS_F LER_PER_INFO_CS_LER
WHERE FUSER.USER_ID (+)= LPL.LAST_UPDATED_BY
AND PER_INFO_CHG_CS_LER_F.PER_INFO_CHG_CS_LER_ID (+)= LPL.PER_INFO_CHG_CS_LER_ID
AND LER.LER_ID (+)= LPL.LER_ID
AND LER_PER_INFO_CS_LER.FORMULA_ID (+)= LPL.LER_PER_INFO_CS_LER_RL
AND LPL.EFFECTIVE_START_DATE BETWEEN LER_PER_INFO_CS_LER.EFFECTIVE_START_DATE(+)
AND LER_PER_INFO_CS_LER.EFFECTIVE_END_DATE(+)
AND LPL.EFFECTIVE_START_DATE BETWEEN PER_INFO_CHG_CS_LER_F.EFFECTIVE_START_DATE(+)
AND PER_INFO_CHG_CS_LER_F.EFFECTIVE_END_DATE(+)
AND LPL.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)

Columns