4561:
4562: l_progress := '050';
4563: --SQL What: Delete req action history with header within the range
4564: DELETE
4565: FROM po_action_history PA
4566: WHERE PA.object_type_code = 'REQUISITION'
4567: AND EXISTS (
4568: SELECT NULL
4569: FROM po_purge_req_list PPRL
5110: END IF;
5111:
5112: l_progress := '130';
5113:
5114: --SQL What: Delete po action history with header within the range
5115: DELETE
5116: FROM po_action_history PAH
5117: WHERE PAH.object_type_code = 'PO'
5118: AND EXISTS (
5112: l_progress := '130';
5113:
5114: --SQL What: Delete po action history with header within the range
5115: DELETE
5116: FROM po_action_history PAH
5117: WHERE PAH.object_type_code = 'PO'
5118: AND EXISTS (
5119: SELECT NULL
5120: FROM po_purge_po_list PPL