24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups_perf pbg
29: , per_gen_hierarchy pgh
30: where pgh.hierarchy_id = p_hierarchy_id
31: and pbg.business_group_id (+) = pgh.business_group_id;
32: --
84: -- Declare cursor
85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups_perf pbg
89: , per_gen_hierarchy pgh
90: where pgh.hierarchy_id = p_hierarchy_id
91: and pbg.business_group_id (+) = pgh.business_group_id;
92: --