DROP TRIGGER ActualizarBono;
CREATE OR REPLACE TRIGGER ActualizarBono
AFTER UPDATE OR INSERT OR DELETE ON MEDICAMENTOS
FOR EACH ROW
BEGIN
    UPDATE fichapac_detalle SET bonofarma = (SELECT B.BONO FROM MEDICAMENTOS A JOIN REMEDIO B ON(A.ID_REM = B.ID_REM));
END;
/

INSERT INTO MEDICAMENTOS VALUES(50,6,'uno al día x 15 días');
INSERT INTO MEDICAMENTOS VALUES(50,7,'3 veces a la semana');
SELECT B.BONO FROM MEDICAMENTOS A JOIN REMEDIO B ON(A.ID_REM = B.ID_REM);
create or replace trigger TR_BONO_FARMA
    after insert or update on MEDICAMENTOS
    for each row
Begin
    IF (INSERTING) THEN
        UPDATE fichapac_detalle
        SET bonofarma = round((SELECT B.BONO FROM MEDICAMENTOS A JOIN REMEDIO B ON(A.ID_REM = B.ID_REM)));
    elsif (UPDATING) THEN
        UPDATE fichapac_detalle
        SET bonofarma = round((SELECT B.BONO FROM MEDICAMENTOS A JOIN REMEDIO B ON(A.ID_REM = B.ID_REM))))
        WHERE NUMERO = :NEW.NUMERO;
    end if;
end TR_BONO_FARMA;