APPS.PQH_LCD_BUS dependencies on PQH_DE_LEVEL_CODES

Line 28: -- pqh_de_level_codes 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_codes 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_codes lcd

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_codes lcd
36: -- , EDIT_HERE table_name(s) 333
37: where lcd.level_code_id = p_level_code_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 98: -- pqh_de_level_codes 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_codes 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_codes lcd

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_codes lcd
106: -- , EDIT_HERE table_name(s) 333
107: where lcd.level_code_id = p_level_code_id;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --

Line 266: select '1' from PQH_DE_LEVEL_NUMBERS a, PQH_DE_LEVEL_codes b

262: Procedure Chk_LEVEL_NUMBER_ID
263: (p_rec in pqh_lcd_shd.g_rec_type) is
264: l_proc varchar2(72) := g_package||'Ckh_LEVEL_NUMBER_ID';
265: Cursor c_LEVEL_NUMBER_ID is
266: select '1' from PQH_DE_LEVEL_NUMBERS a, PQH_DE_LEVEL_codes b
267: where a.LEVEL_NUMBER_ID = p_rec.LEVEL_NUMBER_ID
268: and a.LEVEL_NUMBER_ID = b.LEVEL_NUMBER_ID
269: and b.LEVEL_CODE = p_rec.level_code;
270:

Line 302: from PQH_DE_Level_Codes

298: (p_rec in pqh_lcd_shd.g_rec_type) is
299: --
300: Cursor c_Level_Code is
301: Select Level_Code
302: from PQH_DE_Level_Codes
303: Where Level_Code = p_rec.Level_Code;
304: l_Level_Code PQH_DE_Level_Codes.Level_Code%TYPE;
305: l_proc varchar2(72) := g_package || 'Unique_Level_Code';
306: Begin

Line 304: l_Level_Code PQH_DE_Level_Codes.Level_Code%TYPE;

300: Cursor c_Level_Code is
301: Select Level_Code
302: from PQH_DE_Level_Codes
303: Where Level_Code = p_rec.Level_Code;
304: l_Level_Code PQH_DE_Level_Codes.Level_Code%TYPE;
305: l_proc varchar2(72) := g_package || 'Unique_Level_Code';
306: Begin
307: hr_utility.set_location(l_proc, 10);
308: Open c_Level_Code;

Line 319: (p_associated_column1 => 'PQH_DE_Level_Codes.Level_Code'

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