26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: where pbg.business_group_id =
32: (select distinct asg.business_group_id
33: from irc_assignment_details_f iad
34: , per_all_assignments_f asg
99: -- Declare cursor
100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: where pbg.business_group_id =
105: (select distinct asg.business_group_id
106: from irc_assignment_details_f iad
107: , per_all_assignments_f asg