APPS.PQH_REI_BUS dependencies on PQH_ROLE_EXTRA_INFO

Line 30: , pqh_role_extra_info rei

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_role_extra_info rei
31: , pqh_roles rls
32: where rei.role_extra_info_id = p_role_extra_info_id
33: and rei.role_id = rls.role_id
34: and pbg.business_group_id = rls.business_group_id;

Line 96: , pqh_role_extra_info rei

92: --
93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: , pqh_role_extra_info rei
97: , pqh_roles rls
98: where rei.role_extra_info_id = p_role_extra_info_id
99: and rei.role_id = rls.role_id
100: and pbg.business_group_id = rls.business_group_id;

Line 271: p_role_id in pqh_role_extra_info.role_id%type

267: -- ----------------------------------------------------------------------------
268:
269: Procedure chk_role_id
270: (
271: p_role_id in pqh_role_extra_info.role_id%type
272: ) is
273: --
274: l_proc varchar2(72) := g_package||'chk_role_id';
275: l_dummy varchar2(1);

Line 343: (p_information_type in pqh_role_extra_info.information_type%type

339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure chk_multiple_occurences_flag
343: (p_information_type in pqh_role_extra_info.information_type%type
344: ,p_role_id in pqh_role_extra_info.role_id%type
345: ) is
346:
347: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';

Line 344: ,p_role_id in pqh_role_extra_info.role_id%type

340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure chk_multiple_occurences_flag
343: (p_information_type in pqh_role_extra_info.information_type%type
344: ,p_role_id in pqh_role_extra_info.role_id%type
345: ) is
346:
347: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
348: l_multi_occur_flag pqh_role_info_types.multiple_occurences_flag%type;

Line 359: from pqh_role_extra_info

355: where information_type = code;
356: --
357: cursor c_get_row (code varchar2, id number) is
358: select 'x'
359: from pqh_role_extra_info
360: where information_type = code
361: and role_id = id;
362: --
363: Begin

Line 770: ,p_descflex_name => 'PQH_ROLE_EXTRA_INFO'

766: -- b) During insert.
767: --
768: hr_dflex_utility.ins_or_upd_descflex_attribs
769: (p_appl_short_name => 'PQH'
770: ,p_descflex_name => 'PQH_ROLE_EXTRA_INFO'
771: ,p_attribute_category => p_rec.attribute_category
772: ,p_attribute1_name => 'ATTRIBUTE1'
773: ,p_attribute1_value => p_rec.attribute1
774: ,p_attribute2_name => 'ATTRIBUTE2'