BEGIN

DELETE FROM DEDUCTION_YEAR;

INSERT INTO DEDUCTION_YEAR (DTYPEID)

Select DTID from DEDUCTION_TYPE

WHERE ACTIVE = 'A'

ORDER BY DTID;

COMMIT;

END;