oracle查triger失效,Oracle触发器错误，无效标识符

我有以下完美工作的DML语句，我试图使它成为触发器，但它不起作用。

DML语句

UPDATE HOLIDAY_RESERVATION R SET SUBTOTAL =

NVL((SELECT F.FLI_PRICE FROM FLIGHT F WHERE F.FLI_ID = R.IN_FLIGHT_ID), 0) * NVL(R.IN_FLIGHT_SEATS_NO,0) +

NVL((SELECT F.FLI_PRICE FROM FLIGHT F WHERE F.FLI_ID = R.OUT_FLIGHT_ID), 0)* NVL(R.OUT_FLIGHT_SEATS_NO,0) +

NVL((SELECT AC.ACC_PRICEPN FROM ACCOMMODATION AC WHERE AC.ACC_ID = R.ACC_ID), 0);触发器语句

CREATE OR REPLACE TRIGGER HR_SUBTOTAL

BEFORE INSERT OR UPDATE ON HOLIDAY_RESERVATION

FOR EACH ROW

BEGIN

SELECT

NVL((SELECT F.FLI_PRICE FROM FLIGHT F WHERE F.FLI_ID = :NEW.IN_FLIGHT_ID), 0) * NVL(R.IN_FLIGHT_SEATS_NO,0) +

NVL((SELECT F.FLI_PRICE FROM FLIGHT F WHERE F.FLI_ID = :NEW.OUT_FLIGHT_ID), 0) * NVL(R.OUT_FLIGHT_SEATS_NO,0) +

NVL((SELECT AC.ACC_PRICEPN FROM ACCOMMODATION AC WHERE AC.ACC_ID = :NEW.ACC_ID), 0)

INTO :NEW.SUBTOTAL

FROM DUAL;

END;

Errors for TRIGGER HR_SUBTOTAL:

LINE/COL ERROR

-------- ----------------------------------------------------------------

2/4 PL/SQL: SQL Statement ignored

4/92 PL/SQL: ORA-00904: "R"."OUT_FLIGHT_SEATS_NO": invalid identifier这个错误必须在乘法位中，因为如果我除掉了乘法位，它可能会用括号括起来，或者用另一个选择符号。