503: loop
504: Select count(*)
505: into l_count
506: from
507: OTA_EVENTS oe
508: , OTA_DELEGATE_BOOKINGS odb
509: , OTA_BOOKING_STATUS_TYPES obst
510: , HR_ORGANIZATION_INFORMATION org_i
511: , per_all_people_f pp
690:
691: Select count(*)
692: into l_count
693: from
694: OTA_EVENTS oe
695: , OTA_DELEGATE_BOOKINGS odb
696: , OTA_BOOKING_STATUS_TYPES obst
697: , HR_ORGANIZATION_INFORMATION org_i
698: , per_all_people_f pp