APPS.PQH_RSS_BUS dependencies on PQH_DE_RESULT_SETS

Line 28: -- pqh_de_result_sets and PER_BUSINESS_GROUPS

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

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_result_sets rss
36: -- , EDIT_HERE table_name(s) 333
37: where rss.result_set_id = p_result_set_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 98: -- pqh_de_result_sets and PER_BUSINESS_GROUPS

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

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_result_sets rss
106: -- , EDIT_HERE table_name(s) 333
107: where rss.result_set_id = p_result_set_id;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --

Line 237: l_Grade_id PQH_DE_RESULT_SETS.Grade_id%TYPE;

233: Cursor c_Grade_id is
234: Select Grade_id
235: from per_grades
236: Where Grade_id = p_rec.Grade_id;
237: l_Grade_id PQH_DE_RESULT_SETS.Grade_id%TYPE;
238:
239: l_proc varchar2(72) := g_package || 'Check_Grade_id';
240: Begin
241: hr_utility.set_location(l_proc, 10);

Line 253: (p_associated_column1 => 'PQH_DE_RESULT_SETS.Grade_id'

249: Close c_Grade_id;
250: Exception
251: when app_exception.application_exception then
252: if hr_multi_message.exception_add
253: (p_associated_column1 => 'PQH_DE_RESULT_SETS.Grade_id'
254: ) then
255: hr_utility.set_location(' Leaving:'||l_proc,60);
256: raise;
257: end if;

Line 341: (p_associated_column1 => 'PQH_DE_RESULT_SETS.Grade_id'

337: Close c_CIVIL_SERVANTS_Grade_id;
338: Exception
339: when app_exception.application_exception then
340: if hr_multi_message.exception_add
341: (p_associated_column1 => 'PQH_DE_RESULT_SETS.Grade_id'
342: ) then
343: hr_utility.set_location(' Leaving:'||l_proc,60);
344: raise;
345: end if;

Line 357: from pqh_de_result_sets

353: (p_rec in pqh_rss_shd.g_rec_type) is
354: --
355: Cursor c_gradual_value_numbers is
356: Select '1'
357: from pqh_de_result_sets
358: Where (GRADUAL_VALUE_NUMBER_FROM = p_rec.GRADUAL_VALUE_NUMBER_FROM
359: or GRADUAL_VALUE_NUMBER_FROM = p_rec.GRADUAL_VALUE_NUMBER_to
360: or GRADUAL_VALUE_NUMBER_to = p_rec.GRADUAL_VALUE_NUMBER_FROM
361: or GRADUAL_VALUE_NUMBER_to = p_rec.GRADUAL_VALUE_NUMBER_to

Line 366: l_gradual_value_numbers PQH_DE_RESULT_SETS.GRADUAL_VALUE_NUMBER_FROM%TYPE;

362: or GRADUAL_VALUE_NUMBER_FROM between p_rec.GRADUAL_VALUE_NUMBER_FROM and p_rec.GRADUAL_VALUE_NUMBER_to
363: or GRADUAL_VALUE_NUMBER_to between p_rec.GRADUAL_VALUE_NUMBER_FROM and p_rec.GRADUAL_VALUE_NUMBER_to)
364: and result_set_id <> p_rec.result_set_id;
365:
366: l_gradual_value_numbers PQH_DE_RESULT_SETS.GRADUAL_VALUE_NUMBER_FROM%TYPE;
367:
368: l_proc varchar2(72) := g_package || 'Chk_gradual_value_numbers';
369:
370: Begin

Line 397: (p_associated_column1 => 'PQH_DE_RESULT_SETS.GRADUAL_VALUE_NUMBER_FROM'

393: Exception
394:
395: when app_exception.application_exception then
396: if hr_multi_message.exception_add
397: (p_associated_column1 => 'PQH_DE_RESULT_SETS.GRADUAL_VALUE_NUMBER_FROM'
398: ) then
399: hr_utility.set_location(' Leaving:'||l_proc,60);
400: raise;
401: end if;