APPS.HR_PERSON_DELETE dependencies on PER_RECRUITMENT_ACTIVITIES

Line 892: from per_recruitment_activities r

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

Line 1620: update per_recruitment_activities r

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

Line 1631: update per_recruitment_activities r

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