APPS.PER_RSL_BUS dependencies on PER_BUSINESS_GROUPS

Line 35: -- per_rating_scales_tl and PER_BUSINESS_GROUPS

31: -- Name : M. Burton
32: -- Date 02-DEC-2002
33: -- Description Amended to add MLS functionality
34: -- In the following cursor statement add join(s) between
35: -- per_rating_scales_tl and PER_BUSINESS_GROUPS
36: -- so that the security_group_id for
37: -- the current business group context can be derived.
38: cursor csr_sec_grp is
39: select pbg.security_group_id

Line 40: from per_business_groups pbg

36: -- so that the security_group_id for
37: -- the current business group context can be derived.
38: cursor csr_sec_grp is
39: select pbg.security_group_id
40: from per_business_groups pbg
41: , per_rating_scales_tl rsl_tl
42: , per_rating_scales rsl
43: where rsl.rating_scale_id = p_rating_scale_id
44: and rsl.rating_scale_id = rsl_tl.rating_scale_id

Line 109: -- per_rating_scales_tl and PER_BUSINESS_GROUPS

105: -- Date 29-NOV-2002
106: -- Declare cursor
107: --
108: -- In the following cursor statement add join(s) between
109: -- per_rating_scales_tl and PER_BUSINESS_GROUPS
110: -- so that the legislation_code for
111: -- the current business group context can be derived.
112:
113: cursor csr_leg_code is

Line 115: from per_business_groups pbg

111: -- the current business group context can be derived.
112:
113: cursor csr_leg_code is
114: select pbg.legislation_code
115: from per_business_groups pbg
116: , per_rating_scales_tl rsl_tl
117: , per_rating_scales rsl
118: where
119: rsl.rating_scale_id = p_rating_scale_id