1288: end if;
1289: --
1290: if p_actual_termination_date is not null and
1291: p_leaving_reason = 'D' then
1292: update per_people_f
1293: set date_of_death = p_actual_termination_date
1294: where person_id = p_person_id
1295: and effective_start_date >= p_actual_termination_date +1
1296: and date_of_death is null;