APPS.PQH_LCD_BUS dependencies on PQH_DE_LEVEL_NUMBERS

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 271: l_LEVEL_NUMBER_ID PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID%TYPE;

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:
271: l_LEVEL_NUMBER_ID PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID%TYPE;
272:
273: Begin
274: hr_utility.set_location(l_proc, 10);
275: Open c_LEVEL_NUMBER_ID;

Line 286: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID'

282: Close c_LEVEL_NUMBER_ID;
283: Exception
284: when app_exception.application_exception then
285: if hr_multi_message.exception_add
286: (p_associated_column1 => 'PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID'
287: ) then
288: hr_utility.set_location(' Leaving:'||l_proc,60);
289: raise;
290: end if;