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
35: and pou.organization_id = pso.organization_id;
36: --
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
101: and pou.organization_id = pso.organization_id;
102: