APPS.PER_PEOPLE3_PKG dependencies on PER_ASSIGNMENTS

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 653: from per_assignments pa, per_all_vacancies pav

649: --
650: cursor app_ass(p_last_vacancy number) is
651: select pav.vacancy_id,pav.name
652: ,pa.assignment_id -- #2381925
653: from per_assignments pa, per_all_vacancies pav
654: , per_assignment_status_types pas
655: where person_id = p_person_id
656: and pav.vacancy_id = pa.vacancy_id
657: and pa.assignment_status_type_id = pas.assignment_status_type_id

Line 736: from per_assignments pa

732: -- Get the number of currently accepted assignments.
733: --
734: select count(pa.assignment_id)
735: into p_num_accepted_appls
736: from per_assignments pa
737: , per_assignment_status_types past
738: where pa.person_id = p_person_id
739: and pa.assignment_status_type_id = past.assignment_status_type_id
740: and past.per_system_status = 'ACCEPTED';

Line 753: from per_assignments pa

749: --
750: begin
751: select pa.assignment_id
752: into p_new_primary_id
753: from per_assignments pa
754: , per_assignment_status_types past
755: where pa.person_id = p_person_id
756: and pa.assignment_status_type_id = past.assignment_status_type_id
757: and past.per_system_status = 'ACCEPTED';

Line 784: from per_assignments pa

780: -- which are current.
781: --
782: select count(pa.assignment_id)
783: into p_num_appls
784: from per_assignments pa
785: where pa.person_id =p_person_id
786: and pa.assignment_type = 'A';
787: end;
788: --

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