APPS.HR_PERSON_DELETE dependencies on PER_EVENTS

Line 760: from per_events e

756: into v_delete_permitted
757: from sys.dual
758: where not exists (
759: select null
760: from per_events e
761: where e.internal_contact_person_id = P_PERSON_ID);
762: exception
763: when NO_DATA_FOUND then
764: hr_utility.set_message (801,'HR_6328_ALL_PER_EVENT_NO_DEL');

Line 1064: from per_events e

1060: into v_delete_permitted
1061: from sys.dual
1062: where not exists (
1063: select null
1064: from per_events e
1065: where exists (
1066: select null
1067: from per_assignments_f a
1068: where a.person_id = P_PERSON_ID

Line 2287: from per_events e

2283:
2284: forall i in 1..l_assignment_id.count
2285: delete from per_bookings b
2286: where b.event_id in (select e.event_id
2287: from per_events e
2288: where e.assignment_id = l_assignment_id(i));
2289:
2290: /*delete from per_bookings b
2291: where b.event_id in

Line 2293: from per_events e

2289:
2290: /*delete from per_bookings b
2291: where b.event_id in
2292: (select e.event_id
2293: from per_events e
2294: where exists (
2295: select null
2296: from per_assignments_f ass
2297: where ass.assignment_id = e.assignment_id

Line 2312: delete from per_events e

2308: -- bug fix 3732129.
2309: -- Delete statement modified to improve performance.
2310:
2311: forall i in 1..l_assignment_id.count
2312: delete from per_events e
2313: where e.assignment_id = l_assignment_id(i);
2314:
2315: /* delete from per_events e
2316: where e.assignment_id in (

Line 2315: /* delete from per_events e

2311: forall i in 1..l_assignment_id.count
2312: delete from per_events e
2313: where e.assignment_id = l_assignment_id(i);
2314:
2315: /* delete from per_events e
2316: where e.assignment_id in (
2317: select ass.assignment_id
2318: from per_assignments_f ass
2319: where ass.person_id = P_PERSON_ID);*/

Line 2328: update per_events e

2324: --
2325: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 27);
2326: --
2327: begin
2328: update per_events e
2329: set e.internal_contact_person_id = null
2330: where e.internal_contact_person_id = P_PERSON_ID;
2331: exception
2332: when NO_DATA_FOUND then