APPS.OTA_LO_UTILITY dependencies on PER_ALL_PEOPLE

Line 1351: p_person_id per_all_people.person_id%type) is

1347: p_reason out nocopy number) return boolean is
1348:
1349: cursor person_bookings(
1350: p_event_id ota_events.event_id%type,
1351: p_person_id per_all_people.person_id%type) is
1352: select 1
1353: from ota_delegate_bookings book,
1354: ota_booking_status_types stype
1355: where book.delegate_person_id = p_person_id and

Line 1362: p_contact_id per_all_people.person_id%type) is

1358: stype.type in ('P', 'A' ,'E');
1359:
1360: cursor contact_bookings(
1361: p_event_id ota_events.event_id%type,
1362: p_contact_id per_all_people.person_id%type) is
1363: select 1
1364: from ota_delegate_bookings book,
1365: ota_booking_status_types stype
1366: where book.delegate_contact_id = p_contact_id and