APPS.PE_AEI_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 27: , per_all_assignments_f aaf

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;
31: --

Line 89: per_all_assignments_f aaf

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;
93: --

Line 270: from per_all_assignments_f asg

266: l_dummy varchar2(1);
267: --
268: cursor c_valid_asg (id number) is
269: select 'x'
270: from per_all_assignments_f asg
271: where asg.assignment_id = id;
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 1);