26: --
27:
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_security_organizations pso
32: , per_organization_units pou
33: where pso.security_organization_id = p_security_organization_id
34: and pbg.business_group_id = pou.business_group_id
92: -- Declare cursor
93: --
94: cursor csr_leg_code is
95: select pbg.legislation_code
96: from per_business_groups pbg
97: , per_security_organizations pso
98: , per_organization_units pou
99: where pso.security_organization_id = p_security_organization_id
100: and pbg.business_group_id = pou.business_group_id