APPS.HR_PERSON_INTERNAL dependencies on PER_BOOKINGS

Line 908: from per_bookings b

904: into l_delete_permitted
905: from sys.dual
906: where not exists (
907: select null
908: from per_bookings b
909: where b.person_id = P_PERSON_ID);
910: --
911: exception
912: when NO_DATA_FOUND then

Line 2983: delete from per_bookings b

2979: -- bug fix 3732129.
2980: -- Delete statement modified to improve performance.
2981: --
2982: forall i in 1..l_assignment_id.count
2983: delete from per_bookings b
2984: where b.event_id in
2985: (select e.event_id
2986: from per_events e
2987: where e.assignment_id = l_assignment_id(i));

Line 2989: /*delete from per_bookings b

2985: (select e.event_id
2986: from per_events e
2987: where e.assignment_id = l_assignment_id(i));
2988:
2989: /*delete from per_bookings b
2990: where b.event_id in
2991: (select e.event_id
2992: from per_events e
2993: where exists (

Line 3053: delete from per_bookings b

3049: end if;
3050: --
3051: begin
3052: --
3053: delete from per_bookings b
3054: where b.person_id = P_PERSON_ID;
3055: --
3056: exception
3057: when NO_DATA_FOUND then