APPS.OTA_TIMEZONE_UTIL dependencies on FND_TIMEZONES_B

Line 41: FROM fnd_timezones_b

37: RETURN NUMBER
38: IS
39: CURSOR csr_get_timezone_id IS
40: SELECT UPGRADE_TZ_ID
41: FROM fnd_timezones_b
42: WHERE timezone_code = p_timezone_code;
43:
44: l_timezone_id fnd_timezones_b.UPGRADE_TZ_ID%TYPE := NULL;
45: BEGIN

Line 44: l_timezone_id fnd_timezones_b.UPGRADE_TZ_ID%TYPE := NULL;

40: SELECT UPGRADE_TZ_ID
41: FROM fnd_timezones_b
42: WHERE timezone_code = p_timezone_code;
43:
44: l_timezone_id fnd_timezones_b.UPGRADE_TZ_ID%TYPE := NULL;
45: BEGIN
46: OPEN csr_get_timezone_id;
47: FETCH csr_get_timezone_id INTO l_timezone_id;
48: CLOSE csr_get_timezone_id;

Line 80: FROM FND_TIMEZONES_B

76: l_offset NUMBER;
77:
78: CURSOR csr_timezone_code(p_offset NUMBER) IS
79: SELECT timezone_code
80: FROM FND_TIMEZONES_B
81: WHERE GMT_OFFSET = p_offset
82: AND enabled_flag = 'Y';
83: */
84: