APPS.OTA_TIMEZONE_UTIL dependencies on FND_TIMEZONES_TL

Line 113: FROM fnd_timezones_tl ftt

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

Line 133: FROM fnd_timezones_tl

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

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

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

Line 319: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;

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

Line 320: l_trb_timezone_name fnd_timezones_tl.name%TYPE;

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