2111: SELECT PO_Ref_1
2112: FROM OKE_K_DELIVERABLES_B
2113: WHERE Deliverable_ID = L_Deliverable_ID
2114: AND NOT EXISTS ( SELECT 1
2115: FROM po_requisitions_interface_all
2116: WHERE deliver_to_location_id = l_ship_to_location_id
2117: AND oke_contract_deliverable_id = l_deliverable_id
2118: AND process_flag = 'ERROR' );
2119: