14:
15: CURSOR csr_evt_tz (p_event_id NUMBER)
16: IS
17: SELECT TIMEZONE 18: FROM ota_events 19: WHERE event_id = p_event_id
20: AND event_type IN ('SCHEDULED', 'SELFPACED');
21: BEGIN
22:
Line 64: FROM ota_events
60: p_event_id IN NUMBER
61: )
62: IS
63: SELECT event_id,business_group_id,object_version_number 64: FROM ota_events 65: WHERE parent_event_id = p_event_id;
66: BEGIN
67:
68: for csr_chats_row in csr_chats(p_event_id)