DELETE FROM "SLSLIPPAYINDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYINSLIP_NO" = :Original_PAYINSLIP_NO) AND ("SLIPITEMTYPE_CODE" = :Original_SLIPITEMTYPE_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "SLSLIPPAYINDET" ("COOP_ID", "PAYINSLIP_NO", "SLIPITEMTYPE_CODE", "SEQ_NO", "OPERATE_FLAG", "SHRLONTYPE_CODE", "CONCOOP_ID", "LOANCONTRACT_NO", "SLIPITEM_DESC", "PERIODCOUNT_FLAG", "PERIOD", "PRINCIPAL_PAYAMT", "INTEREST_PAYAMT", "INTARREAR_PAYAMT", "ITEM_PAYAMT", "ITEM_BALANCE", "PRNCALINT_AMT", "CALINT_FROM", "CALINT_TO", "INTEREST_PERIOD", "INTEREST_RETURN", "STM_ITEMTYPE", "BFPERIOD", "BFINTARR_AMT", "BFINTARRSET_AMT", "BFLASTCALINT_DATE", "BFLASTPROC_DATE", "BFLASTPAY_DATE", "BFWITHDRAW_AMT", "BFPERIOD_PAYMENT", "BFSHRCONT_BALAMT", "BFSHRCONT_STATUS", "BFCONTLAW_STATUS", "BFCOUNTPAY_FLAG", "BFPAYSPEC_METHOD", "RKEEP_PRINCIPAL", "RKEEP_INTEREST", "NKEEP_INTEREST", "BFINTRETURN_FLAG", "BFINTRETURN_AMT", "BFPXAFTERMTHKEEP_TYPE", "REF_DOCNO", "FINEYEAR_ARREAR", "INYEAR_ARREAR", "BFFINE_ARREAR", "FINE_PERIOD", "INT_ARREAR", "FINE_ARREAR", "INTEREST_PAY", "INT_COMPENSATE") VALUES (:COOP_ID, :PAYINSLIP_NO, :SLIPITEMTYPE_CODE, :SEQ_NO, :OPERATE_FLAG, :SHRLONTYPE_CODE, :CONCOOP_ID, :LOANCONTRACT_NO, :SLIPITEM_DESC, :PERIODCOUNT_FLAG, :PERIOD, :PRINCIPAL_PAYAMT, :INTEREST_PAYAMT, :INTARREAR_PAYAMT, :ITEM_PAYAMT, :ITEM_BALANCE, :PRNCALINT_AMT, :CALINT_FROM, :CALINT_TO, :INTEREST_PERIOD, :INTEREST_RETURN, :STM_ITEMTYPE, :BFPERIOD, :BFINTARR_AMT, :BFINTARRSET_AMT, :BFLASTCALINT_DATE, :BFLASTPROC_DATE, :BFLASTPAY_DATE, :BFWITHDRAW_AMT, :BFPERIOD_PAYMENT, :BFSHRCONT_BALAMT, :BFSHRCONT_STATUS, :BFCONTLAW_STATUS, :BFCOUNTPAY_FLAG, :BFPAYSPEC_METHOD, :RKEEP_PRINCIPAL, :RKEEP_INTEREST, :NKEEP_INTEREST, :BFINTRETURN_FLAG, :BFINTRETURN_AMT, :BFPXAFTERMTHKEEP_TYPE, :REF_DOCNO, :FINEYEAR_ARREAR, :INYEAR_ARREAR, :BFFINE_ARREAR, :FINE_PERIOD, :INT_ARREAR, :FINE_ARREAR, :INTEREST_PAY, :INT_COMPENSATE) SELECT * FROM SLSLIPPAYINDET WHERE ( slslippayindet.coop_id = :as_coopid ) AND ( slslippayindet.payinslip_no = :as_slipno ) UPDATE "SLSLIPPAYINDET" SET "COOP_ID" = :COOP_ID, "PAYINSLIP_NO" = :PAYINSLIP_NO, "SLIPITEMTYPE_CODE" = :SLIPITEMTYPE_CODE, "SEQ_NO" = :SEQ_NO, "OPERATE_FLAG" = :OPERATE_FLAG, "SHRLONTYPE_CODE" = :SHRLONTYPE_CODE, "CONCOOP_ID" = :CONCOOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "SLIPITEM_DESC" = :SLIPITEM_DESC, "PERIODCOUNT_FLAG" = :PERIODCOUNT_FLAG, "PERIOD" = :PERIOD, "PRINCIPAL_PAYAMT" = :PRINCIPAL_PAYAMT, "INTEREST_PAYAMT" = :INTEREST_PAYAMT, "INTARREAR_PAYAMT" = :INTARREAR_PAYAMT, "ITEM_PAYAMT" = :ITEM_PAYAMT, "ITEM_BALANCE" = :ITEM_BALANCE, "PRNCALINT_AMT" = :PRNCALINT_AMT, "CALINT_FROM" = :CALINT_FROM, "CALINT_TO" = :CALINT_TO, "INTEREST_PERIOD" = :INTEREST_PERIOD, "INTEREST_RETURN" = :INTEREST_RETURN, "STM_ITEMTYPE" = :STM_ITEMTYPE, "BFPERIOD" = :BFPERIOD, "BFINTARR_AMT" = :BFINTARR_AMT, "BFINTARRSET_AMT" = :BFINTARRSET_AMT, "BFLASTCALINT_DATE" = :BFLASTCALINT_DATE, "BFLASTPROC_DATE" = :BFLASTPROC_DATE, "BFLASTPAY_DATE" = :BFLASTPAY_DATE, "BFWITHDRAW_AMT" = :BFWITHDRAW_AMT, "BFPERIOD_PAYMENT" = :BFPERIOD_PAYMENT, "BFSHRCONT_BALAMT" = :BFSHRCONT_BALAMT, "BFSHRCONT_STATUS" = :BFSHRCONT_STATUS, "BFCONTLAW_STATUS" = :BFCONTLAW_STATUS, "BFCOUNTPAY_FLAG" = :BFCOUNTPAY_FLAG, "BFPAYSPEC_METHOD" = :BFPAYSPEC_METHOD, "RKEEP_PRINCIPAL" = :RKEEP_PRINCIPAL, "RKEEP_INTEREST" = :RKEEP_INTEREST, "NKEEP_INTEREST" = :NKEEP_INTEREST, "BFINTRETURN_FLAG" = :BFINTRETURN_FLAG, "BFINTRETURN_AMT" = :BFINTRETURN_AMT, "BFPXAFTERMTHKEEP_TYPE" = :BFPXAFTERMTHKEEP_TYPE, "REF_DOCNO" = :REF_DOCNO, "FINEYEAR_ARREAR" = :FINEYEAR_ARREAR, "INYEAR_ARREAR" = :INYEAR_ARREAR, "BFFINE_ARREAR" = :BFFINE_ARREAR, "FINE_PERIOD" = :FINE_PERIOD, "INT_ARREAR" = :INT_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "INTEREST_PAY" = :INTEREST_PAY, "INT_COMPENSATE" = :INT_COMPENSATE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYINSLIP_NO" = :Original_PAYINSLIP_NO) AND ("SLIPITEMTYPE_CODE" = :Original_SLIPITEMTYPE_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "SLSLIPPAYOUT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYOUTSLIP_NO" = :Original_PAYOUTSLIP_NO)) INSERT INTO "SLSLIPPAYOUT" ("COOP_ID", "PAYOUTSLIP_NO", "MEMCOOP_ID", "MEMBER_NO", "DOCUMENT_NO", "SLIPTYPE_CODE", "SLIP_DATE", "OPERATE_DATE", "SHRLONTYPE_CODE", "PAYOUTORDER_NO", "RCVFROMREQCONT_CODE", "LOANREQUEST_DOCNO", "LOANCONTRACT_NO", "RCV_PERIOD", "RCVPERIOD_FLAG", "PAYOUT_AMT", "PAYOUTCLR_AMT", "PAYOUTNET_AMT", "BFPERIOD", "BFLOANAPPROVE_AMT", "BFSHRCONT_BALAMT", "BFWITHDRAW_AMT", "BFINTEREST_ARREAR", "BFLASTCALINT_DATE", "BFLASTRECEIVE_DATE", "BFLASTPROC_DATE", "BFCONTLAW_STATUS", "BFPAYMENT_STATUS", "BFCONTINT_TYPE", "PRNCALINT_AMT", "CALINT_FROM", "CALINT_TO", "INTEREST_PERIOD", "MONEYTYPE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "BANKFEE_AMT", "BANKSRV_AMT", "BANKVAT_AMT", "TOFROM_ACCID", "SLIP_STATUS", "SLIPCLEAR_NO", "MEMBGROUP_CODE", "SUBGROUP_CODE", "ENTRY_ID", "ENTRY_DATE", "ENTRY_BYCOOPID") VALUES (:COOP_ID, :PAYOUTSLIP_NO, :MEMCOOP_ID, :MEMBER_NO, :DOCUMENT_NO, :SLIPTYPE_CODE, :SLIP_DATE, :OPERATE_DATE, :SHRLONTYPE_CODE, :PAYOUTORDER_NO, :RCVFROMREQCONT_CODE, :LOANREQUEST_DOCNO, :LOANCONTRACT_NO, :RCV_PERIOD, :RCVPERIOD_FLAG, :PAYOUT_AMT, :PAYOUTCLR_AMT, :PAYOUTNET_AMT, :BFPERIOD, :BFLOANAPPROVE_AMT, :BFSHRCONT_BALAMT, :BFWITHDRAW_AMT, :BFINTEREST_ARREAR, :BFLASTCALINT_DATE, :BFLASTRECEIVE_DATE, :BFLASTPROC_DATE, :BFCONTLAW_STATUS, :BFPAYMENT_STATUS, :BFCONTINT_TYPE, :PRNCALINT_AMT, :CALINT_FROM, :CALINT_TO, :INTEREST_PERIOD, :MONEYTYPE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :BANKFEE_AMT, :BANKSRV_AMT, :BANKVAT_AMT, :TOFROM_ACCID, :SLIP_STATUS, :SLIPCLEAR_NO, :MEMBGROUP_CODE, :SUBGROUP_CODE, :ENTRY_ID, :ENTRY_DATE, :ENTRY_BYCOOPID) SELECT lpad(' ',100,' ') as mem_name, lpad(' ',100,' ') as loantype_desc, lpad(' ',100,' ') as membgroup_desc, lpad(' ',100,' ') as subgroup_desc, 1 as member_type, 1 as payment_status, "SLSLIPPAYOUT"."COOP_ID", "SLSLIPPAYOUT"."PAYOUTSLIP_NO", "SLSLIPPAYOUT"."MEMCOOP_ID", "SLSLIPPAYOUT"."MEMBER_NO", "SLSLIPPAYOUT"."DOCUMENT_NO", "SLSLIPPAYOUT"."SLIPTYPE_CODE", "SLSLIPPAYOUT"."SLIP_DATE", "SLSLIPPAYOUT"."OPERATE_DATE", "SLSLIPPAYOUT"."SHRLONTYPE_CODE", "SLSLIPPAYOUT"."PAYOUTORDER_NO", "SLSLIPPAYOUT"."RCVFROMREQCONT_CODE", "SLSLIPPAYOUT"."LOANREQUEST_DOCNO", "SLSLIPPAYOUT"."LOANCONTRACT_NO", "SLSLIPPAYOUT"."RCV_PERIOD", "SLSLIPPAYOUT"."RCVPERIOD_FLAG", "SLSLIPPAYOUT"."PAYOUT_AMT", "SLSLIPPAYOUT"."PAYOUTCLR_AMT", "SLSLIPPAYOUT"."PAYOUTNET_AMT", "SLSLIPPAYOUT"."BFPERIOD", "SLSLIPPAYOUT"."BFLOANAPPROVE_AMT", "SLSLIPPAYOUT"."BFSHRCONT_BALAMT", "SLSLIPPAYOUT"."BFWITHDRAW_AMT", "SLSLIPPAYOUT"."BFINTEREST_ARREAR", "SLSLIPPAYOUT"."BFLASTCALINT_DATE", "SLSLIPPAYOUT"."BFLASTRECEIVE_DATE", "SLSLIPPAYOUT"."BFLASTPROC_DATE", "SLSLIPPAYOUT"."BFCONTLAW_STATUS", "SLSLIPPAYOUT"."BFPAYMENT_STATUS", "SLSLIPPAYOUT"."BFCONTINT_TYPE", "SLSLIPPAYOUT"."PRNCALINT_AMT", "SLSLIPPAYOUT"."CALINT_FROM", "SLSLIPPAYOUT"."CALINT_TO", "SLSLIPPAYOUT"."INTEREST_PERIOD", "SLSLIPPAYOUT"."MONEYTYPE_CODE", "SLSLIPPAYOUT"."EXPENSE_BANK", "SLSLIPPAYOUT"."EXPENSE_BRANCH", "SLSLIPPAYOUT"."EXPENSE_ACCID", "SLSLIPPAYOUT"."BANKFEE_AMT", "SLSLIPPAYOUT"."BANKSRV_AMT", "SLSLIPPAYOUT"."BANKVAT_AMT", "SLSLIPPAYOUT"."TOFROM_ACCID", "SLSLIPPAYOUT"."SLIP_STATUS", "SLSLIPPAYOUT"."SLIPCLEAR_NO", "SLSLIPPAYOUT"."MEMBGROUP_CODE", "SLSLIPPAYOUT"."SUBGROUP_CODE", "SLSLIPPAYOUT"."ENTRY_ID", "SLSLIPPAYOUT"."ENTRY_DATE", "SLSLIPPAYOUT"."ENTRY_BYCOOPID" FROM "SLSLIPPAYOUT" WHERE ( slslippayout.coop_id = :as_coopid ) AND ( slslippayout.payoutslip_no = :as_slipno ) UPDATE "SLSLIPPAYOUT" SET "COOP_ID" = :COOP_ID, "PAYOUTSLIP_NO" = :PAYOUTSLIP_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "DOCUMENT_NO" = :DOCUMENT_NO, "SLIPTYPE_CODE" = :SLIPTYPE_CODE, "SLIP_DATE" = :SLIP_DATE, "OPERATE_DATE" = :OPERATE_DATE, "SHRLONTYPE_CODE" = :SHRLONTYPE_CODE, "PAYOUTORDER_NO" = :PAYOUTORDER_NO, "RCVFROMREQCONT_CODE" = :RCVFROMREQCONT_CODE, "LOANREQUEST_DOCNO" = :LOANREQUEST_DOCNO, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "RCV_PERIOD" = :RCV_PERIOD, "RCVPERIOD_FLAG" = :RCVPERIOD_FLAG, "PAYOUT_AMT" = :PAYOUT_AMT, "PAYOUTCLR_AMT" = :PAYOUTCLR_AMT, "PAYOUTNET_AMT" = :PAYOUTNET_AMT, "BFPERIOD" = :BFPERIOD, "BFLOANAPPROVE_AMT" = :BFLOANAPPROVE_AMT, "BFSHRCONT_BALAMT" = :BFSHRCONT_BALAMT, "BFWITHDRAW_AMT" = :BFWITHDRAW_AMT, "BFINTEREST_ARREAR" = :BFINTEREST_ARREAR, "BFLASTCALINT_DATE" = :BFLASTCALINT_DATE, "BFLASTRECEIVE_DATE" = :BFLASTRECEIVE_DATE, "BFLASTPROC_DATE" = :BFLASTPROC_DATE, "BFCONTLAW_STATUS" = :BFCONTLAW_STATUS, "BFPAYMENT_STATUS" = :BFPAYMENT_STATUS, "BFCONTINT_TYPE" = :BFCONTINT_TYPE, "PRNCALINT_AMT" = :PRNCALINT_AMT, "CALINT_FROM" = :CALINT_FROM, "CALINT_TO" = :CALINT_TO, "INTEREST_PERIOD" = :INTEREST_PERIOD, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "BANKFEE_AMT" = :BANKFEE_AMT, "BANKSRV_AMT" = :BANKSRV_AMT, "BANKVAT_AMT" = :BANKVAT_AMT, "TOFROM_ACCID" = :TOFROM_ACCID, "SLIP_STATUS" = :SLIP_STATUS, "SLIPCLEAR_NO" = :SLIPCLEAR_NO, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "SUBGROUP_CODE" = :SUBGROUP_CODE, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "ENTRY_BYCOOPID" = :ENTRY_BYCOOPID WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYOUTSLIP_NO" = :Original_PAYOUTSLIP_NO)) DELETE FROM "LNCONTMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO)) INSERT INTO "LNCONTMASTER" ("COOP_ID", "LOANCONTRACT_NO", "MEMCOOP_ID", "MEMBER_NO", "LOANTYPE_CODE", "LOANOBJECTIVE_CODE", "LOANREQUEST_DOCNO", "LOANREQUEST_AMT", "LOANAPPROVE_DATE", "LOANAPPROVE_AMT", "WITHDRAWABLE_AMT", "PRINCIPAL_BALANCE", "LOANPAYMENT_TYPE", "PERIOD_INSTALLMENT", "PERIOD_PAYMENT", "PERIOD_LASTPAYMENT", "PAYMENT_STATUS", "LAST_PERIODRCV", "LAST_PERIODPAY", "STARTCONT_DATE", "STARTKEEP_DATE", "STARTKEEP_PERIOD", "LASTRECEIVE_DATE", "LASTPAYMENT_DATE", "LASTCALINT_DATE", "LASTKEEPING_DATE", "LASTPROCESS_DATE", "LASTACCESS_DATE", "CLOSECONT_DATE", "PRINCIPAL_ARREAR", "INTEREST_ARREAR", "INTYEAR_ARREAR", "INTEREST_ACCUM", "INTACCUM_LASTYEAR", "PRINCIPAL_RETURN", "INTEREST_RETURN", "PRNPAYMENT_AMT", "INTPAYMENT_AMT", "LAST_STM_NO", "TRANSFER_STATUS", "PRINCIPAL_TRANS", "TRNFROM_CONTNO", "TRNFROM_MEMNO", "NKEEP_PRINCIPAL", "NKEEP_INTEREST", "RKEEP_PRINCIPAL", "RKEEP_INTEREST", "COMPOUND_STATUS", "COMPOUND_INSTALLMENT", "COMPOUND_DUEDATE", "COMPOUND_PAYMENT", "COMPOUND_PAYSTATUS", "MISSPAY_AMT", "OD_FLAG", "CONTLAW_STATUS", "CONTRACT_STATUS", "APPROVE_ID", "APPROVE_BYCOOPID", "REMARK", "INT_CONTINTTYPE", "INT_CONTINTRATE", "INT_CONTINTTABCODE", "INT_CONTINTINCREASE", "INT_INTSTEPTYPE", "STATUS_DESC", "PERIOD_PAYAMT", "PERIOD_PAYMENT_MAX", "INTMONTH_ARREAR", "LAST_TRANSCONT_NO", "CONTRACT_TIME", "EXPIRECONT_DATE", "EXPENSE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "COMPOUND_DATE", "COMPOUND_PERIOD", "COMPOUNDDUE_DATE", "BUYSHARE_AMT", "RECEIVEPERIOD_FLAG", "PRNCBALBEGIN_AMT", "CONTRACT_TYPE", "SUMINT_LASTYEAR", "LOAN_NO", "INSURANCE_AMT", "INSTYPE_CODE", "INTARREAR_TRANS", "CANCEL_ID", "CANCEL_DATE", "CANCEL_CAUSE", "COMPOUND_PAYTYPE", "COMPOUND_NMLDATE", "PRINCIPAL_TRANSBAL", "INTARREAR_TRANSBAL", "LOANPAYMENTCHG_DATE", "COMPOUND_INTARRPAYMENT", "INSURECOLL_FLAG", "TRNLNTOCOLL_FLAG", "COUNTPAY_FLAG", "PERIOD_PAYINTARR", "TRNFROM_PRNBAL", "TRNFROM_INTBAL", "PAYOUTORD_FLAG", "IDENTIFYCONT_INTRATE", "OBJINTWARRANT_CODE", "CANCEL_PRNBALAMT", "REQCOOP_ID", "INTCERTIFICATE_STATUS", "INTENDORSE_AMT", "LOANCREDIT_AMT", "INTSET_ARREAR", "LOANPAY_CODE", "LOANPAY_BANK", "LOANPAY_BRANCH", "LOANPAY_ACCID", "LOANPAYSPLIT_FLAG", "CONTCCLCAUSE_CODE", "INTCOMPOUND_ARREAR", "REFRAINAVG_FLAG", "UPDATE_BYENTRYID", "UPDATE_BYENTRYIP", "INTSETBEGIN_AMT", "SUBPERIOD_PERCENT", "SUBPERIOD_AMT", "SUBCOUNT_AMT", "SUBPERIOD_PAYMENT", "FINEYEAR_ARREAR", "FINE_ARREAR", "CURRENT_COOPID", "CONTCOUNT", "CONTCOUNT_END", "LASTREC_NO", "LASTLINE_NO", "LASTPAGE_NO", "LOANPASSBOOK_NO", "INTCOMPENSATE_FLAG", "LASTCALFINE_DATE", "CONTRACTINT_TYPE", "CONTINTEXPIRE_DATE", "CONTRACT_INTEREST", "BFFINEYEAR_ARREAR", "BFINTERESTYEAR_ARREAR", "PRTBOOK_FLAG", "PRTCARD_FLAG") VALUES (:COOP_ID, :LOANCONTRACT_NO, :MEMCOOP_ID, :MEMBER_NO, :LOANTYPE_CODE, :LOANOBJECTIVE_CODE, :LOANREQUEST_DOCNO, :LOANREQUEST_AMT, :LOANAPPROVE_DATE, :LOANAPPROVE_AMT, :WITHDRAWABLE_AMT, :PRINCIPAL_BALANCE, :LOANPAYMENT_TYPE, :PERIOD_INSTALLMENT, :PERIOD_PAYMENT, :PERIOD_LASTPAYMENT, :PAYMENT_STATUS, :LAST_PERIODRCV, :LAST_PERIODPAY, :STARTCONT_DATE, :STARTKEEP_DATE, :STARTKEEP_PERIOD, :LASTRECEIVE_DATE, :LASTPAYMENT_DATE, :LASTCALINT_DATE, :LASTKEEPING_DATE, :LASTPROCESS_DATE, :LASTACCESS_DATE, :CLOSECONT_DATE, :PRINCIPAL_ARREAR, :INTEREST_ARREAR, :INTYEAR_ARREAR, :INTEREST_ACCUM, :INTACCUM_LASTYEAR, :PRINCIPAL_RETURN, :INTEREST_RETURN, :PRNPAYMENT_AMT, :INTPAYMENT_AMT, :LAST_STM_NO, :TRANSFER_STATUS, :PRINCIPAL_TRANS, :TRNFROM_CONTNO, :TRNFROM_MEMNO, :NKEEP_PRINCIPAL, :NKEEP_INTEREST, :RKEEP_PRINCIPAL, :RKEEP_INTEREST, :COMPOUND_STATUS, :COMPOUND_INSTALLMENT, :COMPOUND_DUEDATE, :COMPOUND_PAYMENT, :COMPOUND_PAYSTATUS, :MISSPAY_AMT, :OD_FLAG, :CONTLAW_STATUS, :CONTRACT_STATUS, :APPROVE_ID, :APPROVE_BYCOOPID, :REMARK, :INT_CONTINTTYPE, :INT_CONTINTRATE, :INT_CONTINTTABCODE, :INT_CONTINTINCREASE, :INT_INTSTEPTYPE, :STATUS_DESC, :PERIOD_PAYAMT, :PERIOD_PAYMENT_MAX, :INTMONTH_ARREAR, :LAST_TRANSCONT_NO, :CONTRACT_TIME, :EXPIRECONT_DATE, :EXPENSE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :COMPOUND_DATE, :COMPOUND_PERIOD, :COMPOUNDDUE_DATE, :BUYSHARE_AMT, :RECEIVEPERIOD_FLAG, :PRNCBALBEGIN_AMT, :CONTRACT_TYPE, :SUMINT_LASTYEAR, :LOAN_NO, :INSURANCE_AMT, :INSTYPE_CODE, :INTARREAR_TRANS, :CANCEL_ID, :CANCEL_DATE, :CANCEL_CAUSE, :COMPOUND_PAYTYPE, :COMPOUND_NMLDATE, :PRINCIPAL_TRANSBAL, :INTARREAR_TRANSBAL, :LOANPAYMENTCHG_DATE, :p1, :INSURECOLL_FLAG, :TRNLNTOCOLL_FLAG, :COUNTPAY_FLAG, :PERIOD_PAYINTARR, :TRNFROM_PRNBAL, :TRNFROM_INTBAL, :PAYOUTORD_FLAG, :IDENTIFYCONT_INTRATE, :OBJINTWARRANT_CODE, :CANCEL_PRNBALAMT, :REQCOOP_ID, :INTCERTIFICATE_STATUS, :INTENDORSE_AMT, :LOANCREDIT_AMT, :INTSET_ARREAR, :LOANPAY_CODE, :LOANPAY_BANK, :LOANPAY_BRANCH, :LOANPAY_ACCID, :LOANPAYSPLIT_FLAG, :CONTCCLCAUSE_CODE, :INTCOMPOUND_ARREAR, :REFRAINAVG_FLAG, :UPDATE_BYENTRYID, :UPDATE_BYENTRYIP, :INTSETBEGIN_AMT, :SUBPERIOD_PERCENT, :SUBPERIOD_AMT, :SUBCOUNT_AMT, :SUBPERIOD_PAYMENT, :FINEYEAR_ARREAR, :FINE_ARREAR, :CURRENT_COOPID, :CONTCOUNT, :CONTCOUNT_END, :LASTREC_NO, :LASTLINE_NO, :LASTPAGE_NO, :LOANPASSBOOK_NO, :INTCOMPENSATE_FLAG, :LASTCALFINE_DATE, :CONTRACTINT_TYPE, :CONTINTEXPIRE_DATE, :CONTRACT_INTEREST, :BFFINEYEAR_ARREAR, :BFINTERESTYEAR_ARREAR, :PRTBOOK_FLAG, :PRTCARD_FLAG) SELECT COOP_ID, LOANCONTRACT_NO, MEMCOOP_ID, MEMBER_NO, LOANTYPE_CODE, LOANOBJECTIVE_CODE, LOANREQUEST_DOCNO, LOANREQUEST_AMT, LOANAPPROVE_DATE, LOANAPPROVE_AMT, WITHDRAWABLE_AMT, PRINCIPAL_BALANCE, LOANPAYMENT_TYPE, PERIOD_INSTALLMENT, PERIOD_PAYMENT, PERIOD_LASTPAYMENT, PAYMENT_STATUS, LAST_PERIODRCV, LAST_PERIODPAY, STARTCONT_DATE, STARTKEEP_DATE, STARTKEEP_PERIOD, LASTRECEIVE_DATE, LASTPAYMENT_DATE, LASTCALINT_DATE, LASTKEEPING_DATE, LASTPROCESS_DATE, LASTACCESS_DATE, CLOSECONT_DATE, PRINCIPAL_ARREAR, INTEREST_ARREAR, INTYEAR_ARREAR, INTEREST_ACCUM, INTACCUM_LASTYEAR, PRINCIPAL_RETURN, INTEREST_RETURN, PRNPAYMENT_AMT, INTPAYMENT_AMT, LAST_STM_NO, TRANSFER_STATUS, PRINCIPAL_TRANS, TRNFROM_CONTNO, TRNFROM_MEMNO, NKEEP_PRINCIPAL, NKEEP_INTEREST, RKEEP_PRINCIPAL, RKEEP_INTEREST, COMPOUND_STATUS, COMPOUND_INSTALLMENT, COMPOUND_DUEDATE, COMPOUND_PAYMENT, COMPOUND_PAYSTATUS, MISSPAY_AMT, OD_FLAG, CONTLAW_STATUS, CONTRACT_STATUS, APPROVE_ID, APPROVE_BYCOOPID, REMARK, INT_CONTINTTYPE, INT_CONTINTRATE, INT_CONTINTTABCODE, INT_CONTINTINCREASE, INT_INTSTEPTYPE, STATUS_DESC, PERIOD_PAYAMT, PERIOD_PAYMENT_MAX, INTMONTH_ARREAR, LAST_TRANSCONT_NO, CONTRACT_TIME, EXPIRECONT_DATE, EXPENSE_CODE, EXPENSE_BANK, EXPENSE_BRANCH, EXPENSE_ACCID, COMPOUND_DATE, COMPOUND_PERIOD, COMPOUNDDUE_DATE, BUYSHARE_AMT, RECEIVEPERIOD_FLAG, PRNCBALBEGIN_AMT, CONTRACT_TYPE, SUMINT_LASTYEAR, LOAN_NO, INSURANCE_AMT, INSTYPE_CODE, INTARREAR_TRANS, CANCEL_ID, CANCEL_DATE, CANCEL_CAUSE, COMPOUND_PAYTYPE, COMPOUND_NMLDATE, PRINCIPAL_TRANSBAL, INTARREAR_TRANSBAL, LOANPAYMENTCHG_DATE, COMPOUND_INTARRPAYMENT, INSURECOLL_FLAG, TRNLNTOCOLL_FLAG, COUNTPAY_FLAG, PERIOD_PAYINTARR, TRNFROM_PRNBAL, TRNFROM_INTBAL, PAYOUTORD_FLAG, IDENTIFYCONT_INTRATE, OBJINTWARRANT_CODE, CANCEL_PRNBALAMT, REQCOOP_ID, INTCERTIFICATE_STATUS, INTENDORSE_AMT, LOANCREDIT_AMT, INTSET_ARREAR, LOANPAY_CODE, LOANPAY_BANK, LOANPAY_BRANCH, LOANPAY_ACCID, LOANPAYSPLIT_FLAG, CONTCCLCAUSE_CODE, INTCOMPOUND_ARREAR, REFRAINAVG_FLAG, UPDATE_BYENTRYID, UPDATE_BYENTRYIP, INTSETBEGIN_AMT, SUBPERIOD_PERCENT, SUBPERIOD_AMT, SUBCOUNT_AMT, SUBPERIOD_PAYMENT, FINEYEAR_ARREAR, FINE_ARREAR, CURRENT_COOPID, CONTCOUNT, CONTCOUNT_END, LASTREC_NO, LASTLINE_NO, LASTPAGE_NO, LOANPASSBOOK_NO, INTCOMPENSATE_FLAG, LASTCALFINE_DATE, CONTRACTINT_TYPE, CONTINTEXPIRE_DATE, CONTRACT_INTEREST, BFFINEYEAR_ARREAR, BFINTERESTYEAR_ARREAR, PRTBOOK_FLAG, PRTCARD_FLAG FROM LNCONTMASTER UPDATE "LNCONTMASTER" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "LOANTYPE_CODE" = :LOANTYPE_CODE, "LOANOBJECTIVE_CODE" = :LOANOBJECTIVE_CODE, "LOANREQUEST_DOCNO" = :LOANREQUEST_DOCNO, "LOANREQUEST_AMT" = :LOANREQUEST_AMT, "LOANAPPROVE_DATE" = :LOANAPPROVE_DATE, "LOANAPPROVE_AMT" = :LOANAPPROVE_AMT, "WITHDRAWABLE_AMT" = :WITHDRAWABLE_AMT, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE, "LOANPAYMENT_TYPE" = :LOANPAYMENT_TYPE, "PERIOD_INSTALLMENT" = :PERIOD_INSTALLMENT, "PERIOD_PAYMENT" = :PERIOD_PAYMENT, "PERIOD_LASTPAYMENT" = :PERIOD_LASTPAYMENT, "PAYMENT_STATUS" = :PAYMENT_STATUS, "LAST_PERIODRCV" = :LAST_PERIODRCV, "LAST_PERIODPAY" = :LAST_PERIODPAY, "STARTCONT_DATE" = :STARTCONT_DATE, "STARTKEEP_DATE" = :STARTKEEP_DATE, "STARTKEEP_PERIOD" = :STARTKEEP_PERIOD, "LASTRECEIVE_DATE" = :LASTRECEIVE_DATE, "LASTPAYMENT_DATE" = :LASTPAYMENT_DATE, "LASTCALINT_DATE" = :LASTCALINT_DATE, "LASTKEEPING_DATE" = :LASTKEEPING_DATE, "LASTPROCESS_DATE" = :LASTPROCESS_DATE, "LASTACCESS_DATE" = :LASTACCESS_DATE, "CLOSECONT_DATE" = :CLOSECONT_DATE, "PRINCIPAL_ARREAR" = :PRINCIPAL_ARREAR, "INTEREST_ARREAR" = :INTEREST_ARREAR, "INTYEAR_ARREAR" = :INTYEAR_ARREAR, "INTEREST_ACCUM" = :INTEREST_ACCUM, "INTACCUM_LASTYEAR" = :INTACCUM_LASTYEAR, "PRINCIPAL_RETURN" = :PRINCIPAL_RETURN, "INTEREST_RETURN" = :INTEREST_RETURN, "PRNPAYMENT_AMT" = :PRNPAYMENT_AMT, "INTPAYMENT_AMT" = :INTPAYMENT_AMT, "LAST_STM_NO" = :LAST_STM_NO, "TRANSFER_STATUS" = :TRANSFER_STATUS, "PRINCIPAL_TRANS" = :PRINCIPAL_TRANS, "TRNFROM_CONTNO" = :TRNFROM_CONTNO, "TRNFROM_MEMNO" = :TRNFROM_MEMNO, "NKEEP_PRINCIPAL" = :NKEEP_PRINCIPAL, "NKEEP_INTEREST" = :NKEEP_INTEREST, "RKEEP_PRINCIPAL" = :RKEEP_PRINCIPAL, "RKEEP_INTEREST" = :RKEEP_INTEREST, "COMPOUND_STATUS" = :COMPOUND_STATUS, "COMPOUND_INSTALLMENT" = :COMPOUND_INSTALLMENT, "COMPOUND_DUEDATE" = :COMPOUND_DUEDATE, "COMPOUND_PAYMENT" = :COMPOUND_PAYMENT, "COMPOUND_PAYSTATUS" = :COMPOUND_PAYSTATUS, "MISSPAY_AMT" = :MISSPAY_AMT, "OD_FLAG" = :OD_FLAG, "CONTLAW_STATUS" = :CONTLAW_STATUS, "CONTRACT_STATUS" = :CONTRACT_STATUS, "APPROVE_ID" = :APPROVE_ID, "APPROVE_BYCOOPID" = :APPROVE_BYCOOPID, "REMARK" = :REMARK, "INT_CONTINTTYPE" = :INT_CONTINTTYPE, "INT_CONTINTRATE" = :INT_CONTINTRATE, "INT_CONTINTTABCODE" = :INT_CONTINTTABCODE, "INT_CONTINTINCREASE" = :INT_CONTINTINCREASE, "INT_INTSTEPTYPE" = :INT_INTSTEPTYPE, "STATUS_DESC" = :STATUS_DESC, "PERIOD_PAYAMT" = :PERIOD_PAYAMT, "PERIOD_PAYMENT_MAX" = :PERIOD_PAYMENT_MAX, "INTMONTH_ARREAR" = :INTMONTH_ARREAR, "LAST_TRANSCONT_NO" = :LAST_TRANSCONT_NO, "CONTRACT_TIME" = :CONTRACT_TIME, "EXPIRECONT_DATE" = :EXPIRECONT_DATE, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "COMPOUND_DATE" = :COMPOUND_DATE, "COMPOUND_PERIOD" = :COMPOUND_PERIOD, "COMPOUNDDUE_DATE" = :COMPOUNDDUE_DATE, "BUYSHARE_AMT" = :BUYSHARE_AMT, "RECEIVEPERIOD_FLAG" = :RECEIVEPERIOD_FLAG, "PRNCBALBEGIN_AMT" = :PRNCBALBEGIN_AMT, "CONTRACT_TYPE" = :CONTRACT_TYPE, "SUMINT_LASTYEAR" = :SUMINT_LASTYEAR, "LOAN_NO" = :LOAN_NO, "INSURANCE_AMT" = :INSURANCE_AMT, "INSTYPE_CODE" = :INSTYPE_CODE, "INTARREAR_TRANS" = :INTARREAR_TRANS, "CANCEL_ID" = :CANCEL_ID, "CANCEL_DATE" = :CANCEL_DATE, "CANCEL_CAUSE" = :CANCEL_CAUSE, "COMPOUND_PAYTYPE" = :COMPOUND_PAYTYPE, "COMPOUND_NMLDATE" = :COMPOUND_NMLDATE, "PRINCIPAL_TRANSBAL" = :PRINCIPAL_TRANSBAL, "INTARREAR_TRANSBAL" = :INTARREAR_TRANSBAL, "LOANPAYMENTCHG_DATE" = :LOANPAYMENTCHG_DATE, "COMPOUND_INTARRPAYMENT" = :p1, "INSURECOLL_FLAG" = :INSURECOLL_FLAG, "TRNLNTOCOLL_FLAG" = :TRNLNTOCOLL_FLAG, "COUNTPAY_FLAG" = :COUNTPAY_FLAG, "PERIOD_PAYINTARR" = :PERIOD_PAYINTARR, "TRNFROM_PRNBAL" = :TRNFROM_PRNBAL, "TRNFROM_INTBAL" = :TRNFROM_INTBAL, "PAYOUTORD_FLAG" = :PAYOUTORD_FLAG, "IDENTIFYCONT_INTRATE" = :IDENTIFYCONT_INTRATE, "OBJINTWARRANT_CODE" = :OBJINTWARRANT_CODE, "CANCEL_PRNBALAMT" = :CANCEL_PRNBALAMT, "REQCOOP_ID" = :REQCOOP_ID, "INTCERTIFICATE_STATUS" = :INTCERTIFICATE_STATUS, "INTENDORSE_AMT" = :INTENDORSE_AMT, "LOANCREDIT_AMT" = :LOANCREDIT_AMT, "INTSET_ARREAR" = :INTSET_ARREAR, "LOANPAY_CODE" = :LOANPAY_CODE, "LOANPAY_BANK" = :LOANPAY_BANK, "LOANPAY_BRANCH" = :LOANPAY_BRANCH, "LOANPAY_ACCID" = :LOANPAY_ACCID, "LOANPAYSPLIT_FLAG" = :LOANPAYSPLIT_FLAG, "CONTCCLCAUSE_CODE" = :CONTCCLCAUSE_CODE, "INTCOMPOUND_ARREAR" = :INTCOMPOUND_ARREAR, "REFRAINAVG_FLAG" = :REFRAINAVG_FLAG, "UPDATE_BYENTRYID" = :UPDATE_BYENTRYID, "UPDATE_BYENTRYIP" = :UPDATE_BYENTRYIP, "INTSETBEGIN_AMT" = :INTSETBEGIN_AMT, "SUBPERIOD_PERCENT" = :SUBPERIOD_PERCENT, "SUBPERIOD_AMT" = :SUBPERIOD_AMT, "SUBCOUNT_AMT" = :SUBCOUNT_AMT, "SUBPERIOD_PAYMENT" = :SUBPERIOD_PAYMENT, "FINEYEAR_ARREAR" = :FINEYEAR_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "CURRENT_COOPID" = :CURRENT_COOPID, "CONTCOUNT" = :CONTCOUNT, "CONTCOUNT_END" = :CONTCOUNT_END, "LASTREC_NO" = :LASTREC_NO, "LASTLINE_NO" = :LASTLINE_NO, "LASTPAGE_NO" = :LASTPAGE_NO, "LOANPASSBOOK_NO" = :LOANPASSBOOK_NO, "INTCOMPENSATE_FLAG" = :INTCOMPENSATE_FLAG, "LASTCALFINE_DATE" = :LASTCALFINE_DATE, "CONTRACTINT_TYPE" = :CONTRACTINT_TYPE, "CONTINTEXPIRE_DATE" = :CONTINTEXPIRE_DATE, "CONTRACT_INTEREST" = :CONTRACT_INTEREST, "BFFINEYEAR_ARREAR" = :BFFINEYEAR_ARREAR, "BFINTERESTYEAR_ARREAR" = :BFINTERESTYEAR_ARREAR, "PRTBOOK_FLAG" = :PRTBOOK_FLAG, "PRTCARD_FLAG" = :PRTCARD_FLAG WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO))