View: BEN_LER_RLTD_PER_CS_LER_D

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

View Text

SELECT LRC.ROWID ROW_ID
, LRC.LER_RLTD_PER_CS_LER_ID
, LRC.EFFECTIVE_START_DATE
, LRC.EFFECTIVE_END_DATE
, LER_RLTD_PER_CS_CHG.FORMULA_NAME
, LER.NAME
, RLTD_PER_CHG_CS_LER_F.NEW_VAL
, LRC.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_LER_RLTD_PER_CS_LER_F LRC
, FND_USER FUSER
, BEN_LER_F LER
, BEN_RLTD_PER_CHG_CS_LER_F RLTD_PER_CHG_CS_LER_F
, FF_FORMULAS_F LER_RLTD_PER_CS_CHG
WHERE FUSER.USER_ID (+)= LRC.LAST_UPDATED_BY
AND LER.LER_ID (+)= LRC.LER_ID
AND RLTD_PER_CHG_CS_LER_F.RLTD_PER_CHG_CS_LER_ID (+)= LRC.RLTD_PER_CHG_CS_LER_ID
AND LER_RLTD_PER_CS_CHG.FORMULA_ID (+)= LRC.LER_RLTD_PER_CS_CHG_RL
AND LRC.EFFECTIVE_START_DATE BETWEEN LER_RLTD_PER_CS_CHG.EFFECTIVE_START_DATE(+)
AND LER_RLTD_PER_CS_CHG.EFFECTIVE_END_DATE(+)
AND LRC.EFFECTIVE_START_DATE BETWEEN RLTD_PER_CHG_CS_LER_F .EFFECTIVE_START_DATE(+)
AND RLTD_PER_CHG_CS_LER_F.EFFECTIVE_END_DATE(+)
AND LRC.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)

Columns