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