4014: -- Select released_status and associated delivery for unplaning and un assigning.
4015: CURSOR unassign_del_csr IS
4016: SELECT wdd.delivery_detail_id,wdd.released_status,wda.delivery_id
4017: FROM wsh_delivery_details wdd,
4018: wsh_delivery_assignments_v wda
4019: WHERE routing_req_id = p_routing_req_id
4020: AND wdd.delivery_detail_id = wda.delivery_detail_id
4021: ORDER BY wda.delivery_id;
4022:
4201: wdd.po_shipment_line_number,
4202: wdd.source_blanket_reference_num,
4203: wda.delivery_id
4204: FROM wsh_delivery_details wdd,
4205: wsh_delivery_assignments_v wda
4206: WHERE wdd.delivery_detail_id = p_detail_id
4207: AND wdd.delivery_detail_id = wda.delivery_detail_id;
4208:
4209: l_del_info get_del_info%ROWTYPE;