APPS.PE_AEI_BUS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 26: , per_assignment_extra_info aei

22: --
23: cursor csr_sec_grp is
24: select pbg.security_group_id
25: from per_business_groups pbg
26: , per_assignment_extra_info aei
27: , per_all_assignments_f aaf
28: where aei.assignment_extra_info_id = p_assignment_extra_info_id
29: and aaf.assignment_id = aei.assignment_id
30: and pbg.business_group_id = aaf.business_group_id;

Line 88: per_assignment_extra_info aei,

84: --
85: cursor csr_leg_code is
86: select pbg.legislation_code
87: from per_business_groups pbg,
88: per_assignment_extra_info aei,
89: per_all_assignments_f aaf
90: where aei.assignment_extra_info_id = p_assignment_extra_info_id
91: and aaf.assignment_id = aei.assignment_id
92: and pbg.business_group_id = aaf.business_group_id;

Line 181: p_information_type in per_assignment_extra_info.information_type%type

177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure chk_assignment_info_type
180: (
181: p_information_type in per_assignment_extra_info.information_type%type
182: ) is
183: --
184: l_proc varchar2(72) := g_package||'chk_assignment_info_type';
185: l_flag per_assignment_info_types.active_inactive_flag%type;

Line 262: p_assignment_id in per_assignment_extra_info.assignment_id%type

258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure chk_assignment_id
261: (
262: p_assignment_id in per_assignment_extra_info.assignment_id%type
263: ) is
264: --
265: l_proc varchar2(72) := g_package||'chk_assignment_id';
266: l_dummy varchar2(1);

Line 335: (p_information_type in per_assignment_extra_info.information_type%type

331: --
332: -- {End Of Comments}
333: -- ----------------------------------------------------------------------------
334: Procedure chk_multiple_occurences_flag
335: (p_information_type in per_assignment_extra_info.information_type%type
336: ,p_assignment_id in per_assignment_extra_info.assignment_id%type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';

Line 336: ,p_assignment_id in per_assignment_extra_info.assignment_id%type

332: -- {End Of Comments}
333: -- ----------------------------------------------------------------------------
334: Procedure chk_multiple_occurences_flag
335: (p_information_type in per_assignment_extra_info.information_type%type
336: ,p_assignment_id in per_assignment_extra_info.assignment_id%type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
340: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;

Line 351: from per_assignment_extra_info

347: where information_type = code;
348: --
349: cursor c_get_row (code varchar2, id number) is
350: select 'x'
351: from per_assignment_extra_info
352: where information_type = code
353: and assignment_id = id;
354: --
355: Begin

Line 562: ,p_descflex_name => 'PER_ASSIGNMENT_EXTRA_INFO'

558: -- b) During insert.
559: --
560: hr_dflex_utility.ins_or_upd_descflex_attribs
561: (p_appl_short_name => 'PER'
562: ,p_descflex_name => 'PER_ASSIGNMENT_EXTRA_INFO'
563: ,p_attribute_category => p_rec.aei_attribute_category
564: ,p_attribute1_name => 'AEI_ATTRIBUTE1'
565: ,p_attribute1_value => p_rec.aei_attribute1
566: ,p_attribute2_name => 'AEI_ATTRIBUTE2'