139: l_legislation_code per_business_groups.legislation_code%type;
140: l_discard_varchar2 varchar2(30);
141: --
142: cursor check_legislation
143: (c_person_id per_people_f.person_id%TYPE,
144: c_effective_date date
145: )
146: is
147: select bgp.legislation_code
144: c_effective_date date
145: )
146: is
147: select bgp.legislation_code
148: from per_people_f per,
149: per_business_groups bgp
150: where per.business_group_id = bgp.business_group_id
151: and per.person_id = c_person_id
152: and c_effective_date