DELETE FROM "LNGRPLOANPERMISS" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANPERMGRP_CODE" = :Original_LOANPERMGRP_CODE)) INSERT INTO "LNGRPLOANPERMISS" ("COOP_ID", "LOANPERMGRP_CODE", "LOANPERMGRP_DESC", "MAXPERMISS_AMT", "LOANGROUP_CODE") VALUES (:COOP_ID, :LOANPERMGRP_CODE, :LOANPERMGRP_DESC, :MAXPERMISS_AMT, :LOANGROUP_CODE) SELECT COOP_ID, LOANPERMGRP_CODE, LOANPERMGRP_DESC, MAXPERMISS_AMT, LOANGROUP_CODE FROM LNGRPLOANPERMISS UPDATE "LNGRPLOANPERMISS" SET "COOP_ID" = :COOP_ID, "LOANPERMGRP_CODE" = :LOANPERMGRP_CODE, "LOANPERMGRP_DESC" = :LOANPERMGRP_DESC, "MAXPERMISS_AMT" = :MAXPERMISS_AMT, "LOANGROUP_CODE" = :LOANGROUP_CODE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANPERMGRP_CODE" = :Original_LOANPERMGRP_CODE))