APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_EVENTS

Line 79: from per_events pe

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

Line 344: from per_events pe

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

Line 691: from per_events pe

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

Line 704: from per_events pe

700: -- Interviews cursor
701: --
702: cursor interviews is
703: select 'Interviews exist'
704: from per_events pe
705: where (pe.business_group_id = p_business_group_id OR
706: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
707: and pe.event_or_interview = 'I'
708: and pe.internal_contact_person_id = p_person_id;

Line 1229: from per_events pe

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'
1229: from per_events pe
1230: where pe.business_group_id + 0 = p_business_group_id
1231: and pe.event_id = pb.event_id
1232: and pe.event_or_interview in ('I','E')
1233: and pe.date_start >= p_date_start);

Line 2149: from per_events pe

2145: -- since in all other cases pe.assignment_id is null
2146: --
2147: cursor events_or_interviews(p_assignment_id NUMBER) is
2148: select pe.event_id
2149: from per_events pe
2150: where pe.date_start >= p_date_received
2151: and p_assignment_id = pe.assignment_id;
2152: --
2153: -- bookings cursor

Line 2157: from per_events pe,

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

Line 2366: delete from per_events pe

2362: <>
2363: loop
2364: fetch events_or_interviews into l_pk_id;
2365: exit when events_or_interviews%NOTFOUND;
2366: delete from per_events pe
2367: where pe.event_id = l_pk_id;
2368: if sql%notfound then
2369: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2370: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 2873: FROM per_events pe,

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

Line 2886: FROM per_events pe

2882: -- Interviews cursor
2883: --
2884: CURSOR csr_interviews IS
2885: SELECT 'Interviews exist'
2886: FROM per_events pe
2887: WHERE (pe.business_group_id = p_business_group_id OR
2888: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2889: AND pe.event_or_interview = 'I'
2890: AND pe.internal_contact_person_id = p_person_id;

Line 3295: FROM per_events pe

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'
3295: FROM per_events pe
3296: WHERE pe.business_group_id + 0 = p_business_group_id
3297: AND pe.event_id = pb.event_id
3298: AND pe.event_or_interview in ('I','E')
3299: AND pe.date_start >= l_date_start);