24: cursor c_get_person(p_assignment_id in number
25: ,p_effective_date in date)
26: is
27: select a.person_id 28: from per_all_people_f a, 29: per_all_assignments_f asg
30: where a.person_id = asg.person_id
31: and asg.assignment_id = p_assignment_id
32: and asg.business_group_id = a.business_group_id