VIEW: APPS.BEN_LER_CHG_DPNT_CVG_D

Source

View Text - Preformatted

SELECT ldc.rowid row_id, ldc.ler_chg_dpnt_cvg_id, ldc.effective_start_date, ldc.effective_end_date, ler.name, dpnt_cvg.meaning, dpnt_cvg_stat.meaning, dpnt_cvg_end.meaning, ff1.formula_name, ff2.formula_name, ff3.formula_name, flag.meaning, ldc.last_update_date, fuser.user_name from ben_ler_chg_dpnt_cvg_f ldc, fnd_user fuser, ben_ler_f ler, hr_lookups dpnt_cvg, hr_lookups dpnt_cvg_stat, hr_lookups dpnt_cvg_end, hr_lookups flag, ben_pl_f pln, ben_pgm_f pgm, ff_formulas_f ff1, ff_formulas_f ff2, ff_formulas_f ff3 WHERE fuser.user_id(+) = ldc.last_updated_by and ler.ler_id(+)=ldc.ler_id and ldc.effective_start_date BETWEEN ler.effective_start_date(+) and ler.effective_end_date(+) and dpnt_cvg.lookup_code(+) = ldc.ler_chg_dpnt_cvg_cd and dpnt_cvg.lookup_type(+) = 'BEN_LER_CHG_DPNT_CVG' and dpnt_cvg_stat.lookup_code(+) = ldc.cvg_eff_strt_cd and dpnt_cvg_stat.lookup_type(+) = 'BEN_DPNT_CVG_STRT' and dpnt_cvg_end.lookup_code(+) = ldc.cvg_eff_end_cd and dpnt_cvg_end.lookup_type(+) = 'BEN_DPNT_CVG_END' and ff1.formula_id(+)=ldc.ler_chg_dpnt_cvg_rl and ldc.effective_start_date BETWEEN ff1.effective_start_date(+) and ff1.effective_end_date(+) and ff2.formula_id(+)=ldc.cvg_eff_strt_rl and ldc.effective_start_date BETWEEN ff2.effective_start_date(+) and ff2.effective_end_date(+) and ff3.formula_id(+)=ldc.cvg_eff_end_rl and ldc.effective_start_date BETWEEN ff3.effective_start_date(+) and ff3.effective_end_date(+) and pln.pl_id(+)=ldc.pl_id and ldc.effective_start_date BETWEEN pln.effective_start_date(+) and pln.effective_end_date(+) and pgm.pgm_id(+)=ldc.pgm_id and ldc.effective_start_date BETWEEN pgm.effective_start_date(+) and pgm.effective_end_date(+) and flag.lookup_type(+) = 'YES_NO' and flag.lookup_code(+) = ldc.susp_if_ctfn_not_prvd_flag

View Text - HTML Formatted

SELECT LDC.ROWID ROW_ID
, LDC.LER_CHG_DPNT_CVG_ID
, LDC.EFFECTIVE_START_DATE
, LDC.EFFECTIVE_END_DATE
, LER.NAME
, DPNT_CVG.MEANING
, DPNT_CVG_STAT.MEANING
, DPNT_CVG_END.MEANING
, FF1.FORMULA_NAME
, FF2.FORMULA_NAME
, FF3.FORMULA_NAME
, FLAG.MEANING
, LDC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LER_CHG_DPNT_CVG_F LDC
, FND_USER FUSER
, BEN_LER_F LER
, HR_LOOKUPS DPNT_CVG
, HR_LOOKUPS DPNT_CVG_STAT
, HR_LOOKUPS DPNT_CVG_END
, HR_LOOKUPS FLAG
, BEN_PL_F PLN
, BEN_PGM_F PGM
, FF_FORMULAS_F FF1
, FF_FORMULAS_F FF2
, FF_FORMULAS_F FF3
WHERE FUSER.USER_ID(+) = LDC.LAST_UPDATED_BY
AND LER.LER_ID(+)=LDC.LER_ID
AND LDC.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)
AND DPNT_CVG.LOOKUP_CODE(+) = LDC.LER_CHG_DPNT_CVG_CD
AND DPNT_CVG.LOOKUP_TYPE(+) = 'BEN_LER_CHG_DPNT_CVG'
AND DPNT_CVG_STAT.LOOKUP_CODE(+) = LDC.CVG_EFF_STRT_CD
AND DPNT_CVG_STAT.LOOKUP_TYPE(+) = 'BEN_DPNT_CVG_STRT'
AND DPNT_CVG_END.LOOKUP_CODE(+) = LDC.CVG_EFF_END_CD
AND DPNT_CVG_END.LOOKUP_TYPE(+) = 'BEN_DPNT_CVG_END'
AND FF1.FORMULA_ID(+)=LDC.LER_CHG_DPNT_CVG_RL
AND LDC.EFFECTIVE_START_DATE BETWEEN FF1.EFFECTIVE_START_DATE(+)
AND FF1.EFFECTIVE_END_DATE(+)
AND FF2.FORMULA_ID(+)=LDC.CVG_EFF_STRT_RL
AND LDC.EFFECTIVE_START_DATE BETWEEN FF2.EFFECTIVE_START_DATE(+)
AND FF2.EFFECTIVE_END_DATE(+)
AND FF3.FORMULA_ID(+)=LDC.CVG_EFF_END_RL
AND LDC.EFFECTIVE_START_DATE BETWEEN FF3.EFFECTIVE_START_DATE(+)
AND FF3.EFFECTIVE_END_DATE(+)
AND PLN.PL_ID(+)=LDC.PL_ID
AND LDC.EFFECTIVE_START_DATE BETWEEN PLN.EFFECTIVE_START_DATE(+)
AND PLN.EFFECTIVE_END_DATE(+)
AND PGM.PGM_ID(+)=LDC.PGM_ID
AND LDC.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+)
AND FLAG.LOOKUP_TYPE(+) = 'YES_NO'
AND FLAG.LOOKUP_CODE(+) = LDC.SUSP_IF_CTFN_NOT_PRVD_FLAG