1485: FROM po_requisition_headers
1486: WHERE Segment1 = l_header_rec.requisition_number)
1487: AND NOT EXISTS
1488: ( SELECT 1
1489: FROM po_history_requisitions phr
1490: WHERE phr.segment1 = l_header_rec.requisition_number);
1491:
1492: EXCEPTION
1493: WHEN NO_DATA_FOUND THEN
2975: FROM po_requisition_headers
2976: WHERE Segment1 = l_header_rec.requisition_number)
2977: AND NOT EXISTS
2978: ( SELECT 1
2979: FROM po_history_requisitions phr
2980: WHERE phr.segment1 = l_header_rec.requisition_number);
2981:
2982: EXCEPTION
2983: WHEN NO_DATA_FOUND THEN