APPS.PQH_GVN_BUS dependencies on PQH_DE_LEVEL_NUMBERS

Line 28: -- pqh_de_level_numbers and PER_BUSINESS_GROUPS

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

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: , pqh_de_level_numbers gvn
36: -- , EDIT_HERE table_name(s) 333
37: where gvn.level_number_id = p_level_number_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 98: -- pqh_de_level_numbers and PER_BUSINESS_GROUPS

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

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: , pqh_de_level_numbers gvn
106: -- , EDIT_HERE table_name(s) 333
107: where gvn.level_number_id = p_level_number_id;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --

Line 236: from PQH_DE_LEVEL_NUMBERS

232: (p_rec in pqh_gvn_shd.g_rec_type) is
233: --
234: Cursor c_LEVEL_NUMBER is
235: Select LEVEL_NUMBER
236: from PQH_DE_LEVEL_NUMBERS
237: Where LEVEL_NUMBER = p_rec.LEVEL_NUMBER;
238:
239:
240: l_LEVEL_NUMBER PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER%TYPE;

Line 240: l_LEVEL_NUMBER PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER%TYPE;

236: from PQH_DE_LEVEL_NUMBERS
237: Where LEVEL_NUMBER = p_rec.LEVEL_NUMBER;
238:
239:
240: l_LEVEL_NUMBER PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER%TYPE;
241: l_proc varchar2(72) := g_package || 'Unique_LEVEL_NUMBER';
242:
243:
244: Begin

Line 258: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER'

254: Close c_LEVEL_NUMBER;
255: Exception
256: when app_exception.application_exception then
257: if hr_multi_message.exception_add
258: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER'
259: ) then
260: hr_utility.set_location(' Leaving:'||l_proc,60);
261: raise;
262: end if;

Line 320: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER'

316: Close Del;
317: Exception
318: when app_exception.application_exception then
319: if hr_multi_message.exception_add
320: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER'
321: ) then
322: hr_utility.set_location(' Leaving:'||l_proc,60);
323: raise;
324: end if;