APPS.HR_PERSON_INTERNAL dependencies on PER_BOOKINGS

Line 937: from per_bookings b

933: into l_delete_permitted
934: from sys.dual
935: where not exists (
936: select null
937: from per_bookings b
938: where b.person_id = P_PERSON_ID);
939: --
940: exception
941: when NO_DATA_FOUND then

Line 3036: delete from per_bookings b

3032: -- bug fix 3732129.
3033: -- Delete statement modified to improve performance.
3034: --
3035: forall i in 1..l_assignment_id.count
3036: delete from per_bookings b
3037: where b.event_id in
3038: (select e.event_id
3039: from per_events e
3040: where e.assignment_id = l_assignment_id(i));

Line 3042: /*delete from per_bookings b

3038: (select e.event_id
3039: from per_events e
3040: where e.assignment_id = l_assignment_id(i));
3041:
3042: /*delete from per_bookings b
3043: where b.event_id in
3044: (select e.event_id
3045: from per_events e
3046: where exists (

Line 3106: delete from per_bookings b

3102: end if;
3103: --
3104: begin
3105: --
3106: delete from per_bookings b
3107: where b.person_id = P_PERSON_ID;
3108: --
3109: exception
3110: when NO_DATA_FOUND then