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 3128: FROM Per_all_people_f per

3124:
3125: CURSOR c_people
3126: IS
3127: SELECT null
3128: FROM Per_all_people_f per
3129: WHERE per.person_id = p_owner_id and
3130: per.business_group_id = p_business_group_id and
3131: NVL(p_course_start_date,TRUNC(SYSDATE)) between
3132: effective_start_date and effective_end_date;

Line 3137: FROM Per_all_people_f per

3133:
3134: CURSOR c_people_cross
3135: IS
3136: SELECT null
3137: FROM Per_all_people_f per
3138: WHERE per.person_id = p_owner_id and
3139: NVL(p_course_start_date,TRUNC(SYSDATE)) between
3140: effective_start_date and effective_end_date;
3141: