hr_tran_step_update_person_id
before insert or update on hr_api_transaction_steps for each row
Type
BEFORE EACH ROW
Event
INSERT OR UPDATE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
begin
SELECT iav.number_value
INTO :NEW.update_person_id
FROM wf_item_attribute_values iav
WHERE iav.item_type = :NEW.item_type
AND iav.item_key = :NEW.item_key
AND iav.name = 'CURRENT_PERSON_ID';
exception
when others then
:NEW.update_person_id := -1;
end per_events_ovn;