DELETE FROM "LNLAWMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO)) INSERT INTO "LNLAWMASTER" ("COOP_ID", "LOANCONTRACT_NO", "MEMCOOP_ID", "MEMBER_NO", "LOANTYPE_CODE", "LOANOBJECTIVE_CODE", "LOANREQUEST_DOCNO", "LOANREQUEST_AMT", "LOANAPPROVE_DATE", "LOANAPPROVE_AMT", "WITHDRAWABLE_AMT", "PRINCIPAL_BALANCE", "PRINCIPAL_CALINTAMT", "PRINCIPAL_FIXAMT", "LOANPAYMENT_TYPE", "PERIOD_INSTALLMENT", "PERIOD_PAYMENT", "RED_DOCNO", "BLACK_DOCNO", "REF_CONTRACTNO", "INT_RATE", "FINE_RATE", "PERIOD_LASTPAYMENT", "PAYMENT_STATUS", "LAST_PERIODPAY", "STARTCONT_DATE", "LASTRECEIVE_DATE", "LASTPAYMENT_DATE", "LASTCALINT_DATE", "LASTPROCESS_DATE", "LASTACCESS_DATE", "CLOSECONT_DATE", "PRINCIPAL_ARREAR", "INTEREST_ARREAR", "INTYEAR_ARREAR", "INTEREST_ACCUM", "INTACCUM_LASTYEAR", "PRINCIPAL_RETURN", "INTEREST_RETURN", "LAST_STM_NO", "OD_FLAG", "CONTRACT_STATUS", "APPROVE_ID", "APPROVE_BYCOOPID", "REMARK", "PERIOD_PAYAMT", "PERIOD_PAYMENT_MAX", "EXPIRECONT_DATE", "CANCEL_ID", "CANCEL_DATE", "CANCEL_CAUSE", "FINEYEAR_ARREAR", "FINE_ARREAR", "LASTREC_NO", "LASTLINE_NO", "LASTPAGE_NO", "LASTCALFINE_DATE", "CONTRACT_INTEREST", "BFFINEYEAR_ARREAR", "BFINTERESTYEAR_ARREAR", "PRTBOOK_FLAG", "PRTCARD_FLAG", "BFPRINCIPALYEAR_ARREAR", "LASTREC_NO_CARD", "LASTLINE_NO_CARD", "LASTPAGE_NO_CARD") 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, :PRINCIPAL_CALINTAMT, :PRINCIPAL_FIXAMT, :LOANPAYMENT_TYPE, :PERIOD_INSTALLMENT, :PERIOD_PAYMENT, :RED_DOCNO, :BLACK_DOCNO, :REF_CONTRACTNO, :INT_RATE, :FINE_RATE, :PERIOD_LASTPAYMENT, :PAYMENT_STATUS, :LAST_PERIODPAY, :STARTCONT_DATE, :LASTRECEIVE_DATE, :LASTPAYMENT_DATE, :LASTCALINT_DATE, :LASTPROCESS_DATE, :LASTACCESS_DATE, :CLOSECONT_DATE, :PRINCIPAL_ARREAR, :INTEREST_ARREAR, :INTYEAR_ARREAR, :INTEREST_ACCUM, :INTACCUM_LASTYEAR, :PRINCIPAL_RETURN, :INTEREST_RETURN, :LAST_STM_NO, :OD_FLAG, :CONTRACT_STATUS, :APPROVE_ID, :APPROVE_BYCOOPID, :REMARK, :PERIOD_PAYAMT, :PERIOD_PAYMENT_MAX, :EXPIRECONT_DATE, :CANCEL_ID, :CANCEL_DATE, :CANCEL_CAUSE, :FINEYEAR_ARREAR, :FINE_ARREAR, :LASTREC_NO, :LASTLINE_NO, :LASTPAGE_NO, :LASTCALFINE_DATE, :CONTRACT_INTEREST, :BFFINEYEAR_ARREAR, :BFINTERESTYEAR_ARREAR, :PRTBOOK_FLAG, :PRTCARD_FLAG, :p1, :LASTREC_NO_CARD, :LASTLINE_NO_CARD, :LASTPAGE_NO_CARD) select * from lnlawmaster UPDATE "LNLAWMASTER" 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, "PRINCIPAL_CALINTAMT" = :PRINCIPAL_CALINTAMT, "PRINCIPAL_FIXAMT" = :PRINCIPAL_FIXAMT, "LOANPAYMENT_TYPE" = :LOANPAYMENT_TYPE, "PERIOD_INSTALLMENT" = :PERIOD_INSTALLMENT, "PERIOD_PAYMENT" = :PERIOD_PAYMENT, "RED_DOCNO" = :RED_DOCNO, "BLACK_DOCNO" = :BLACK_DOCNO, "REF_CONTRACTNO" = :REF_CONTRACTNO, "INT_RATE" = :INT_RATE, "FINE_RATE" = :FINE_RATE, "PERIOD_LASTPAYMENT" = :PERIOD_LASTPAYMENT, "PAYMENT_STATUS" = :PAYMENT_STATUS, "LAST_PERIODPAY" = :LAST_PERIODPAY, "STARTCONT_DATE" = :STARTCONT_DATE, "LASTRECEIVE_DATE" = :LASTRECEIVE_DATE, "LASTPAYMENT_DATE" = :LASTPAYMENT_DATE, "LASTCALINT_DATE" = :LASTCALINT_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, "LAST_STM_NO" = :LAST_STM_NO, "OD_FLAG" = :OD_FLAG, "CONTRACT_STATUS" = :CONTRACT_STATUS, "APPROVE_ID" = :APPROVE_ID, "APPROVE_BYCOOPID" = :APPROVE_BYCOOPID, "REMARK" = :REMARK, "PERIOD_PAYAMT" = :PERIOD_PAYAMT, "PERIOD_PAYMENT_MAX" = :PERIOD_PAYMENT_MAX, "EXPIRECONT_DATE" = :EXPIRECONT_DATE, "CANCEL_ID" = :CANCEL_ID, "CANCEL_DATE" = :CANCEL_DATE, "CANCEL_CAUSE" = :CANCEL_CAUSE, "FINEYEAR_ARREAR" = :FINEYEAR_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "LASTREC_NO" = :LASTREC_NO, "LASTLINE_NO" = :LASTLINE_NO, "LASTPAGE_NO" = :LASTPAGE_NO, "LASTCALFINE_DATE" = :LASTCALFINE_DATE, "CONTRACT_INTEREST" = :CONTRACT_INTEREST, "BFFINEYEAR_ARREAR" = :BFFINEYEAR_ARREAR, "BFINTERESTYEAR_ARREAR" = :BFINTERESTYEAR_ARREAR, "PRTBOOK_FLAG" = :PRTBOOK_FLAG, "PRTCARD_FLAG" = :PRTCARD_FLAG, "BFPRINCIPALYEAR_ARREAR" = :p1, "LASTREC_NO_CARD" = :LASTREC_NO_CARD, "LASTLINE_NO_CARD" = :LASTLINE_NO_CARD, "LASTPAGE_NO_CARD" = :LASTPAGE_NO_CARD WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO)) DELETE FROM "LNLAWSTATEMENT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNLAWSTATEMENT" ("COOP_ID", "LOANCONTRACT_NO", "SEQ_NO", "LOANITEMTYPE_CODE", "SLIP_DATE", "OPERATE_DATE", "REF_DOCNO", "REF_SLIPNO", "PRINCIPAL_PAYMENT", "PRINCIPAL_BALANCE", "PRINCIPAL_CALINT", "BFPRINCIPAL_CALINT", "INTEREST_PAYMENT", "FINE_PAYMENT", "BFINTYEARARR_AMT", "INTARR_PAYMENT", "BFINTEREST_ARREAR", "INTEREST_ARREAR", "BFINT_PERIOD", "INTEREST_PERIOD", "BFFINEYEAR_AMT", "FINEARR_PAYMENT", "BFFINE_ARREAR", "FINE_ARREAR", "BFFINE_PERIOD", "FINE_PERIOD", "CALINT_FROM", "CALINT_TO", "CALFINEFROM_DATE", "CALFINETO_DATE", "INTEREST_RETURN", "FINE_RETURN", "MONEYTYPE_CODE", "ITEM_STATUS", "ENTRY_ID", "ENTRY_DATE", "CANCEL_ENTRYID", "CANCEL_DATE", "BFINTRETURN_AMT", "REMARK", "BFPRINCIPAL_ARREAR", "PRINCIPAL_ARREAR", "PRTCARD_FLAG", "PRTBOOK_FLAG") VALUES (:COOP_ID, :LOANCONTRACT_NO, :SEQ_NO, :LOANITEMTYPE_CODE, :SLIP_DATE, :OPERATE_DATE, :REF_DOCNO, :REF_SLIPNO, :PRINCIPAL_PAYMENT, :PRINCIPAL_BALANCE, :PRINCIPAL_CALINT, :BFPRINCIPAL_CALINT, :INTEREST_PAYMENT, :FINE_PAYMENT, :BFINTYEARARR_AMT, :INTARR_PAYMENT, :BFINTEREST_ARREAR, :INTEREST_ARREAR, :BFINT_PERIOD, :INTEREST_PERIOD, :BFFINEYEAR_AMT, :FINEARR_PAYMENT, :BFFINE_ARREAR, :FINE_ARREAR, :BFFINE_PERIOD, :FINE_PERIOD, :CALINT_FROM, :CALINT_TO, :CALFINEFROM_DATE, :CALFINETO_DATE, :INTEREST_RETURN, :FINE_RETURN, :MONEYTYPE_CODE, :ITEM_STATUS, :ENTRY_ID, :ENTRY_DATE, :CANCEL_ENTRYID, :CANCEL_DATE, :BFINTRETURN_AMT, :REMARK, :BFPRINCIPAL_ARREAR, :PRINCIPAL_ARREAR, :PRTCARD_FLAG, :PRTBOOK_FLAG) select * from lnlawstatement UPDATE "LNLAWSTATEMENT" SET "COOP_ID" = :COOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "SEQ_NO" = :SEQ_NO, "LOANITEMTYPE_CODE" = :LOANITEMTYPE_CODE, "SLIP_DATE" = :SLIP_DATE, "OPERATE_DATE" = :OPERATE_DATE, "REF_DOCNO" = :REF_DOCNO, "REF_SLIPNO" = :REF_SLIPNO, "PRINCIPAL_PAYMENT" = :PRINCIPAL_PAYMENT, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE, "PRINCIPAL_CALINT" = :PRINCIPAL_CALINT, "BFPRINCIPAL_CALINT" = :BFPRINCIPAL_CALINT, "INTEREST_PAYMENT" = :INTEREST_PAYMENT, "FINE_PAYMENT" = :FINE_PAYMENT, "BFINTYEARARR_AMT" = :BFINTYEARARR_AMT, "INTARR_PAYMENT" = :INTARR_PAYMENT, "BFINTEREST_ARREAR" = :BFINTEREST_ARREAR, "INTEREST_ARREAR" = :INTEREST_ARREAR, "BFINT_PERIOD" = :BFINT_PERIOD, "INTEREST_PERIOD" = :INTEREST_PERIOD, "BFFINEYEAR_AMT" = :BFFINEYEAR_AMT, "FINEARR_PAYMENT" = :FINEARR_PAYMENT, "BFFINE_ARREAR" = :BFFINE_ARREAR, "FINE_ARREAR" = :FINE_ARREAR, "BFFINE_PERIOD" = :BFFINE_PERIOD, "FINE_PERIOD" = :FINE_PERIOD, "CALINT_FROM" = :CALINT_FROM, "CALINT_TO" = :CALINT_TO, "CALFINEFROM_DATE" = :CALFINEFROM_DATE, "CALFINETO_DATE" = :CALFINETO_DATE, "INTEREST_RETURN" = :INTEREST_RETURN, "FINE_RETURN" = :FINE_RETURN, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "ITEM_STATUS" = :ITEM_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "CANCEL_ENTRYID" = :CANCEL_ENTRYID, "CANCEL_DATE" = :CANCEL_DATE, "BFINTRETURN_AMT" = :BFINTRETURN_AMT, "REMARK" = :REMARK, "BFPRINCIPAL_ARREAR" = :BFPRINCIPAL_ARREAR, "PRINCIPAL_ARREAR" = :PRINCIPAL_ARREAR, "PRTCARD_FLAG" = :PRTCARD_FLAG, "PRTBOOK_FLAG" = :PRTBOOK_FLAG WHERE (("COOP_ID" = :Original_COOP_ID) AND ("LOANCONTRACT_NO" = :Original_LOANCONTRACT_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) select lnnpltrackingcont.*, lncontmaster.principal_balance from lnnpltrackingcont, lncontmaster where ( lnnpltrackingcont.coop_id = lncontmaster.coop_id ) and ( lnnpltrackingcont.loancontract_no = lncontmaster.loancontract_no ) SELECT LNNPLTRACKING.COOP_ID, LNNPLTRACKING.TRACKING_NO, LNNPLTRACKING.MEMCOOP_ID, LNNPLTRACKING.MEMBER_NO, LNNPLTRACKING.TRACKING_DATE, LNNPLTRACKING.TRACKING_STATUS, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.ADDR_NO, MBMEMBMASTER.ADDR_MOO, MBMEMBMASTER.ADDR_SOI, MBMEMBMASTER.ADDR_VILLAGE, MBMEMBMASTER.ADDR_ROAD, MBUCFTAMBOL.TAMBOL_DESC, MBUCFDISTRICT.DISTRICT_DESC, MBUCFPROVINCE.PROVINCE_CODE, MBUCFPROVINCE.PROVINCE_DESC, MBMEMBMASTER.ADDR_POSTCODE, MBMEMBMASTER.ADDR_PHONE, MBMEMBMASTER.ADDR_MOBILEPHONE, MBMEMBMASTER.CARD_PERSON FROM LNNPLTRACKING, MBMEMBMASTER, MBUCFPRENAME, MBUCFPROVINCE, MBUCFDISTRICT, MBUCFTAMBOL WHERE ( LNNPLTRACKING.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNNPLTRACKING.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and ( MBMEMBMASTER.PROVINCE_CODE = MBUCFPROVINCE.PROVINCE_CODE ) and ( MBMEMBMASTER.AMPHUR_CODE = MBUCFDISTRICT.DISTRICT_CODE ) and ( MBMEMBMASTER.TAMBOL_CODE = MBUCFTAMBOL.TAMBOL_CODE )