APPS.HR_PERSON_DELETE dependencies on PER_REQUISITIONS

Line 940: from per_requisitions r

936: into v_delete_permitted
937: from sys.dual
938: where not exists (
939: select null
940: from per_requisitions r
941: where r.person_id = P_PERSON_ID);
942: exception
943: when NO_DATA_FOUND then
944: hr_utility.set_message (801,'HR_6338_ALL_PER_REQ_NO_DEL');

Line 1523: update per_requisitions r

1519:
1520: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 888);
1521:
1522: begin
1523: update per_requisitions r
1524: set r.person_id = null
1525: where r.person_id = P_PERSON_ID;
1526: exception
1527: when NO_DATA_FOUND then