CREATE TABLE Functions
(FunctionID numeric (12) NOT NULL,
CompID numeric (12) NULL,
MaintBudgetID numeric (12) NULL,
PRIMARY KEY (FunctionID))

insert Functions values(100005321,100005329,null)

CREATE TABLE WorkOrder
(WorkOrderID numeric (12) NOT NULL,
CompID numeric (12) NULL,
BudgetCodeDefID numeric (12) NULL,
PRIMARY KEY (WorkOrderID))

insert Functions values(100005322,100005329,null)
insert Functions values(100005323,100005329,null)
insert Functions values(100005324,100005329,null)

update amos.functions set maintbudgetid=100000014 where functionid=100005321

CREATE TRIGGER "utru_Functions_MaintBudgetID"
AFTER UPDATE OF CompID, MaintBudgetID
ORDER 10 ON amos.Functions
REFERENCING OLD AS olddata NEW AS newdata
FOR EACH ROW
BEGIN
    IF user_name() != 'import' THEN
        IF newdata.CompID IS NOT NULL THEN
         begin			
            declare @WorkorderID numeric(12);
            declare CUR_CUSTOMER dynamic scroll cursor FOR 
                select WorkorderID 
                from amos.WorkOrder 
                where CompID = newdata.CompID;
            OPEN CUR_CUSTOMER;
            FETCH NEXT CUR_CUSTOMER INTO @WorkorderID;
            while (sqlcode = 0)
            loop 
                update amos.WorkOrder
                set BudgetCodeDefID = newdata.MaintBudgetID
                WHERE WorkorderID = @WorkorderID;
                FETCH NEXT CUR_CUSTOMER INTO @WorkorderID;
            end loop;
            CLOSE CUR_CUSTOMER;
         end;
        END IF;	
    END IF;
END

Could not execute statement.
SELECT returns more than one row
SQLCODE=-185, ODBC 3 State="HY000"
Line 1, column 1

CREATE TRIGGER "utru_Functions_MaintBudgetID_StockBudgetID"
AFTER UPDATE OF CompID, MaintBudgetID
ORDER 10 ON amos.Functions
REFERENCING OLD AS olddata NEW AS newdata
FOR EACH ROW
BEGIN
    IF user_name() != 'import' THEN
        IF newdata.CompID IS NOT NULL THEN
            UPDATE  amos.WorkOrder
            SET     BudgetCodeDefID = newdata.MaintBudgetID
            WHERE   CompID = newdata.CompID;
        END IF;
    END IF;
END

Could not execute statement.
SELECT returns more than one row
SQLCODE=-185, ODBC 3 State="HY000"
Line 1, column 1

declare CUR_CUSTOMER dynamic scroll cursor FOR 
   select WorkorderID 
   from amos.WorkOrder 
    where CompID = newdata.CompID;

CREATE TRIGGER "utru_Functions_MaintBudgetID_StockBudgetID"
AFTER UPDATE OF CompID, MaintBudgetID
ORDER 10 ON amos.Functions
REFERENCING OLD AS olddata NEW AS newdata
FOR EACH ROW
BEGIN

declare tempCompID numeric(12);
declare tempMaintBudgetID numeric(12);
set tempCompID = newdata.CompID;
set tempMaintBudgetID = newdata.MaintBudgetID;

    IF user_name() != 'import' THEN
        IF tempCompID IS NOT NULL THEN
            UPDATE  amos.WorkOrder
            SET     BudgetCodeDefID = tempMaintBudgetID
            WHERE   CompID = tempCompID;
        END IF;
    END IF;
END