APPS.HR_PERSON_DELETE dependencies on PER_EVENTS

Line 759: from per_events e

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

Line 1063: from per_events e

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

Line 2216: from per_events e

2212:
2213: forall i in 1..l_assignment_id.count
2214: delete from per_bookings b
2215: where b.event_id in (select e.event_id
2216: from per_events e
2217: where e.assignment_id = l_assignment_id(i));
2218:
2219: /*delete from per_bookings b
2220: where b.event_id in

Line 2222: from per_events e

2218:
2219: /*delete from per_bookings b
2220: where b.event_id in
2221: (select e.event_id
2222: from per_events e
2223: where exists (
2224: select null
2225: from per_assignments_f ass
2226: where ass.assignment_id = e.assignment_id

Line 2241: delete from per_events e

2237: -- bug fix 3732129.
2238: -- Delete statement modified to improve performance.
2239:
2240: forall i in 1..l_assignment_id.count
2241: delete from per_events e
2242: where e.assignment_id = l_assignment_id(i);
2243:
2244: /* delete from per_events e
2245: where e.assignment_id in (

Line 2244: /* delete from per_events e

2240: forall i in 1..l_assignment_id.count
2241: delete from per_events e
2242: where e.assignment_id = l_assignment_id(i);
2243:
2244: /* delete from per_events e
2245: where e.assignment_id in (
2246: select ass.assignment_id
2247: from per_assignments_f ass
2248: where ass.person_id = P_PERSON_ID);*/

Line 2257: update per_events e

2253: --
2254: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 27);
2255: --
2256: begin
2257: update per_events e
2258: set e.internal_contact_person_id = null
2259: where e.internal_contact_person_id = P_PERSON_ID;
2260: exception
2261: when NO_DATA_FOUND then