APPS.OTA_EVT_BUS dependencies on PER_ALL_PEOPLE_F

Line 333: PER_ALL_PEOPLE_F DEL ,

329: l_success boolean := true;
330: cursor c1 is
331: select BST.TYPE
332: FROM OTA_BOOKING_STATUS_TYPES BST ,
333: PER_ALL_PEOPLE_F DEL ,
334: OTA_EVENTS EVT ,
335: OTA_DELEGATE_BOOKINGS TDB
336: where tdb.business_group_id = p_business_group_id
337: and evt.event_id = p_event_id

Line 3108: FROM Per_all_people_f per

3104:
3105: CURSOR c_people
3106: IS
3107: SELECT null
3108: FROM Per_all_people_f per
3109: WHERE per.person_id = p_owner_id and
3110: per.business_group_id = p_business_group_id and
3111: NVL(p_course_start_date,TRUNC(SYSDATE)) between
3112: effective_start_date and effective_end_date;

Line 3117: FROM Per_all_people_f per

3113:
3114: CURSOR c_people_cross
3115: IS
3116: SELECT null
3117: FROM Per_all_people_f per
3118: WHERE per.person_id = p_owner_id and
3119: NVL(p_course_start_date,TRUNC(SYSDATE)) between
3120: effective_start_date and effective_end_date;
3121: