APPS.OTA_TIMEZONE_UTIL dependencies on OTA_EVENTS

Line 6: FROM ota_events evt

2: /* $Header: ottznutl.pkh 120.0.12000000.1 2007/01/18 05:29:11 appldev noship $ */
3:
4: CURSOR get_class_info(p_class_id NUMBER) IS
5: SELECT ctu.online_flag, evt.timezone
6: FROM ota_events evt
7: ,ota_offerings ofn
8: ,ota_category_usages ctu
9: WHERE evt.parent_offering_id = ofn.offering_id
10: AND ctu.category_usage_id = ofn.delivery_mode_id

Line 19: , ota_events evt

15: SELECT ctu.online_flag
16: ,trb.timezone_code
17: ,ftl.name timezone
18: FROM ota_resource_bookings trb
19: , ota_events evt
20: , ota_category_usages ctu
21: , ota_offerings ofn
22: , fnd_timezones_tl ftl
23: WHERE evt.parent_offering_id = ofn.offering_id