VIEW: APPS.BEN_ACTY_RT_PTD_LMT_D

Source

View Text - Preformatted

SELECT apl.ROWID row_id, apl.acty_rt_ptd_lmt_id, apl.effective_start_date, apl.effective_end_date, acty_base_rt.NAME, ptd_lmt.NAME, apl.last_update_date, fuser.user_name FROM ben_acty_rt_ptd_lmt_f apl, fnd_user fuser, ben_acty_base_rt_f acty_base_rt, ben_ptd_lmt_f ptd_lmt WHERE fuser.user_id(+) = apl.last_updated_by AND acty_base_rt.acty_base_rt_id(+) = apl.acty_base_rt_id AND ptd_lmt.ptd_lmt_id(+) = apl.ptd_lmt_id AND apl.effective_start_date BETWEEN acty_base_rt.effective_start_date(+) AND acty_base_rt.effective_end_date(+) AND apl.effective_start_date BETWEEN ptd_lmt.effective_start_date(+) AND ptd_lmt.effective_end_date(+)

View Text - HTML Formatted

SELECT APL.ROWID ROW_ID
, APL.ACTY_RT_PTD_LMT_ID
, APL.EFFECTIVE_START_DATE
, APL.EFFECTIVE_END_DATE
, ACTY_BASE_RT.NAME
, PTD_LMT.NAME
, APL.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ACTY_RT_PTD_LMT_F APL
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_PTD_LMT_F PTD_LMT
WHERE FUSER.USER_ID(+) = APL.LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID(+) = APL.ACTY_BASE_RT_ID
AND PTD_LMT.PTD_LMT_ID(+) = APL.PTD_LMT_ID
AND APL.EFFECTIVE_START_DATE BETWEEN ACTY_BASE_RT.EFFECTIVE_START_DATE(+)
AND ACTY_BASE_RT.EFFECTIVE_END_DATE(+)
AND APL.EFFECTIVE_START_DATE BETWEEN PTD_LMT.EFFECTIVE_START_DATE(+)
AND PTD_LMT.EFFECTIVE_END_DATE(+)