APPS.OTA_TIMEZONE_UTIL dependencies on OTA_OFFERINGS

Line 7: ,ota_offerings ofn

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
11: AND ctu.type = 'DM'

Line 21: , ota_offerings ofn

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
24: AND evt.event_id = trb.event_id
25: AND ctu.category_usage_id = ofn.delivery_mode_id