APPS.PER_PEOPLE3_PKG dependencies on PER_ASSIGNMENTS_F

Line 264: from per_assignments_f paf

260: --
261: cursor fut_apl is select 'Y'
262: from sys.dual
263: where exists (select 'future assignment exists'
264: from per_assignments_f paf
265: where paf.person_id = p_person_id
266: and paf.assignment_type = 'A'
267: and paf.effective_start_date >= p_hire_date);
268: begin

Line 294: from per_assignments_f paf

290: --
291: cursor fut_apl(l_assignment_id number) is select 'Y'
292: from sys.dual
293: where exists (select 'future assignment exists'
294: from per_assignments_f paf
295: where paf.assignment_id = l_assignment_id
296: and paf.assignment_type = 'A'
297: and paf.effective_start_date >= p_hire_date);
298: begin

Line 717: from per_assignments_f

713: -- use to change the session date
714: --
715: cursor get_dates is
716: select min(effective_start_date), max(effective_end_date)
717: from per_assignments_f
718: where assignment_id = p_assignment_id;
719: begin
720: open get_dates;
721: fetch get_dates into p_min_start, p_max_end;

Line 901: , per_assignments_f a

897: into l_temp
898: from sys.dual
899: where exists ( select 'Events rows exist'
900: from per_events pe
901: , per_assignments_f a
902: where pe.business_group_id +0 = p_business_group_id
903: and pe.assignment_id = a.assignment_id
904: and pe.date_start
905: between a.effective_start_date and a.effective_end_date