APPS.HR_PERSON_DELETE dependencies on PER_BOOKINGS

Line 775: from per_bookings b

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

Line 2214: delete from per_bookings b

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

Line 2219: /*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
2221: (select e.event_id
2222: from per_events e
2223: where exists (

Line 2268: delete from per_bookings b

2264: --
2265: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 28);
2266: --
2267: begin
2268: delete from per_bookings b
2269: where b.person_id = P_PERSON_ID;
2270: exception
2271: when NO_DATA_FOUND then
2272: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2801);