APPS.HR_PERSON_DELETE dependencies on PER_BOOKINGS

Line 776: from per_bookings b

772: into v_delete_permitted
773: from sys.dual
774: where not exists (
775: select null
776: from per_bookings b
777: where b.person_id = P_PERSON_ID);
778: exception
779: when NO_DATA_FOUND then
780: hr_utility.set_message (801,'HR_6329_ALL_PER_BOOK_NO_DEL');

Line 2285: delete from per_bookings b

2281: -- bug fix 3732129.
2282: -- Delete statement modified to improve performance.
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:

Line 2290: /*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
2292: (select e.event_id
2293: from per_events e
2294: where exists (

Line 2339: delete from per_bookings b

2335: --
2336: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 28);
2337: --
2338: begin
2339: delete from per_bookings b
2340: where b.person_id = P_PERSON_ID;
2341: exception
2342: when NO_DATA_FOUND then
2343: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2801);