[Home] [Help]
TRIGGER: APPS.XTR_AI_CURRENCY_CROSS_RATES_T
Source
Description
XTR_AI_CURRENCY_CROSS_RATES_T
AFTER INSERT on XTR_CURRENCY_CROSS_RATES
FOR EACH ROW
--
Type
AFTER EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
begin
update XTR_BUY_SELL_COMBINATIONS
set LATEST_CROSS_RATE = ((:NEW.BID_RATE + :NEW.OFFER_RATE) / 2),
LATEST_CROSS_DATE = SYSDATE
where CURRENCY_FIRST = :NEW.CURRENCY_FIRST
and CURRENCY_SECOND = :NEW.CURRENCY_SECOND;
end;