APPS.HZ_TIMEZONE_PUB dependencies on FND_TIMEZONES_VL

Line 578: FROM HZ_TIMEZONES H, FND_TIMEZONES_VL F

574: x_name,
575: l_GMT_deviation,
576: l_dst_flag,
577: l_timezone_code
578: FROM HZ_TIMEZONES H, FND_TIMEZONES_VL F
579: WHERE H.timezone_id = p_timezone_id
580: AND H.timezone_id = F.upgrade_tz_id;
581:
582: EXCEPTION WHEN NO_DATA_FOUND THEN

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;