152: l_legislation_code per_business_groups.legislation_code%TYPE;
153: l_discard_varchar2 VARCHAR2(30);
154: --
155: CURSOR check_legislation
156: (c_person_id per_people_f.person_id%TYPE,
157: c_effective_date DATE
158: )
159: IS
160: SELECT bgp.legislation_code
157: c_effective_date DATE
158: )
159: IS
160: SELECT bgp.legislation_code
161: FROM per_people_f per,
162: per_business_groups bgp
163: WHERE per.business_group_id = bgp.business_group_id
164: AND per.person_id = c_person_id
165: AND c_effective_date