VIEW: APPS.BEN_LER_CHG_DPNT_CVG_CTFN_D

Source

View Text - Preformatted

SELECT lcc.rowid row_id, lcc.ler_chg_dpnt_cvg_ctfn_id, lcc.effective_start_date, lcc.effective_end_date, ctfn_typ.meaning, rlshp_typ.meaning, ff.formula_name, lcc.rqd_flag, lcc.last_update_date, fuser.user_name FROM ben_ler_chg_dpnt_cvg_ctfn_f lcc, fnd_user fuser, hr_lookups ctfn_typ, hr_lookups rlshp_typ, ff_formulas_f ff WHERE fuser.user_id(+) = lcc.last_updated_by AND ctfn_typ.lookup_code(+) = lcc.dpnt_cvg_ctfn_typ_cd AND ctfn_typ.lookup_type(+) = 'BEN_DPNT_CVG_CTFN_TYP' AND rlshp_typ.lookup_code(+) = lcc.rlshp_typ_cd AND rlshp_typ.lookup_type(+) = 'CONTACT' AND ff.formula_id(+) = lcc.ctfn_rqd_when_rl AND lcc.effective_start_date BETWEEN ff.effective_start_date(+) AND ff.effective_end_date(+)

View Text - HTML Formatted

SELECT LCC.ROWID ROW_ID
, LCC.LER_CHG_DPNT_CVG_CTFN_ID
, LCC.EFFECTIVE_START_DATE
, LCC.EFFECTIVE_END_DATE
, CTFN_TYP.MEANING
, RLSHP_TYP.MEANING
, FF.FORMULA_NAME
, LCC.RQD_FLAG
, LCC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LER_CHG_DPNT_CVG_CTFN_F LCC
, FND_USER FUSER
, HR_LOOKUPS CTFN_TYP
, HR_LOOKUPS RLSHP_TYP
, FF_FORMULAS_F FF
WHERE FUSER.USER_ID(+) = LCC.LAST_UPDATED_BY
AND CTFN_TYP.LOOKUP_CODE(+) = LCC.DPNT_CVG_CTFN_TYP_CD
AND CTFN_TYP.LOOKUP_TYPE(+) = 'BEN_DPNT_CVG_CTFN_TYP'
AND RLSHP_TYP.LOOKUP_CODE(+) = LCC.RLSHP_TYP_CD
AND RLSHP_TYP.LOOKUP_TYPE(+) = 'CONTACT'
AND FF.FORMULA_ID(+) = LCC.CTFN_RQD_WHEN_RL
AND LCC.EFFECTIVE_START_DATE BETWEEN FF.EFFECTIVE_START_DATE(+)
AND FF.EFFECTIVE_END_DATE(+)