APPS.OTA_LO_UTILITY dependencies on PER_ALL_PEOPLE

Line 1657: p_person_id per_all_people.person_id%type) is

1653: p_reason out nocopy number) return boolean is
1654:
1655: cursor person_bookings(
1656: p_event_id ota_events.event_id%type,
1657: p_person_id per_all_people.person_id%type) is
1658: select 1
1659: from ota_delegate_bookings book,
1660: ota_booking_status_types stype
1661: where book.delegate_person_id = p_person_id and

Line 1668: p_contact_id per_all_people.person_id%type) is

1664: stype.type in ('P', 'A' ,'E');
1665:
1666: cursor contact_bookings(
1667: p_event_id ota_events.event_id%type,
1668: p_contact_id per_all_people.person_id%type) is
1669: select 1
1670: from ota_delegate_bookings book,
1671: ota_booking_status_types stype
1672: where book.delegate_contact_id = p_contact_id and