APPS.HZ_TIMEZONE_PUB dependencies on HZ_TIMEZONES_VL

Line 1068: from hz_timezones_vl h, fnd_timezones_vl f

1064: f.timezone_code
1065: into x_timezone_id,
1066: x_timezone_name,
1067: x_timezone_code
1068: from hz_timezones_vl h, fnd_timezones_vl f
1069: where h.timezone_id = f.upgrade_tz_id
1070: and h.gmt_deviation_hours = p_gmt_deviation_hours
1071: and h.daylight_savings_time_flag = p_daylight_savings_time_flag
1072: and nvl(h.begin_dst_month,'-99') = nvl(p_begin_dst_month,'-99')

Line 1231: FROM HZ_TIMEZONES_VL H, FND_TIMEZONES_VL F

1227: l_standard_short_code,
1228: l_daylight_short_code,
1229: x_name,
1230: l_timezone_code
1231: FROM HZ_TIMEZONES_VL H, FND_TIMEZONES_VL F
1232: WHERE H.timezone_id = p_timezone_id
1233: AND H.timezone_id = F.upgrade_tz_id;
1234:
1235: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1252: FROM FND_TIMEZONES_VL f, HZ_TIMEZONES_VL h

1248: INTO l_gmt_deviation,
1249: l_standard_short_code,
1250: l_daylight_short_code,
1251: x_name
1252: FROM FND_TIMEZONES_VL f, HZ_TIMEZONES_VL h
1253: WHERE f.timezone_code = p_timezone_code
1254: AND f.upgrade_tz_id = h.timezone_id;
1255:
1256: l_timezone_code := p_timezone_code;

Line 1388: FROM HZ_TIMEZONES_VL

1384: v_end_dst_day,
1385: v_end_dst_week_of_m,
1386: v_end_dst_day_of_w,
1387: v_end_dst_hour
1388: FROM HZ_TIMEZONES_VL
1389: WHERE timezone_id = p_timezone_id;
1390:
1391: IF(v_dst_flag = 'N')THEN
1392: x_begin_dst_date := null;