APPS.OTA_TIMEZONE_UTIL dependencies on FND_TIMEZONES_TL

Line 114: FROM fnd_timezones_tl ftt

110: IS
111: CURSOR csr_get_evt_tzvals IS
112: SELECT timezone_code
113: ,name
114: FROM fnd_timezones_tl ftt
115: ,ota_events evt
116: WHERE event_id = p_event_id
117: AND evt.timezone = ftt.timezone_code
118: AND ftt.language = userenv('LANG');

Line 134: FROM fnd_timezones_tl

130: RETURN VARCHAR2
131: IS
132: CURSOR csr_get_timezone_vals IS
133: SELECT name
134: FROM fnd_timezones_tl
135: WHERE timezone_code = p_timezone_code
136: AND LANGUAGE = userenv('LANG');
137:
138: l_timezone_name fnd_timezones_tl.name%TYPE := NULL;

Line 138: l_timezone_name fnd_timezones_tl.name%TYPE := NULL;

134: FROM fnd_timezones_tl
135: WHERE timezone_code = p_timezone_code
136: AND LANGUAGE = userenv('LANG');
137:
138: l_timezone_name fnd_timezones_tl.name%TYPE := NULL;
139: BEGIN
140: OPEN csr_get_timezone_vals;
141: FETCH csr_get_timezone_vals INTO l_timezone_name;
142: CLOSE csr_get_timezone_vals;

Line 320: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;

316: RETURN DATE
317: IS
318: l_online_flag ota_category_usages.online_flag%TYPE;
319: --l_trb_timezone ota_resource_bookings.timezone%TYPE;
320: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;
321: l_trb_timezone_name fnd_timezones_tl.name%TYPE;
322: BEGIN
323: OPEN get_resource_booking_info(p_resource_booking_id);
324: FETCH get_resource_booking_info INTO l_online_flag, l_trb_timezone, l_trb_timezone_name;

Line 321: l_trb_timezone_name fnd_timezones_tl.name%TYPE;

317: IS
318: l_online_flag ota_category_usages.online_flag%TYPE;
319: --l_trb_timezone ota_resource_bookings.timezone%TYPE;
320: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;
321: l_trb_timezone_name fnd_timezones_tl.name%TYPE;
322: BEGIN
323: OPEN get_resource_booking_info(p_resource_booking_id);
324: FETCH get_resource_booking_info INTO l_online_flag, l_trb_timezone, l_trb_timezone_name;
325: CLOSE get_resource_booking_info;