DROP TRIGGER APPRAISAL_STATUS_TRIGGER;

CREATE OR REPLACE TRIGGER HRIS_APPRAISAL_STAT_TRG AFTER
  INSERT ON HRIS_APPRAISAL_ASSIGN FOR EACH ROW BEGIN
  INSERT
  INTO HRIS_APPRAISAL_STATUS
    (
      EMPLOYEE_ID,
      APPRAISAL_ID
    )
    VALUES
    (
      :new.EMPLOYEE_ID,
      :new.APPRAISAL_ID
    );
END;