136: --
137: l_proc VARCHAR2(72) ;
138: l_legislation_code per_business_groups.legislation_code%type;
139: cursor check_legislation
140: (p_person_id per_people_f.person_id%TYPE,
141: p_effective_date date
142: ) IS
143: select business_group_id
144: from per_people_f
140: (p_person_id per_people_f.person_id%TYPE,
141: p_effective_date date
142: ) IS
143: select business_group_id
144: from per_people_f
145: where person_id = p_person_id
146: and p_effective_date
147: between effective_start_date and effective_end_date;
148: