301: --
302: update ben_cm_typ_f_tl t
303: set t.effective_end_date = p_new_effective_end_date,
304: t.last_update_date = sysdate,
305: t.last_updated_by = fnd_global.user_id,
306: t.last_update_login = fnd_global.login_id
307: where t.cm_typ_id = p_base_key_value
308: and p_effective_date
309: between t.effective_start_date and t.effective_end_date;
302: update ben_cm_typ_f_tl t
303: set t.effective_end_date = p_new_effective_end_date,
304: t.last_update_date = sysdate,
305: t.last_updated_by = fnd_global.user_id,
306: t.last_update_login = fnd_global.login_id
307: where t.cm_typ_id = p_base_key_value
308: and p_effective_date
309: between t.effective_start_date and t.effective_end_date;
310: --