360: procedure term_apl_sec_statuses ( p_assignment_id in number,
361: p_effective_date in date ) is
362: begin
363: --
364: delete from per_secondary_ass_statuses
365: where assignment_id = p_assignment_id
366: and start_date > p_effective_date ;
367: --
368: update per_secondary_ass_statuses
364: delete from per_secondary_ass_statuses
365: where assignment_id = p_assignment_id
366: and start_date > p_effective_date ;
367: --
368: update per_secondary_ass_statuses
369: set end_date = p_effective_date
370: where assignment_id = p_assignment_id
371: and p_effective_date between start_date
372: and nvl(end_date,p_effective_date) ;