APPS.PER_PEOPLE3_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 288: l_assignment_id per_all_assignments_f.assignment_id%type;

284: --
285: l_dummy VARCHAR2(1);
286: l_index number;
287: l_max_ele number;
288: l_assignment_id per_all_assignments_f.assignment_id%type;
289: --
290: --
291: cursor fut_apl(l_assignment_id number) is select 'Y'
292: from sys.dual

Line 465: from per_all_assignments_f paf

461: -- Cursor
462: --
463: cursor ass_cur is
464: select assignment_id
465: from per_all_assignments_f paf
466: where paf.person_id = p_person_id
467: and paf.assignment_type = 'E'
468: and p_start_date between
469: paf.effective_start_date and paf.effective_end_date;

Line 582: from per_all_assignments_f paf

578: into l_dummy_id
579: from per_all_vacancies pav
580: where pav.number_of_openings <
581: (select count(distinct assignment_id) + 1
582: from per_all_assignments_f paf
583: where paf.vacancy_id = pav.vacancy_id
584: and paf.assignment_type = 'E')
585: and pav.vacancy_id = p_vacancy_id;
586: --