APPS.HR_PERSON_INTERNAL dependencies on PER_VACANCIES

Line 1133: from per_vacancies v

1129: into l_delete_permitted
1130: from sys.dual
1131: where not exists (
1132: select null
1133: from per_vacancies v
1134: where v.recruiter_id = P_PERSON_ID);
1135: --
1136: exception
1137: when NO_DATA_FOUND then

Line 2434: update per_vacancies v

2430: end if;
2431: --
2432: begin
2433: --
2434: update per_vacancies v
2435: set v.recruiter_id = null
2436: where v.recruiter_id = P_PERSON_ID;
2437: --
2438: exception