DELETE FROM "HRNMLEMPLFILEMAS" WHERE (("EMPLID" = :Original_EMPLID)) SELECT EMPLCODE, EMPLFIRSNAME, EMPLID FROM HRNMLEMPLFILEMAS UPDATE "HRNMLEMPLFILEMAS" SET "EMPLCODE" = :EMPLCODE, "EMPLFIRSNAME" = :EMPLFIRSNAME, "EMPLID" = :EMPLID WHERE (("EMPLID" = :Original_EMPLID)) SELECT HRNPAYROLL.PAY_YEAR, HRNPAYROLL.PAY_MONTH, HRNPAYROLL.SEQ_PAY, HRNPAYROLL.EMPLID, HRNPAYROLL.PAYROLL_AMT, HRNPAYROLL.TRAN_DATE, HRNPAYROLL.TRAN_ACC FROM HRNPAYROLL