APPS.HR_PERSON_INTERNAL dependencies on PER_RECRUITMENT_ACTIVITIES

Line 1080: from per_recruitment_activities r

1076: into l_delete_permitted
1077: from sys.dual
1078: where not exists (
1079: select null
1080: from per_recruitment_activities r
1081: where r.authorising_person_id = P_PERSON_ID
1082: or r.internal_contact_person_id = P_PERSON_ID);
1083: --
1084: exception

Line 2242: update per_recruitment_activities r

2238: end if;
2239: --
2240: begin
2241: --
2242: update per_recruitment_activities r
2243: set r.authorising_person_id = null
2244: where r.authorising_person_id = P_PERSON_ID;
2245: --
2246: exception

Line 2259: update per_recruitment_activities r

2255: end if;
2256: --
2257: begin
2258: --
2259: update per_recruitment_activities r
2260: set r.internal_contact_person_id = null
2261: where r.internal_contact_person_id = P_PERSON_ID;
2262: --
2263: exception