APPS.PER_EVENTS_PKG dependencies on PER_BOOKINGS

Line 50: PER_BOOKINGS B

46: ---
47: /* CURSOR CH4 IS
48: SELECT 1
49: FROM PER_PEOPLE_F P,
50: PER_BOOKINGS B
51: WHERE P.PERSON_ID = B.PERSON_ID
52: AND B.EVENT_ID = X_EVENT_ID;
53:
54: CURSOR CH5 IS

Line 57: PER_BOOKINGS B

53:
54: CURSOR CH5 IS
55: SELECT 1
56: FROM PER_PEOPLE_F P,
57: PER_BOOKINGS B
58: WHERE P.PERSON_ID = B.PERSON_ID
59: AND B.EVENT_ID = X_EVENT_ID
60: AND X_DATE_START BETWEEN
61: P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE; */

Line 239: from per_bookings

235: p_error_if_true boolean default FALSE) return boolean is
236: --
237: cursor csr_booking is
238: select 1
239: from per_bookings
240: where event_id = p_event_id;
241: --
242: v_booking_exists boolean := FALSE;
243: --

Line 274: from per_bookings INTERVIEW

270: p_new_interview_start_date date) is
271: --
272: cursor csr_interview is
273: select interview.person_id
274: from per_bookings INTERVIEW
275: where interview.event_id = p_event_id;
276: --
277: /*cursor csr_person_start (p_person_id in number) is
278: select min (effective_start_date)

Line 1142: FROM PER_BOOKINGS

1138: L_DUMMY2 NUMBER;
1139:
1140: CURSOR CHILD_CHECK IS
1141: SELECT 1
1142: FROM PER_BOOKINGS
1143: WHERE BUSINESS_GROUP_ID + 0 = X_Business_Group_Id
1144: AND EVENT_ID = X_Event_Id;
1145:
1146: CURSOR PAY_CHANGE_CHECK IS