DELETE FROM "LNTEMPTABPAYINDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNTEMPTABPAYINDET" ("COOP_ID", "SEQ_NO", "RECV_DATE", "PERIOD", "PRNPAY_AMT", "INTPAY_AMT", "PRNBAL_AMT", "INTPAY_DAY") VALUES (:COOP_ID, :SEQ_NO, :RECV_DATE, :PERIOD, :PRNPAY_AMT, :INTPAY_AMT, :PRNBAL_AMT, :INTPAY_DAY) SELECT LNTEMPTABPAYINDET.* FROM LNTEMPTABPAYINDET UPDATE "LNTEMPTABPAYINDET" SET "COOP_ID" = :COOP_ID, "SEQ_NO" = :SEQ_NO, "RECV_DATE" = :RECV_DATE, "PERIOD" = :PERIOD, "PRNPAY_AMT" = :PRNPAY_AMT, "INTPAY_AMT" = :INTPAY_AMT, "PRNBAL_AMT" = :PRNBAL_AMT, "INTPAY_DAY" = :INTPAY_DAY WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SEQ_NO" = :Original_SEQ_NO))