35: -- MB amended 16-Dec-2002
36:
37: cursor csr_sec_grp is
38: select pbg.security_group_id
39: from per_business_groups pbg
40: , per_rating_levels rt
41: , per_rating_levels_tl rtx
42: where rt.rating_level_id = p_rating_level_id
43: and rt.rating_level_id = rtx.rating_level_id
106: -- MB amedned on 16-Dec-2002
107: --
108: cursor csr_leg_code is
109: select pbg.legislation_code
110: from per_business_groups pbg
111: , per_rating_levels rt
112: , per_rating_levels_tl rtx
113: where rt.rating_level_id = p_rating_level_id
114: and rt.rating_level_id = rtx.rating_level_id