VIEW: APPS.BEN_ACTY_BASE_RT_CTFN_D

Source

View Text - Preformatted

SELECT abc.ROWID, abc.acty_base_rt_ctfn_id, abc.effective_start_date, abc.effective_end_date, hr_general.decode_lookup ('BEN_ENRT_CTFN_TYP', abc.enrt_ctfn_typ_cd), hr_general.decode_lookup ('YES_NO', abc.rqd_flag), abr.NAME, abc.ctfn_rqd_when_rl, abc.last_update_date, fuser.user_name FROM ben_acty_base_rt_ctfn_f abc, ben_acty_base_rt_f abr, fnd_user fuser WHERE abc.acty_base_rt_id = abr.acty_base_rt_id(+) AND abc.effective_start_date BETWEEN abr.effective_start_date(+) AND abr.effective_end_date(+) AND fuser.user_id(+) = abc.last_updated_by

View Text - HTML Formatted

SELECT ABC.ROWID
, ABC.ACTY_BASE_RT_CTFN_ID
, ABC.EFFECTIVE_START_DATE
, ABC.EFFECTIVE_END_DATE
, HR_GENERAL.DECODE_LOOKUP ('BEN_ENRT_CTFN_TYP'
, ABC.ENRT_CTFN_TYP_CD)
, HR_GENERAL.DECODE_LOOKUP ('YES_NO'
, ABC.RQD_FLAG)
, ABR.NAME
, ABC.CTFN_RQD_WHEN_RL
, ABC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ACTY_BASE_RT_CTFN_F ABC
, BEN_ACTY_BASE_RT_F ABR
, FND_USER FUSER
WHERE ABC.ACTY_BASE_RT_ID = ABR.ACTY_BASE_RT_ID(+)
AND ABC.EFFECTIVE_START_DATE BETWEEN ABR.EFFECTIVE_START_DATE(+)
AND ABR.EFFECTIVE_END_DATE(+)
AND FUSER.USER_ID(+) = ABC.LAST_UPDATED_BY