567: and pen.effective_end_date;
568:
569: cursor c_dob(p_person_id number) is
570: select trunc(date_of_birth), sex 571: from per_all_people_f 572: where person_id = p_person_id
573: and p_effective_date between effective_start_date
574: and effective_end_date;
575: