APPS.PER_SOL_BUS dependencies on PER_SOLUTIONS

Line 28: -- per_solutions and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- per_solutions and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 35: , per_solutions sol

31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , per_solutions sol
36: -- , EDIT_HERE table_name(s) 333
37: where sol.solution_id = p_solution_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 98: -- per_solutions and PER_BUSINESS_GROUPS

94: --
95: -- Declare cursor
96: --
97: -- EDIT_HERE In the following cursor statement add join(s) between
98: -- per_solutions and PER_BUSINESS_GROUPS
99: -- so that the legislation_code for
100: -- the current business group context can be derived.
101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is

Line 105: , per_solutions sol

101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups pbg
105: , per_solutions sol
106: -- , EDIT_HERE table_name(s) 333
107: where sol.solution_id = p_solution_id;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --

Line 257: (p_solution_id in per_solutions.solution_id%TYPE

253: -- Access Status:
254: -- Internal Table Handler Use Only.
255: --
256: procedure chk_vertical
257: (p_solution_id in per_solutions.solution_id%TYPE
258: ,p_vertical in per_solutions.vertical%TYPE
259: ,p_effective_date in date
260: ,p_object_version_number in per_solutions.object_version_number%TYPE
261: )

Line 258: ,p_vertical in per_solutions.vertical%TYPE

254: -- Internal Table Handler Use Only.
255: --
256: procedure chk_vertical
257: (p_solution_id in per_solutions.solution_id%TYPE
258: ,p_vertical in per_solutions.vertical%TYPE
259: ,p_effective_date in date
260: ,p_object_version_number in per_solutions.object_version_number%TYPE
261: )
262: is

Line 260: ,p_object_version_number in per_solutions.object_version_number%TYPE

256: procedure chk_vertical
257: (p_solution_id in per_solutions.solution_id%TYPE
258: ,p_vertical in per_solutions.vertical%TYPE
259: ,p_effective_date in date
260: ,p_object_version_number in per_solutions.object_version_number%TYPE
261: )
262: is
263: --
264: l_exists varchar2(1);