APPS.HR_PERSON_DELETE dependencies on PER_RECRUITMENT_ACTIVITIES

Line 891: from per_recruitment_activities r

887: into v_delete_permitted
888: from sys.dual
889: where not exists (
890: select null
891: from per_recruitment_activities r
892: where r.authorising_person_id = P_PERSON_ID
893: or r.internal_contact_person_id = P_PERSON_ID);
894: exception
895: when NO_DATA_FOUND then

Line 1619: update per_recruitment_activities r

1615: --
1616: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 9);
1617: --
1618: begin
1619: update per_recruitment_activities r
1620: set r.authorising_person_id = null
1621: where r.authorising_person_id = P_PERSON_ID;
1622: exception
1623: when NO_DATA_FOUND then

Line 1630: update per_recruitment_activities r

1626: --
1627: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 10);
1628: --
1629: begin
1630: update per_recruitment_activities r
1631: set r.internal_contact_person_id = null
1632: where r.internal_contact_person_id = P_PERSON_ID;
1633: exception
1634: when NO_DATA_FOUND then