APPS.PER_VACANCY_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 430: from per_all_assignments_f paf,

426: l_inv_job_grade_warning boolean;
427: l_temp_ovn number := P_OBJECT_VERSION_NUMBER;
428: cursor csr_asg is
429: select assignment_id,paf.object_version_number
430: from per_all_assignments_f paf,
431: per_all_vacancies pav
432: where paf.vacancy_id = p_vacancy_id
433: and paf.vacancy_id = pav.vacancy_id
434: and paf.assignment_type = 'A';

Line 638: update per_all_assignments_f asg

634: -- fix for the bug 5719667
635: l_position_id := p_position_id;
636: hr_utility.set_location(l_proc, 40);
637: --
638: update per_all_assignments_f asg
639: set asg.organization_id = nvl(l_organization_id, asg.organization_id)
640: ,asg.job_id = nvl(l_job_id, asg.job_id)
641: ,asg.grade_id = nvl(l_grade_id, asg.grade_id)
642: ,asg.people_group_id = nvl(l_people_group_id, asg.people_group_id)