950: select legislation_code
951: from per_business_groups
952: where business_group_id in
953: (select business_group_id
954: from per_all_people_f
955: where person_id in
956: (select person_id
957: from per_all_assignments_f
958: where assignment_id = cp_assignment_id));