APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_EVENTS

Line 247: from per_events pe

243: -- events cursor
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')

Line 512: from per_events pe

508: -- events cursor
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')

Line 874: from per_events pe

870: -- reviews or Events cursor
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')

Line 887: from per_events pe

883: -- Interviews cursor
884: --
885: cursor interviews is
886: select 'Interviews exist'
887: from per_events pe
888: where (pe.business_group_id = p_business_group_id OR
889: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
890: and pe.event_or_interview = 'I'
891: and pe.internal_contact_person_id = p_person_id;

Line 2139: from per_events pe

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'
2139: from per_events pe
2140: where pe.business_group_id + 0 = p_business_group_id
2141: and pe.event_id = pb.event_id
2142: and pe.event_or_interview in ('I','E')
2143: and pe.date_start >= p_date_start);

Line 3149: from per_events pe

3145: -- since in all other cases pe.assignment_id is null
3146: --
3147: cursor events_or_interviews(p_assignment_id NUMBER) is
3148: select pe.event_id
3149: from per_events pe
3150: where pe.date_start >= p_date_received
3151: and p_assignment_id = pe.assignment_id;
3152: --
3153: -- bookings cursor

Line 3157: from per_events pe,

3153: -- bookings cursor
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

Line 3430: delete from per_events pe

3426: <>
3427: loop
3428: fetch events_or_interviews into l_pk_id;
3429: exit when events_or_interviews%NOTFOUND;
3430: delete from per_events pe
3431: where pe.event_id = l_pk_id;
3432: if sql%notfound then
3433: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3434: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 4051: FROM per_events pe,

4047: -- reviews or Events cursor
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')

Line 4064: FROM per_events pe

4060: -- Interviews cursor
4061: --
4062: CURSOR csr_interviews IS
4063: SELECT 'Interviews exist'
4064: FROM per_events pe
4065: WHERE (pe.business_group_id = p_business_group_id OR
4066: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4067: AND pe.event_or_interview = 'I'
4068: AND pe.internal_contact_person_id = p_person_id;

Line 4510: FROM per_events pe

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'
4510: FROM per_events pe
4511: WHERE pe.business_group_id + 0 = p_business_group_id
4512: AND pe.event_id = pb.event_id
4513: AND pe.event_or_interview in ('I','E')
4514: AND pe.date_start >= l_date_start);