VIEW: APPS.BEN_LER_BNFT_RSTRN_CTFN_D

Source

View Text - Preformatted

SELECT lbc.rowid row_id, lbc.ler_bnft_rstrn_ctfn_id, lbc.effective_start_date, lbc.effective_end_date, lbc.rqd_flag, hr_lookups.meaning, ff.formula_name, rqd.meaning, lbc.last_update_date, fuser.user_name FROM ben_ler_bnft_rstrn_ctfn_f lbc, fnd_user fuser, ff_formulas_f ff, hr_lookups, hr_lookups rqd WHERE fuser.user_id(+) = lbc.last_updated_by and hr_lookups.lookup_code(+)=lbc.enrt_ctfn_typ_cd and hr_lookups.lookup_type(+)='BEN_ENRT_CTFN_TYP' and ff.formula_id(+)=lbc.ctfn_rqd_when_rl and rqd.lookup_code(+) = lbc.rqd_flag and rqd.lookup_type(+) = 'YES_NO' and lbc.effective_start_date BETWEEN ff.effective_start_date(+) and ff.effective_end_date(+)

View Text - HTML Formatted

SELECT LBC.ROWID ROW_ID
, LBC.LER_BNFT_RSTRN_CTFN_ID
, LBC.EFFECTIVE_START_DATE
, LBC.EFFECTIVE_END_DATE
, LBC.RQD_FLAG
, HR_LOOKUPS.MEANING
, FF.FORMULA_NAME
, RQD.MEANING
, LBC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LER_BNFT_RSTRN_CTFN_F LBC
, FND_USER FUSER
, FF_FORMULAS_F FF
, HR_LOOKUPS
, HR_LOOKUPS RQD
WHERE FUSER.USER_ID(+) = LBC.LAST_UPDATED_BY
AND HR_LOOKUPS.LOOKUP_CODE(+)=LBC.ENRT_CTFN_TYP_CD
AND HR_LOOKUPS.LOOKUP_TYPE(+)='BEN_ENRT_CTFN_TYP'
AND FF.FORMULA_ID(+)=LBC.CTFN_RQD_WHEN_RL
AND RQD.LOOKUP_CODE(+) = LBC.RQD_FLAG
AND RQD.LOOKUP_TYPE(+) = 'YES_NO'
AND LBC.EFFECTIVE_START_DATE BETWEEN FF.EFFECTIVE_START_DATE(+)
AND FF.EFFECTIVE_END_DATE(+)