APPS.OTA_TIMEZONE_UPGRADE dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 412: FROM ota_frm_obj_inclusions

408: object_version_number
409: FROM ota_resource_bookings
410: WHERE forum_id IN
411: (SELECT forum_id
412: FROM ota_frm_obj_inclusions
413: WHERE object_type = 'E'
414: AND object_id = p_event_id)
415: AND timezone_code IS NULL;
416: BEGIN

Line 431: FROM ota_frm_obj_inclusions

427: UPDATE ota_resource_bookings
428: SET timezone_code = p_time_zone
429: WHERE forum_id IN
430: (SELECT forum_id
431: FROM ota_frm_obj_inclusions
432: WHERE object_type = 'E'
433: AND object_id = p_event_id)
434: AND timezone_code IS NULL;
435: END;

Line 597: FROM ota_frm_obj_inclusions

593: object_version_number
594: FROM ota_resource_bookings
595: WHERE forum_id IN
596: (SELECT forum_id
597: FROM ota_frm_obj_inclusions
598: WHERE primary_flag = 'Y'
599: AND object_type = 'C')
600: AND timezone_code IS NULL;
601: BEGIN

Line 632: FROM ota_frm_obj_inclusions

628: UPDATE ota_resource_bookings
629: SET timezone_code = l_time_zone
630: WHERE forum_id IN
631: (SELECT forum_id
632: FROM ota_frm_obj_inclusions
633: WHERE primary_flag = 'Y'
634: AND object_type = 'C')
635: AND timezone_code IS NULL;
636: END IF;