APPS.HR_EX_EMPLOYEE_API dependencies on PER_BOOKINGS

Line 75: , per_bookings pb

71: into v_dummy
72: from sys.dual
73: where exists ( select 'Events exist'
74: from per_events pe
75: , per_bookings pb
76: where pe.business_group_id = pb.business_group_id
77: and (pb.business_group_id = p_business_group_id OR
78: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
79: and pe.event_id = pb.event_id

Line 107: ,per_bookings pb

103: )
104: OR
105: exists(select 'Interview rows exist'
106: from per_events pe
107: ,per_bookings pb
108: where pe.business_group_id = pb.business_group_id
109: and (pb.business_group_id = p_business_group_id OR
110: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
111: and pe.event_id = pb.event_id

Line 855: DELETE from per_bookings

851:
852: hr_utility.set_location('csr_events.event_id '||csr_events.event_id, 342);
853: hr_utility.set_location('csr_events.object_version_number '||csr_events.object_version_number, 342);
854:
855: DELETE from per_bookings
856: WHERE event_id = csr_events.event_id;
857:
858: hr_utility.set_location(' after bookings ', 342);
859:

Line 908: DELETE from per_bookings

904: IF l_prev_event <> csr_perf.event_id THEN
905: IF l_prev_event <> -1 THEN
906: BEGIN
907: hr_utility.trace('Deleting the event :'||l_prev_event);
908: DELETE from per_bookings
909: WHERE event_id = l_prev_event;
910: per_events_api.delete_event(
911: p_event_id =>l_prev_event,
912: p_object_version_number =>l_prev_ovn);

Line 926: DELETE from per_bookings

922: END LOOP;
923: IF l_prev_event <> -1 THEN
924: BEGIN
925: hr_utility.trace('Outside loop.. deleting:'||l_prev_event);
926: DELETE from per_bookings
927: WHERE event_id = l_prev_event;
928: per_events_api.delete_event(
929: p_event_id =>l_prev_event,
930: p_object_version_number =>l_prev_ovn);