264:
265: SELECT wda.delivery_id
266: INTO l_delivery_id
267: FROM wsh_delivery_assignments_v wda,
268: wsh_delivery_details wdd
269: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
270: AND wdd.move_order_line_id = l_task_drop_loc_rec.move_order_line_id;
271:
272: EXCEPTION
489:
490: SELECT wda.delivery_id
491: INTO l_delivery_id
492: FROM wsh_delivery_assignments_v wda,
493: wsh_delivery_details wdd
494: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
495: AND wdd.move_order_line_id = l_task_drop_loc_rec.move_order_line_id;
496:
497: EXCEPTION