APPS.OTA_TIMEZONE_UTIL dependencies on FND_TIMEZONES_B

Line 42: FROM fnd_timezones_b

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

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

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

Line 81: FROM FND_TIMEZONES_B

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