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 381: from per_assignments_f paf

377: l_assignment_id per_all_assignments_f.assignment_id%type;
378: cursor fut_apl(l_assignment_id number) is select 'Y'
379: from sys.dual
380: where exists (select 'future assignment exists'
381: from per_assignments_f paf
382: where paf.assignment_id = l_assignment_id
383: and paf.assignment_type = 'A'
384: and paf.effective_start_date >= p_hire_date);
385:

Line 821: from per_assignments_f

817: -- use to change the session date
818: --
819: cursor get_dates is
820: select min(effective_start_date), max(effective_end_date)
821: from per_assignments_f
822: where assignment_id = p_assignment_id;
823: begin
824: open get_dates;
825: fetch get_dates into p_min_start, p_max_end;

Line 1056: , per_assignments_f a

1052: into l_temp
1053: from sys.dual
1054: where exists ( select 'Events rows exist'
1055: from per_events pe
1056: , per_assignments_f a
1057: where pe.business_group_id +0 = p_business_group_id
1058: and pe.assignment_id = a.assignment_id
1059: and pe.date_start
1060: between a.effective_start_date and a.effective_end_date