DELETE FROM "LNREQCHGMAVLAW" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LNCHGMAVLAW_DOCNO" = :Original_LNCHGMAVLAW_DOCNO)) INSERT INTO "LNREQCHGMAVLAW" ("COOP_ID", "LNCHGMAVLAW_DOCNO", "LNCHGMAVLAW_DATE", "MEMCOOP_ID", "MEMBER_NO", "SUE_NO", "BFMAVSET_BAL", "BFMAVREAL_BAL", "BFMAVLAW_STATUS", "MAVLAW_SETAMT", "MAVLAW_CHGTOSTATUS", "ENTRY_ID", "ENTRY_DATE", "ENTRY_BYCOOPID") VALUES (:COOP_ID, :LNCHGMAVLAW_DOCNO, :LNCHGMAVLAW_DATE, :MEMCOOP_ID, :MEMBER_NO, :SUE_NO, :BFMAVSET_BAL, :BFMAVREAL_BAL, :BFMAVLAW_STATUS, :MAVLAW_SETAMT, :MAVLAW_CHGTOSTATUS, :ENTRY_ID, :ENTRY_DATE, :ENTRY_BYCOOPID) select * from lnreqchgmavlaw UPDATE "LNREQCHGMAVLAW" SET "COOP_ID" = :COOP_ID, "LNCHGMAVLAW_DOCNO" = :LNCHGMAVLAW_DOCNO, "LNCHGMAVLAW_DATE" = :LNCHGMAVLAW_DATE, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "SUE_NO" = :SUE_NO, "BFMAVSET_BAL" = :BFMAVSET_BAL, "BFMAVREAL_BAL" = :BFMAVREAL_BAL, "BFMAVLAW_STATUS" = :BFMAVLAW_STATUS, "MAVLAW_SETAMT" = :MAVLAW_SETAMT, "MAVLAW_CHGTOSTATUS" = :MAVLAW_CHGTOSTATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "ENTRY_BYCOOPID" = :ENTRY_BYCOOPID WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LNCHGMAVLAW_DOCNO" = :Original_LNCHGMAVLAW_DOCNO))