794: -- use to change the session date
795: --
796: cursor get_dates is
797: select min(effective_start_date), max(effective_end_date) 798: from per_people_f 799: where person_id = p_person_id;
800: begin
801: open get_dates;
802: fetch get_dates into p_min_start, p_max_end;