APPS.OTA_VIEWS_PKG dependencies on OTA_EVENTS

Line 47: from ota_events

43: and db.event_id = p_event_id ;
44:
45: select nvl(maximum_attendees,0)
46: into l_max_places
47: from ota_events
48: where event_id = p_event_id ;
49:
50: select nvl(maximum_internal_attendees, -1)
51: into l_max_internal_places

Line 52: from ota_events

48: where event_id = p_event_id ;
49:
50: select nvl(maximum_internal_attendees, -1)
51: into l_max_internal_places
52: from ota_events
53: where event_id = p_event_id;
54:
55: select event_status
56: into l_event_status

Line 57: from ota_events

53: where event_id = p_event_id;
54:
55: select event_status
56: into l_event_status
57: from ota_events
58: where event_id = p_event_id;
59:
60:
61: l_no_of_places_remaining :=