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: , per_sp_successor_in_plan sip
32: where sip.successor_in_plan_id = p_successor_in_plan_id
33: and pbg.business_group_id = sip.business_group_id;
34: --
96: -- Declare cursor
97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_sp_successor_in_plan sip
102: where sip.successor_in_plan_id = p_successor_in_plan_id
103: and pbg.business_group_id = sip.business_group_id;
104: --