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 336: select 'Y' from per_all_assignments_f

332: --
333: l_dummy VARCHAR2(1);
334: --
335: cursor fut_upd_asg is
336: select 'Y' from per_all_assignments_f
337: where person_id = p_person_id
338: and assignment_id = p_assignment_id
339: and effective_start_date >= p_hire_date;
340:

Line 342: select 'Y' from per_all_assignments_f

338: and assignment_id = p_assignment_id
339: and effective_start_date >= p_hire_date;
340:
341: cursor other_asg is
342: select 'Y' from per_all_assignments_f
343: where person_id = p_person_id
344: and effective_start_date >= p_hire_date
345: and assignment_type in ('E','C');
346:

Line 377: l_assignment_id per_all_assignments_f.assignment_id%type;

373: --
374: l_dummy VARCHAR2(1);
375: l_index number;
376: l_max_ele number;
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

Line 389: from per_all_assignments_f

385:
386: l_start_date date;
387: cursor min_eff_date(p_assignment_id number) is
388: select min(effective_start_date)
389: from per_all_assignments_f
390: where person_id = p_person_id
391: and assignment_id = p_assignment_id
392: and assignment_type = 'A';
393:

Line 569: from per_all_assignments_f paf

565: -- Cursor
566: --
567: cursor ass_cur is
568: select assignment_id
569: from per_all_assignments_f paf
570: where paf.person_id = p_person_id
571: and paf.assignment_type = 'E'
572: and p_start_date between
573: paf.effective_start_date and paf.effective_end_date;

Line 686: from per_all_assignments_f paf

682: into l_dummy_id
683: from per_all_vacancies pav
684: where pav.number_of_openings <
685: (select count(distinct assignment_id) + 1
686: from per_all_assignments_f paf
687: where paf.vacancy_id = pav.vacancy_id
688: and paf.assignment_type = 'E')
689: and pav.vacancy_id = p_vacancy_id;
690: --