204: cursor csr_per is
205: select per.person_id,
206: per.employee_number,
207: per.business_group_id 208: from per_all_people_f per 209: where per.person_id = p_person_id
210: and p_effective_date between per.effective_start_date and per.effective_end_date;
211: --
212: -- Declare local variables