DBA Data[Home] [Help]

APPS.WIP_EAM_WORKREQUEST_PVT dependencies on FND_TIMEZONES_VL

Line 1336: SELECT timezone_code INTO l_timezone_code FROM fnd_timezones_vl WHERE upgrade_tz_id = l_timezone_id;

1332: -- To display server time zone code.
1333: SELECT fnd_profile.value('SERVER_TIMEZONE_ID') INTO l_timezone_id FROM DUAL;
1334: l_timezone_code := null;
1335: IF (l_timezone_id is not null) THEN
1336: SELECT timezone_code INTO l_timezone_code FROM fnd_timezones_vl WHERE upgrade_tz_id = l_timezone_id;
1337: IF (l_timezone_code IS NOT null) THEN
1338: l_timezone_code := '('||l_timezone_code||')';
1339: END IF;
1340: END IF;