68: SELECT name,
69: customer_id,
70: organization_id,
71: ultimate_dropoff_location_id --bug 3920178
72: FROM wsh_new_deliveries
73: WHERE delivery_id = p_delivery_id;
74:
75: CURSOR l_get_dates_cur
76: IS
429: ultimate_dropoff_location_id,
430: intmed_ship_to_location_id,
431: pooled_ship_to_location_id,
432: currency_code
433: FROM wsh_new_deliveries
434: WHERE delivery_id = p_delivery_id;
435:
436: /* Patchset I: Locations Project. Select address components from
437: wsh_ship_from_org_locations_v */