1313: -- validate foreign keys
1314: if cr.HAZARD_CLASS_ID is not null then
1315: begin
1316: select 'x' into temp 1317: from PO_HAZARD_CLASSES 1318: where HAZARD_CLASS_ID = cr.HAZARD_CLASS_ID
1319: and (INACTIVE_DATE is null or INACTIVE_DATE > sysdate);
1320: exception
1321: when NO_DATA_FOUND then