APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_BOOKINGS

Line 80: , per_bookings pb

76: --
77: cursor events_or_interviews is
78: select pb.rowid
79: from per_events pe
80: , per_bookings pb
81: where pe.business_group_id = pb.business_group_id
82: and (pb.business_group_id = p_business_group_id OR
83: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
84: and pe.event_id = pb.event_id

Line 345: , per_bookings pb

341: --
342: cursor events_or_interviews(p_type varchar2) is
343: select pb.rowid
344: from per_events pe
345: , per_bookings pb
346: where pe.business_group_id = pb.business_group_id
347: and (pb.business_group_id = p_business_group_id OR
348: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
349: and pe.event_id = pb.event_id

Line 692: , per_bookings pb

688: --
689: cursor reviews_or_events(p_type varchar2) is
690: select 'Events exist'
691: from per_events pe
692: , per_bookings pb
693: where pe.business_group_id = pb.business_group_id
694: and (pb.business_group_id = p_business_group_id OR
695: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
696: and pe.event_id = pb.event_id

Line 1224: from per_bookings pb

1220: -- events cursor
1221: --
1222: cursor events is
1223: select rowid
1224: from per_bookings pb
1225: where (pb.business_group_id = p_business_group_id OR
1226: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1227: and pb.person_id = p_person_id
1228: and exists ( select 'row exists'

Line 1552: delete from per_bookings pb

1548: loop
1549: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',100);
1550: fetch events into p_rowid;
1551: exit when events%NOTFOUND;
1552: delete from per_bookings pb
1553: where pb.rowid = p_rowid;
1554: --
1555: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',110);
1556: if sql%notfound then

Line 2158: per_bookings pb

2154: --
2155: cursor bookings2 is
2156: select pb.booking_id
2157: from per_events pe,
2158: per_bookings pb
2159: where pb.event_id = pe.event_id
2160: and pe.date_start >= p_date_received
2161: and pb.person_id = p_person_id
2162: and pe.emp_or_apl = 'A';

Line 2525: delete from per_bookings pb

2521: <>
2522: loop
2523: fetch bookings2 into l_pk_id;
2524: exit when bookings2%NOTFOUND;
2525: delete from per_bookings pb
2526: where pb.booking_id = l_pk_id;
2527: if sql%notfound then
2528: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2529: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 2874: per_bookings pb

2870: --
2871: CURSOR csr_reviews_or_events(p_type varchar2) IS
2872: SELECT 'Events exist'
2873: FROM per_events pe,
2874: per_bookings pb
2875: WHERE pe.business_group_id = pb.business_group_id
2876: AND (pb.business_group_id = p_business_group_id OR
2877: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2878: AND pe.event_id = pb.event_id

Line 3290: FROM per_bookings pb

3286: -- events cursor
3287: --
3288: CURSOR csr_events IS
3289: SELECT ROWID
3290: FROM per_bookings pb
3291: WHERE (pb.business_group_id = p_business_group_id OR
3292: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3293: AND pb.person_id = p_person_id
3294: AND EXISTS (SELECT 'row exists'

Line 3650: DELETE FROM per_bookings pb

3646: FOR events_rec IN csr_events LOOP
3647: --
3648: hr_utility.set_location(l_proc,180);
3649: --
3650: DELETE FROM per_bookings pb
3651: WHERE pb.rowid = events_rec.rowid;
3652: --
3653: IF SQL%NOTFOUND THEN
3654: --