VIEW: APPS.BEN_LER_PER_INFO_CS_LER_D

Source

View Text - Preformatted

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.NAME, ler.NAME, lpl.last_update_date, fuser.user_name 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(+)

View Text - HTML Formatted

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.NAME
, LER.NAME
, LPL.LAST_UPDATE_DATE
, FUSER.USER_NAME
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(+)