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