DBA Data[Home] [Help]

APPS.WSH_LOCATIONS_PKG dependencies on FND_TIMEZONES_B

Line 426: FROM WSH_LOCATIONS WSH, HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_B TZ --3842898 : Replaced fnd_timezones_vl with fnd_timezones_b

422: WSH.LATITUDE,
423: WSH.LONGITUDE,
424: NVL(TZ.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
425: SYSDATE
426: FROM WSH_LOCATIONS WSH, HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_B TZ --3842898 : Replaced fnd_timezones_vl with fnd_timezones_b
427: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
428: AND nvl(hz.last_update_date,sysdate) >= nvl(l_start_date, nvl(hz.last_update_date,sysdate))
429: AND nvl(hz.last_update_date,sysdate) < nvl(l_end_date, nvl(hz.last_update_date,sysdate)+1)
430: AND hz.location_id = wsh.source_location_id