58: --
59: cursor csr_person_details (c_person_id in number,
60: c_effective_date in date) is
61: select per_information10 62: from per_all_people_f 63: where person_id = c_person_id
64: and c_effective_date between
65: effective_start_date and effective_end_date;
66: --