APPS.PER_VACANCIES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 88: PER_ALL_ASSIGNMENTS_F PAF

84: PROCEDURE Check_References(P_vacancy_id NUMBER ) is
85: CURSOR c_check_references1 IS
86: SELECT distinct(PV.NAME)
87: FROM PER_VACANCIES PV,
88: PER_ALL_ASSIGNMENTS_F PAF
89: WHERE PAF.VACANCY_ID = P_vacancy_id
90: AND PV.VACANCY_ID = P_vacancy_id
91: AND PAF.VACANCY_ID = PV.VACANCY_ID;
92:

Line 245: from per_all_assignments_f

241: is
242: cursor csr_appl_exists
243: is
244: select '1'
245: from per_all_assignments_f
246: where vacancy_id =P_vacancy_id
247: and effective_start_date < P_vac_date_from
248: and assignment_type = 'A';
249:

Line 1326: update per_all_assignments_f asg

1322: -- Details are only cascaded to the applicant assignments when the value
1323: -- is not null, except for position, which updates the value if the
1324: -- organization and job have changed regardless of whether it is null.
1325: --
1326: update per_all_assignments_f asg
1327: set asg.organization_id = nvl(x_organization_id, asg.organization_id)
1328: ,asg.job_id = nvl(x_job_id, asg.job_id)
1329: ,asg.grade_id = nvl(x_grade_id, asg.grade_id)
1330: ,asg.people_group_id = nvl(x_people_group_id, asg.people_group_id)