DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on WSH_LOCATIONS

Line 2849: FROM wsh_locations

2845: x_return_status OUT NOCOPY VARCHAR2)
2846: IS
2847: CURSOR c_get_latitude_longitude (c_location_id NUMBER) IS
2848: SELECT latitude, longitude
2849: FROM wsh_locations
2850: WHERE wsh_location_id = c_location_id;
2851:
2852: CURSOR c_get_dis_emp_constant IS
2853: SELECT tl_hway_dis_emp_constant

Line 2913: -- get latitude and longitude in degrees from wsh_locations

2909:
2910: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_from_location_id='||p_from_location_id);
2911: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_to_location_id='||p_to_location_id);
2912:
2913: -- get latitude and longitude in degrees from wsh_locations
2914: OPEN c_get_latitude_longitude(p_from_location_id);
2915: FETCH c_get_latitude_longitude INTO l_from_latitude_in_degrees, l_from_longitude_in_degrees;
2916: CLOSE c_get_latitude_longitude;
2917: