APPS.PER_SOS_BUS dependencies on PER_BUSINESS_GROUPS

Line 34: -- per_solutions_selected and PER_BUSINESS_GROUPS

30: --
31: -- Declare cursor
32: --
33: -- EDIT_HERE In the following cursor statement add join(s) between
34: -- per_solutions_selected and PER_BUSINESS_GROUPS
35: -- so that the security_group_id for
36: -- the current business group context can be derived.
37: -- Remove this comment when the edit has been completed.
38: cursor csr_sec_grp is

Line 40: from per_business_groups pbg

36: -- the current business group context can be derived.
37: -- Remove this comment when the edit has been completed.
38: cursor csr_sec_grp is
39: select pbg.security_group_id
40: from per_business_groups pbg
41: , per_solutions_selected sos
42: -- , EDIT_HERE table_name(s) 333
43: where sos.solution_id = p_solution_id
44: and sos.solution_set_name = p_solution_set_name

Line 122: -- per_solutions_selected and PER_BUSINESS_GROUPS

118: --
119: -- Declare cursor
120: --
121: -- EDIT_HERE In the following cursor statement add join(s) between
122: -- per_solutions_selected and PER_BUSINESS_GROUPS
123: -- so that the legislation_code for
124: -- the current business group context can be derived.
125: -- Remove this comment when the edit has been completed.
126: cursor csr_leg_code is

Line 128: from per_business_groups pbg

124: -- the current business group context can be derived.
125: -- Remove this comment when the edit has been completed.
126: cursor csr_leg_code is
127: select pbg.legislation_code
128: from per_business_groups pbg
129: , per_solutions_selected sos
130: -- , EDIT_HERE table_name(s) 333
131: where sos.solution_id = p_solution_id
132: and sos.solution_set_name = p_solution_set_name