APPS.HR_PERSON_INTERNAL dependencies on PER_VACANCIES

Line 1162: from per_vacancies v

1158: into l_delete_permitted
1159: from sys.dual
1160: where not exists (
1161: select null
1162: from per_vacancies v
1163: where v.recruiter_id = P_PERSON_ID);
1164: --
1165: exception
1166: when NO_DATA_FOUND then

Line 2487: update per_vacancies v

2483: end if;
2484: --
2485: begin
2486: --
2487: update per_vacancies v
2488: set v.recruiter_id = null
2489: where v.recruiter_id = P_PERSON_ID;
2490: --
2491: exception