207: CURSOR c_wsh_deliveres (p_line_id in number) is
208: select distinct wda.delivery_id
209: from wsh_delivery_details wdd,
210: wsh_new_deliveries wnd,
211: wsh_delivery_assignments wda
212: where wdd.source_line_id = p_line_id
213: and wdd.delivery_detail_id = wda.delivery_detail_id
214: and wda.delivery_id = wnd.delivery_id
215: and wnd.delivery_id is not null;