This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:bonus_journal_trigger [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:bonus_journal_trigger [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 61: | Line 61: | ||
nvl(:old.last_name, :new.last_name), | nvl(:old.last_name, :new.last_name), | ||
nvl(:old.first_name, :new.first_name), | nvl(:old.first_name, :new.first_name), | ||
- | nvl(:new.salary, null), | + | :new.salary, |
- | nvl(:old.salary, null), | + | :old.salary, |
nvl(:old.bonus, :new.bonus), | nvl(:old.bonus, :new.bonus), | ||
sysdate, | sysdate, |