DELETE FROM "LNLOANTYPE" WHERE (("LOANTYPE_CODE" = :Original_LOANTYPE_CODE) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNLOANTYPE" ("LOANTYPE_CODE", "LOANTYPE_DESC", "COOP_ID") VALUES (:LOANTYPE_CODE, :LOANTYPE_DESC, :COOP_ID) SELECT LOANTYPE_CODE, LOANTYPE_DESC, COOP_ID FROM LNLOANTYPE UPDATE "LNLOANTYPE" SET "LOANTYPE_CODE" = :LOANTYPE_CODE, "LOANTYPE_DESC" = :LOANTYPE_DESC, "COOP_ID" = :COOP_ID WHERE (("LOANTYPE_CODE" = :Original_LOANTYPE_CODE) AND ("COOP_ID" = :Original_COOP_ID))