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

545: --
546: cursor app_ass(p_last_vacancy number) is
547: select pav.vacancy_id,pav.name
548: ,pa.assignment_id -- #2381925
549: from per_assignments pa, per_all_vacancies pav
550: , per_assignment_status_types pas
551: where person_id = p_person_id
552: and pav.vacancy_id = pa.vacancy_id
553: and pa.assignment_status_type_id = pas.assignment_status_type_id

Line 632: from per_assignments pa

628: -- Get the number of currently accepted assignments.
629: --
630: select count(pa.assignment_id)
631: into p_num_accepted_appls
632: from per_assignments pa
633: , per_assignment_status_types past
634: where pa.person_id = p_person_id
635: and pa.assignment_status_type_id = past.assignment_status_type_id
636: and past.per_system_status = 'ACCEPTED';

Line 649: from per_assignments pa

645: --
646: begin
647: select pa.assignment_id
648: into p_new_primary_id
649: from per_assignments pa
650: , per_assignment_status_types past
651: where pa.person_id = p_person_id
652: and pa.assignment_status_type_id = past.assignment_status_type_id
653: and past.per_system_status = 'ACCEPTED';

Line 680: from per_assignments pa

676: -- which are current.
677: --
678: select count(pa.assignment_id)
679: into p_num_appls
680: from per_assignments pa
681: where pa.person_id =p_person_id
682: and pa.assignment_type = 'A';
683: end;
684: --

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