DELETE FROM "LNINSURANCEFIRE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("INSURANCE_NO" = :Original_INSURANCE_NO)) INSERT INTO "LNINSURANCEFIRE" ("COOP_ID", "INSURANCE_NO", "MEMBER_NO", "LOANCONTRACT_NO", "OPERATE_DATE", "PRINCIPAL_BALANCE", "STARTINSURE_DATE", "EXPIREINSURE_DATE", "INSURANCE_AMT", "STAMPDUTY_AMT", "VAT_PERCENT", "DISCOUNT_PERCENT", "COORDINATE_PERCENT", "INSURENET_AMT", "INSUREPAY_STATUS", "ENTRY_ID", "ENTRY_DATE", "LOANTYPE_CODE", "FLOODINSURE_AMT", "MTHKEEP_STATUS", "COLLMAST_NO", "MEMCOOP_ID", "CONCOOP_ID") VALUES (:COOP_ID, :INSURANCE_NO, :MEMBER_NO, :LOANCONTRACT_NO, :OPERATE_DATE, :PRINCIPAL_BALANCE, :STARTINSURE_DATE, :EXPIREINSURE_DATE, :INSURANCE_AMT, :STAMPDUTY_AMT, :VAT_PERCENT, :DISCOUNT_PERCENT, :COORDINATE_PERCENT, :INSURENET_AMT, :INSUREPAY_STATUS, :ENTRY_ID, :ENTRY_DATE, :LOANTYPE_CODE, :FLOODINSURE_AMT, :MTHKEEP_STATUS, :COLLMAST_NO, :MEMCOOP_ID, :CONCOOP_ID) select coop_id, insurance_no, member_no, loancontract_no, operate_date, principal_balance, startinsure_date, expireinsure_date, insurance_amt, stampduty_amt, vat_percent, discount_percent, coordinate_percent, insurenet_amt, insurepay_status, entry_id, entry_date, loantype_code, floodinsure_amt, mthkeep_status, collmast_no, memcoop_id, concoop_id from lninsurancefire UPDATE "LNINSURANCEFIRE" SET "COOP_ID" = :COOP_ID, "INSURANCE_NO" = :INSURANCE_NO, "MEMBER_NO" = :MEMBER_NO, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "OPERATE_DATE" = :OPERATE_DATE, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE, "STARTINSURE_DATE" = :STARTINSURE_DATE, "EXPIREINSURE_DATE" = :EXPIREINSURE_DATE, "INSURANCE_AMT" = :INSURANCE_AMT, "STAMPDUTY_AMT" = :STAMPDUTY_AMT, "VAT_PERCENT" = :VAT_PERCENT, "DISCOUNT_PERCENT" = :DISCOUNT_PERCENT, "COORDINATE_PERCENT" = :COORDINATE_PERCENT, "INSURENET_AMT" = :INSURENET_AMT, "INSUREPAY_STATUS" = :INSUREPAY_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "LOANTYPE_CODE" = :LOANTYPE_CODE, "FLOODINSURE_AMT" = :FLOODINSURE_AMT, "MTHKEEP_STATUS" = :MTHKEEP_STATUS, "COLLMAST_NO" = :COLLMAST_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "CONCOOP_ID" = :CONCOOP_ID WHERE (("COOP_ID" = :Original_COOP_ID) AND ("INSURANCE_NO" = :Original_INSURANCE_NO))