APPS.PER_SLT_BUS dependencies on PER_SOLUTION_TYPES

Line 28: -- per_solution_types and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- per_solution_types 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_solution_types slt

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_solution_types slt
36: -- , EDIT_HERE table_name(s) 333
37: where slt.solution_type_name = p_solution_type_name;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 98: -- per_solution_types and PER_BUSINESS_GROUPS

94: --
95: -- Declare cursor
96: --
97: -- EDIT_HERE In the following cursor statement add join(s) between
98: -- per_solution_types 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_solution_types slt

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_solution_types slt
106: -- , EDIT_HERE table_name(s) 333
107: where slt.solution_type_name = p_solution_type_name;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --

Line 203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE

199: -- Access Status:
200: -- Internal Table Handler Use Only.
201: --
202: procedure chk_solution_category
203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
204: ,p_solution_category in per_solution_types.solution_category%TYPE
205: ,p_effective_date in date
206: ,p_object_version_number in per_solution_types.object_version_number%TYPE
207: )

Line 204: ,p_solution_category in per_solution_types.solution_category%TYPE

200: -- Internal Table Handler Use Only.
201: --
202: procedure chk_solution_category
203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
204: ,p_solution_category in per_solution_types.solution_category%TYPE
205: ,p_effective_date in date
206: ,p_object_version_number in per_solution_types.object_version_number%TYPE
207: )
208: is

Line 206: ,p_object_version_number in per_solution_types.object_version_number%TYPE

202: procedure chk_solution_category
203: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
204: ,p_solution_category in per_solution_types.solution_category%TYPE
205: ,p_effective_date in date
206: ,p_object_version_number in per_solution_types.object_version_number%TYPE
207: )
208: is
209: --
210: l_exists varchar2(1);

Line 304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE

300: -- Access Status:
301: -- Internal Table Handler Use Only.
302: --
303: procedure chk_updateable
304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
305: ,p_updateable in per_solution_types.updateable%TYPE
306: ,p_effective_date in date
307: ,p_object_version_number in per_solution_types.object_version_number%TYPE
308: )

Line 305: ,p_updateable in per_solution_types.updateable%TYPE

301: -- Internal Table Handler Use Only.
302: --
303: procedure chk_updateable
304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
305: ,p_updateable in per_solution_types.updateable%TYPE
306: ,p_effective_date in date
307: ,p_object_version_number in per_solution_types.object_version_number%TYPE
308: )
309: is

Line 307: ,p_object_version_number in per_solution_types.object_version_number%TYPE

303: procedure chk_updateable
304: (p_solution_type_name in per_solution_types.solution_type_name%TYPE
305: ,p_updateable in per_solution_types.updateable%TYPE
306: ,p_effective_date in date
307: ,p_object_version_number in per_solution_types.object_version_number%TYPE
308: )
309: is
310: --
311: l_exists varchar2(1);