DELETE FROM "DPDEPTMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("DEPTACCOUNT_NO" = :Original_DEPTACCOUNT_NO)) INSERT INTO "DPDEPTMASTER" ("COOP_ID", "DEPTACCOUNT_NO", "DEPTTYPE_CODE", "MEMCOOP_ID", "MEMBER_NO", "DEPTOPEN_DATE", "DEPTCLOSE_STATUS", "DEPTCLOSE_DATE", "DEPTACCOUNT_NAME", "DEPT_OBJECTIVE", "CHECK_DIGIT", "DEPTPASSBOOK_NO", "CONDFORWITHDRAW", "CONTACT_ADDRESS", "F_TAX_RATE", "TAXPERSONAL_ID", "DEPTMONTH_STATUS", "DEPTMONTH_AMT", "DEPTMONTH_AMT_OLD", "DEPTMONTCHG_DATE", "MONTHINT_STATUS", "MONTHINTPAY_METH", "TRAN_DEPTACC_COOP_ID", "TRAN_DEPTACC_NO", "TRAN_BANKACC_NO", "SPCINT_RATE_STATUS", "SPCINT_RATE", "BEGINBAL", "PRNCBAL", "CHECKPEND_AMT", "SEQUEST_DATE", "LOANGARANTEE_AMT", "SEQUEST_AMOUNT", "SEQUEST_STATUS", "WITHDRAWABLE_AMT", "LASTCALINT_DATE", "ACCUINT_AMT", "INTARREAR_AMT", "ACCUINTPAY_AMT", "ACCUTAXPAY_AMT", "WITHDRAW_COUNT", "RESET_COUNT_DATE", "LASTSTMSEQ_NO", "LASTREC_NO_PB", "LASTPAGE_NO_PB", "LASTLINE_NO_PB", "CHECKBOOK_CODE_PB", "LASTREC_NO_CARD", "LASTPAGE_NO_CARD", "LASTLINE_NO_CARD", "CLOSEMONTH_NO", "DOPERATE_BAL", "LASTACCESS_DATE", "PRNC_NO", "LAST_PROCESS_DATE", "MBEGINBAL", "ACCCONT_TYPE", "MEMBGROUP_CODE", "REMARK", "LASTMOVEMENT_DATE", "PRNBOOK_STATUS", "TAXSPCRATE_STATUS", "SEQUEST_RESON", "DEPTINT_REMAIN", "BOOK_BALANCE", "DEPTACCOUNT_ENAME", "COMPANY_ID", "CONFIRM_STATUS", "BANK_BRANCH", "DEPT_TRANACC_NAME", "BANK_CODE", "DEPT_AMT", "WITH_AMT", "BOOKNORM_FLAG", "DUE_M", "DUE_Y", "DUE_M_FLAG", "EXPENSE_CODE", "EXPENSE_ACCNO", "EXPENSE_BRANCH", "EXPENSE_AMOUNT", "STARTKEEP_DATE", "BOOKCONFIRM_STATUS", "UPDATE_BYENTRYID", "UPDATE_BYENTRYIP", "ATMCARD_ID", "LIMITPRNBAL_FLAG", "LIMITPRNBAL_AMT") VALUES (:COOP_ID, :DEPTACCOUNT_NO, :DEPTTYPE_CODE, :MEMCOOP_ID, :MEMBER_NO, :DEPTOPEN_DATE, :DEPTCLOSE_STATUS, :DEPTCLOSE_DATE, :DEPTACCOUNT_NAME, :DEPT_OBJECTIVE, :CHECK_DIGIT, :DEPTPASSBOOK_NO, :CONDFORWITHDRAW, :CONTACT_ADDRESS, :F_TAX_RATE, :TAXPERSONAL_ID, :DEPTMONTH_STATUS, :DEPTMONTH_AMT, :DEPTMONTH_AMT_OLD, :DEPTMONTCHG_DATE, :MONTHINT_STATUS, :MONTHINTPAY_METH, :TRAN_DEPTACC_COOP_ID, :TRAN_DEPTACC_NO, :TRAN_BANKACC_NO, :SPCINT_RATE_STATUS, :SPCINT_RATE, :BEGINBAL, :PRNCBAL, :CHECKPEND_AMT, :SEQUEST_DATE, :LOANGARANTEE_AMT, :SEQUEST_AMOUNT, :SEQUEST_STATUS, :WITHDRAWABLE_AMT, :LASTCALINT_DATE, :ACCUINT_AMT, :INTARREAR_AMT, :ACCUINTPAY_AMT, :ACCUTAXPAY_AMT, :WITHDRAW_COUNT, :RESET_COUNT_DATE, :LASTSTMSEQ_NO, :LASTREC_NO_PB, :LASTPAGE_NO_PB, :LASTLINE_NO_PB, :CHECKBOOK_CODE_PB, :LASTREC_NO_CARD, :LASTPAGE_NO_CARD, :LASTLINE_NO_CARD, :CLOSEMONTH_NO, :DOPERATE_BAL, :LASTACCESS_DATE, :PRNC_NO, :LAST_PROCESS_DATE, :MBEGINBAL, :ACCCONT_TYPE, :MEMBGROUP_CODE, :REMARK, :LASTMOVEMENT_DATE, :PRNBOOK_STATUS, :TAXSPCRATE_STATUS, :SEQUEST_RESON, :DEPTINT_REMAIN, :BOOK_BALANCE, :DEPTACCOUNT_ENAME, :COMPANY_ID, :CONFIRM_STATUS, :BANK_BRANCH, :DEPT_TRANACC_NAME, :BANK_CODE, :DEPT_AMT, :WITH_AMT, :BOOKNORM_FLAG, :DUE_M, :DUE_Y, :DUE_M_FLAG, :EXPENSE_CODE, :EXPENSE_ACCNO, :EXPENSE_BRANCH, :EXPENSE_AMOUNT, :STARTKEEP_DATE, :BOOKCONFIRM_STATUS, :UPDATE_BYENTRYID, :UPDATE_BYENTRYIP, :ATMCARD_ID, :LIMITPRNBAL_FLAG, :LIMITPRNBAL_AMT) select * from dpdeptmaster UPDATE "DPDEPTMASTER" SET "COOP_ID" = :COOP_ID, "DEPTACCOUNT_NO" = :DEPTACCOUNT_NO, "DEPTTYPE_CODE" = :DEPTTYPE_CODE, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "DEPTOPEN_DATE" = :DEPTOPEN_DATE, "DEPTCLOSE_STATUS" = :DEPTCLOSE_STATUS, "DEPTCLOSE_DATE" = :DEPTCLOSE_DATE, "DEPTACCOUNT_NAME" = :DEPTACCOUNT_NAME, "DEPT_OBJECTIVE" = :DEPT_OBJECTIVE, "CHECK_DIGIT" = :CHECK_DIGIT, "DEPTPASSBOOK_NO" = :DEPTPASSBOOK_NO, "CONDFORWITHDRAW" = :CONDFORWITHDRAW, "CONTACT_ADDRESS" = :CONTACT_ADDRESS, "F_TAX_RATE" = :F_TAX_RATE, "TAXPERSONAL_ID" = :TAXPERSONAL_ID, "DEPTMONTH_STATUS" = :DEPTMONTH_STATUS, "DEPTMONTH_AMT" = :DEPTMONTH_AMT, "DEPTMONTH_AMT_OLD" = :DEPTMONTH_AMT_OLD, "DEPTMONTCHG_DATE" = :DEPTMONTCHG_DATE, "MONTHINT_STATUS" = :MONTHINT_STATUS, "MONTHINTPAY_METH" = :MONTHINTPAY_METH, "TRAN_DEPTACC_COOP_ID" = :TRAN_DEPTACC_COOP_ID, "TRAN_DEPTACC_NO" = :TRAN_DEPTACC_NO, "TRAN_BANKACC_NO" = :TRAN_BANKACC_NO, "SPCINT_RATE_STATUS" = :SPCINT_RATE_STATUS, "SPCINT_RATE" = :SPCINT_RATE, "BEGINBAL" = :BEGINBAL, "PRNCBAL" = :PRNCBAL, "CHECKPEND_AMT" = :CHECKPEND_AMT, "SEQUEST_DATE" = :SEQUEST_DATE, "LOANGARANTEE_AMT" = :LOANGARANTEE_AMT, "SEQUEST_AMOUNT" = :SEQUEST_AMOUNT, "SEQUEST_STATUS" = :SEQUEST_STATUS, "WITHDRAWABLE_AMT" = :WITHDRAWABLE_AMT, "LASTCALINT_DATE" = :LASTCALINT_DATE, "ACCUINT_AMT" = :ACCUINT_AMT, "INTARREAR_AMT" = :INTARREAR_AMT, "ACCUINTPAY_AMT" = :ACCUINTPAY_AMT, "ACCUTAXPAY_AMT" = :ACCUTAXPAY_AMT, "WITHDRAW_COUNT" = :WITHDRAW_COUNT, "RESET_COUNT_DATE" = :RESET_COUNT_DATE, "LASTSTMSEQ_NO" = :LASTSTMSEQ_NO, "LASTREC_NO_PB" = :LASTREC_NO_PB, "LASTPAGE_NO_PB" = :LASTPAGE_NO_PB, "LASTLINE_NO_PB" = :LASTLINE_NO_PB, "CHECKBOOK_CODE_PB" = :CHECKBOOK_CODE_PB, "LASTREC_NO_CARD" = :LASTREC_NO_CARD, "LASTPAGE_NO_CARD" = :LASTPAGE_NO_CARD, "LASTLINE_NO_CARD" = :LASTLINE_NO_CARD, "CLOSEMONTH_NO" = :CLOSEMONTH_NO, "DOPERATE_BAL" = :DOPERATE_BAL, "LASTACCESS_DATE" = :LASTACCESS_DATE, "PRNC_NO" = :PRNC_NO, "LAST_PROCESS_DATE" = :LAST_PROCESS_DATE, "MBEGINBAL" = :MBEGINBAL, "ACCCONT_TYPE" = :ACCCONT_TYPE, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "REMARK" = :REMARK, "LASTMOVEMENT_DATE" = :LASTMOVEMENT_DATE, "PRNBOOK_STATUS" = :PRNBOOK_STATUS, "TAXSPCRATE_STATUS" = :TAXSPCRATE_STATUS, "SEQUEST_RESON" = :SEQUEST_RESON, "DEPTINT_REMAIN" = :DEPTINT_REMAIN, "BOOK_BALANCE" = :BOOK_BALANCE, "DEPTACCOUNT_ENAME" = :DEPTACCOUNT_ENAME, "COMPANY_ID" = :COMPANY_ID, "CONFIRM_STATUS" = :CONFIRM_STATUS, "BANK_BRANCH" = :BANK_BRANCH, "DEPT_TRANACC_NAME" = :DEPT_TRANACC_NAME, "BANK_CODE" = :BANK_CODE, "DEPT_AMT" = :DEPT_AMT, "WITH_AMT" = :WITH_AMT, "BOOKNORM_FLAG" = :BOOKNORM_FLAG, "DUE_M" = :DUE_M, "DUE_Y" = :DUE_Y, "DUE_M_FLAG" = :DUE_M_FLAG, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_ACCNO" = :EXPENSE_ACCNO, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_AMOUNT" = :EXPENSE_AMOUNT, "STARTKEEP_DATE" = :STARTKEEP_DATE, "BOOKCONFIRM_STATUS" = :BOOKCONFIRM_STATUS, "UPDATE_BYENTRYID" = :UPDATE_BYENTRYID, "UPDATE_BYENTRYIP" = :UPDATE_BYENTRYIP, "ATMCARD_ID" = :ATMCARD_ID, "LIMITPRNBAL_FLAG" = :LIMITPRNBAL_FLAG, "LIMITPRNBAL_AMT" = :LIMITPRNBAL_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("DEPTACCOUNT_NO" = :Original_DEPTACCOUNT_NO))