300: where po.cancelled_by = P_PERSON_ID
301: or po.closed_by = P_PERSON_ID)
302: and not exists (
303: select null
304: from po_line_locations_archive_all po
305: where po.cancelled_by = P_PERSON_ID
306: or po.closed_by = P_PERSON_ID);
307: exception
308: when NO_DATA_FOUND then