APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_BOOKINGS

Line 248: , per_bookings pb

244: --
245: cursor events_or_interviews is
246: select pb.rowid
247: from per_events pe
248: , per_bookings pb
249: where pe.business_group_id = pb.business_group_id
250: and (pb.business_group_id = p_business_group_id OR
251: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
252: and pe.event_id = pb.event_id

Line 513: , per_bookings pb

509: --
510: cursor events_or_interviews(p_type varchar2) is
511: select pb.rowid
512: from per_events pe
513: , per_bookings pb
514: where pe.business_group_id = pb.business_group_id
515: and (pb.business_group_id = p_business_group_id OR
516: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
517: and pe.event_id = pb.event_id

Line 875: , per_bookings pb

871: --
872: cursor reviews_or_events(p_type varchar2) is
873: select 'Events exist'
874: from per_events pe
875: , per_bookings pb
876: where pe.business_group_id = pb.business_group_id
877: and (pb.business_group_id = p_business_group_id OR
878: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
879: and pe.event_id = pb.event_id

Line 2134: from per_bookings pb

2130: -- events cursor
2131: --
2132: cursor events is
2133: select rowid
2134: from per_bookings pb
2135: where (pb.business_group_id = p_business_group_id OR
2136: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2137: and pb.person_id = p_person_id
2138: and exists ( select 'row exists'

Line 2472: delete from per_bookings pb

2468: loop
2469: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',100);
2470: fetch events into p_rowid;
2471: exit when events%NOTFOUND;
2472: delete from per_bookings pb
2473: where pb.rowid = p_rowid;
2474: --
2475: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',110);
2476: if sql%notfound then

Line 3158: per_bookings pb

3154: --
3155: cursor bookings2 is
3156: select pb.booking_id
3157: from per_events pe,
3158: per_bookings pb
3159: where pb.event_id = pe.event_id
3160: and pe.date_start >= p_date_received
3161: and pb.person_id = p_person_id
3162: and pe.emp_or_apl = 'A';

Line 3589: delete from per_bookings pb

3585: <>
3586: loop
3587: fetch bookings2 into l_pk_id;
3588: exit when bookings2%NOTFOUND;
3589: delete from per_bookings pb
3590: where pb.booking_id = l_pk_id;
3591: if sql%notfound then
3592: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3593: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 4052: per_bookings pb

4048: --
4049: CURSOR csr_reviews_or_events(p_type varchar2) IS
4050: SELECT 'Events exist'
4051: FROM per_events pe,
4052: per_bookings pb
4053: WHERE pe.business_group_id = pb.business_group_id
4054: AND (pb.business_group_id = p_business_group_id OR
4055: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4056: AND pe.event_id = pb.event_id

Line 4505: FROM per_bookings pb

4501: -- events cursor
4502: --
4503: CURSOR csr_events IS
4504: SELECT ROWID
4505: FROM per_bookings pb
4506: WHERE (pb.business_group_id = p_business_group_id OR
4507: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4508: AND pb.person_id = p_person_id
4509: AND EXISTS (SELECT 'row exists'

Line 4924: DELETE FROM per_bookings pb

4920: FOR events_rec IN csr_events LOOP
4921: --
4922: hr_utility.set_location(l_proc,180);
4923: --
4924: DELETE FROM per_bookings pb
4925: WHERE pb.rowid = events_rec.rowid;
4926: --
4927: IF SQL%NOTFOUND THEN
4928: --