SELECT "LNCONTCOLL"."REF_COLLNO", "LNCONTMASTER"."LOANCONTRACT_NO", "LNCONTMASTER"."MEMBER_NO", "LNCONTMASTER"."LOANTYPE_CODE", "LNCONTMASTER"."LOANAPPROVE_AMT", "LNCONTMASTER"."WITHDRAWABLE_AMT", "LNCONTMASTER"."PRINCIPAL_BALANCE", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "LNLOANTYPE"."PREFIX", "LNCONTCOLL"."COLL_PERCENT", "LNCONTCOLL"."BASE_PERCENT", "LNLOANTYPE"."LOANTYPE_DESC" FROM "LNCONTCOLL", "LNCONTMASTER", "MBMEMBMASTER", "MBUCFPRENAME", "LNLOANTYPE" WHERE ( "LNCONTMASTER"."LOANCONTRACT_NO" = "LNCONTCOLL"."LOANCONTRACT_NO" ) and ( "MBMEMBMASTER"."MEMBER_NO" = "LNCONTMASTER"."MEMBER_NO" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "LNCONTMASTER"."LOANTYPE_CODE" = "LNLOANTYPE"."LOANTYPE_CODE" ) and ( "MBMEMBMASTER"."COOP_ID" = "LNCONTMASTER"."COOP_ID" ) and ( "LNCONTMASTER"."COOP_ID" = "LNCONTCOLL"."COOP_ID" ) and ( "LNCONTMASTER"."COOP_ID" = "LNLOANTYPE"."COOP_ID" ) select lnreqloan.loanrequest_docno, lnreqloan.member_no, lnreqloan.loantype_code, lnreqloan.loanrequest_amt, lnreqloancoll.collactive_amt, lnreqloancoll.collactive_percent, lnreqloancoll.loancolltype_code, lnreqloancoll.collbase_percent, lnloantype.cntmangrtval_flag, lnloantype.mangrtpermgrp_code, mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname from lnreqloan, lnreqloancoll, lnloantype, mbmembmaster, mbucfprename where ( lnreqloancoll.loanrequest_docno = lnreqloan.loanrequest_docno ) and ( lnreqloan.loantype_code = lnloantype.loantype_code ) and ( lnreqloan.member_no = mbmembmaster.member_no ) and ( mbucfprename.prename_code = mbmembmaster.prename_code ) and ( lnreqloan.coop_id = lnreqloancoll.coop_id ) and ( lnreqloan.coop_id = lnloantype.coop_id ) and ( lnreqloan.coop_id = mbmembmaster.coop_id ) and ( ( lnreqloan.loanrequest_status in (8,11) ) and ( lnreqloancoll.ref_collno = :as_refcollno ) and ( lnreqloancoll.loancolltype_code = :as_lncolltype ) ) SELECT MANGRTPERMGRP_CODE, MANGRTPERMGRP_DESC, MANGRTTIME_TYPE, EXPORTRIGTH_FLAG, MEMBER_TYPE FROM LNGRPMANGRTPERM SELECT "MBMEMBMASTER"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBMEMBMASTER"."BIRTH_DATE", "MBMEMBMASTER"."MEMBER_DATE", "MBMEMBMASTER"."SALARY_AMOUNT", "MBMEMBMASTER"."WORK_DATE", "MBMEMBMASTER"."RETRY_DATE", "SHSHAREMASTER"."SHARESTK_AMT", "SHSHAREMASTER"."LAST_PERIOD", "SHSHAREMASTER"."PERIODSHARE_AMT", "SHSHAREMASTER"."PAYMENT_STATUS", "SHSHAREMASTER"."SHAREARREAR_AMT", "SHSHARETYPE"."UNITSHARE_VALUE", "MBUCFMEMBTYPE"."MEMBTYPE_CODE", "MBUCFMEMBTYPE"."MEMBTYPE_DESC", "MBMEMBMASTER"."APPLTYPE_CODE", "MBMEMBMASTER"."MEMBER_TYPE", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME" , "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."RESIGN_STATUS" FROM "MBMEMBMASTER", "MBUCFMEMBGROUP", "SHSHAREMASTER", "SHSHARETYPE", "MBUCFMEMBTYPE", "MBUCFPRENAME" WHERE ( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and ( "SHSHAREMASTER"."MEMBER_NO" = "MBMEMBMASTER"."MEMBER_NO" ) and ( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) and ( "MBMEMBMASTER"."MEMBTYPE_CODE" = "MBUCFMEMBTYPE"."MEMBTYPE_CODE" ) and ( "MBMEMBMASTER"."COOP_ID" = "MBUCFMEMBGROUP"."COOP_ID" ) and ( "MBMEMBMASTER"."COOP_ID" = "SHSHAREMASTER"."COOP_ID" ) and ( "MBMEMBMASTER"."COOP_ID" = "MBUCFMEMBTYPE"."COOP_ID" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "SHSHAREMASTER"."COOP_ID" = "SHSHARETYPE"."COOP_ID" ) SELECT "DPDEPTMASTER"."DEPTACCOUNT_NO", "DPDEPTMASTER"."DEPTTYPE_CODE", "DPDEPTTYPE"."DEPTTYPE_DESC", "DPDEPTMASTER"."MEMBER_NO", "DPDEPTMASTER"."DEPTOPEN_DATE", "DPDEPTMASTER"."DEPTACCOUNT_NAME", "DPDEPTMASTER"."BEGINBAL", "DPDEPTMASTER"."PRNCBAL", "DPDEPTMASTER"."WITHDRAWABLE_AMT", "DPDEPTMASTER"."SEQUEST_AMOUNT", "DPDEPTMASTER"."DEPTCLOSE_DATE", "DPDEPTMASTER"."DEPTCLOSE_STATUS" FROM "DPDEPTMASTER", "DPDEPTTYPE" WHERE ( "DPDEPTTYPE"."DEPTTYPE_CODE" = "DPDEPTMASTER"."DEPTTYPE_CODE" ) and ( "DPDEPTMASTER"."COOP_ID" = "DPDEPTTYPE"."COOP_ID" ) DELETE FROM "LNCOLLMASTER" WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNCOLLMASTER" ("COLLMAST_NO", "MEMBER_NO", "COLLMAST_REFNO", "COLLMASTTYPE_CODE", "COLLMAST_DESC", "LANDESTIMATE_AMT", "HOUSEESTIMATE_AMT", "ESTIMATE_PRICE", "MORTGAGE_PRICE", "MORTGAGE_DATE", "EXPIRE_DATE", "REDEEM_FLAG", "REDEEM_DATE", "REMARK", "LAND_NO", "SURVEY_NO", "BOOK_NO", "PAGE_NO", "GROUP_NO", "COOP_ID") VALUES (:COLLMAST_NO, :MEMBER_NO, :COLLMAST_REFNO, :COLLMASTTYPE_CODE, :COLLMAST_DESC, :LANDESTIMATE_AMT, :HOUSEESTIMATE_AMT, :ESTIMATE_PRICE, :MORTGAGE_PRICE, :MORTGAGE_DATE, :EXPIRE_DATE, :REDEEM_FLAG, :REDEEM_DATE, :REMARK, :LAND_NO, :SURVEY_NO, :BOOK_NO, :PAGE_NO, :GROUP_NO, :COOP_ID) SELECT COLLMAST_NO, MEMBER_NO, COLLMAST_REFNO, COLLMASTTYPE_CODE, COLLMAST_DESC, LANDESTIMATE_AMT, HOUSEESTIMATE_AMT, ESTIMATE_PRICE, MORTGAGE_PRICE, MORTGAGE_DATE, EXPIRE_DATE, REDEEM_FLAG, REDEEM_DATE, REMARK, LAND_NO, SURVEY_NO, BOOK_NO, PAGE_NO, GROUP_NO, COOP_ID FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "COLLMAST_NO" = :COLLMAST_NO, "MEMBER_NO" = :MEMBER_NO, "COLLMAST_REFNO" = :COLLMAST_REFNO, "COLLMASTTYPE_CODE" = :COLLMASTTYPE_CODE, "COLLMAST_DESC" = :COLLMAST_DESC, "LANDESTIMATE_AMT" = :LANDESTIMATE_AMT, "HOUSEESTIMATE_AMT" = :HOUSEESTIMATE_AMT, "ESTIMATE_PRICE" = :ESTIMATE_PRICE, "MORTGAGE_PRICE" = :MORTGAGE_PRICE, "MORTGAGE_DATE" = :MORTGAGE_DATE, "EXPIRE_DATE" = :EXPIRE_DATE, "REDEEM_FLAG" = :REDEEM_FLAG, "REDEEM_DATE" = :REDEEM_DATE, "REMARK" = :REMARK, "LAND_NO" = :LAND_NO, "SURVEY_NO" = :SURVEY_NO, "BOOK_NO" = :BOOK_NO, "PAGE_NO" = :PAGE_NO, "GROUP_NO" = :GROUP_NO, "COOP_ID" = :COOP_ID WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) SELECT "LNCOLLMASTMEMCO"."COLLMAST_NO", "LNCOLLMASTMEMCO"."MEMCO_NO", "LNCOLLMASTMEMCO"."COLLMASTMAIN_FLAG", "MBUCFPRENAME"."PRENAME_SHORT", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME" FROM "LNCOLLMASTMEMCO", "MBMEMBMASTER", "MBUCFPRENAME" WHERE ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "LNCOLLMASTMEMCO"."MEMCO_NO" = "MBMEMBMASTER"."MEMBER_NO" ) DELETE FROM "MBMEMBMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO)) INSERT INTO "MBMEMBMASTER" ("COOP_ID", "MEMBER_NO", "PRENAME_CODE", "MEMB_NAME", "MEMB_SURNAME", "MEMB_ENAME", "MEMB_ESURNAME", "MEMBGROUP_CODE", "MEMBTYPE_CODE", "SIGNATURE_NAME", "BIRTH_DATE", "MEMBER_DATE", "DEAD_STATUS", "DEAD_DATE", "RETRY_STATUS", "RETRY_DATE", "RESIGN_STATUS", "RESIGN_DATE", "RESIGNCAUSE_CODE", "CLOSE_DATE", "SEX", "MARIAGE_STATUS", "ADDR_NO", "ADDR_MOO", "ADDR_SOI", "ADDR_VILLAGE", "ADDR_ROAD", "TAMBOL_CODE", "AMPHUR_CODE", "PROVINCE_CODE", "ADDR_POSTCODE", "ADDR_PHONE", "ADDR_MOBILEPHONE", "CURRADDR_NO", "CURRADDR_MOO", "CURRADDR_SOI", "CURRADDR_VILLAGE", "CURRADDR_ROAD", "CURRTAMBOL_CODE", "CURRAMPHUR_CODE", "CURRPROVINCE_CODE", "CURRADDR_POSTCODE", "CURRADDR_PHONE", "ADDR_EMAIL", "MEM_TELWORK", "MATE_NAME", "CARD_PERSON", "CARD_TAX", "MEMBER_CARD", "WORK_DATE", "POSITION_CODE", "POSITION_DESC", "LEVEL_CODE", "DEPARTMENT_CODE", "SALARY_AMOUNT", "SALARY_ID", "FIRSTFEE_STATUS", "MEMBER_STATUS", "MEMREF_FLAG", "MEMBER_REF", "KLONGTOON_FLAG", "HAVE_GAIN", "PAUSEKEEP_FLAG", "PAUSEKEEP_DATE", "FIRST_KEEPDATE", "LNPROVIDENTFUND_FLAG", "ALLOWLOAN_FLAG", "DROPGURANTEE_FLAG", "TRANSRIGHT_FLAG", "DROPLOANALL_FLAG", "DIVIDEND_FLAG", "AVERAGE_FLAG", "SEQUEST_DIVAVG", "REMARK", "MEMBER_TYPE", "DIVAVGSHOW_FLAG", "PRINTRECEIPTADDR_TYPE", "WEB_CODE", "IVR_CODE", "MEMBTRANS_DATE", "ACCUM_INTEREST", "SUMINT_LASTYEAR", "MISSPAYLON_AMT", "MISSPAYSHR_AMT", "MATE_MBFLAG", "MATE_MBNO", "EXPENSE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "APPL_DOCNO", "APPLTYPE_CODE", "COMPOUNDKEEP_GROUP", "COMPOUNDKEEP_DATE", "COMPOUNDKEEP_STATUS", "COMPOUNDKEEP_PERIOD", "COMPOUNDKEEP_DUEDATE", "COMPOUNDKEEP_NMLDATE", "INSURANCE_FLAG", "CREMATION_STATUS", "NATIONALITY", "INCOMEETC_AMT", "FATHER_NAME", "MATHER_NAME", "SUBGROUP_CODE", "EMP_TYPE", "MATEADDR_NO", "MATEADDR_MOO", "MATEADDR_VILLAGE", "MATEADDR_SOI", "MATEADDR_ROAD", "MATETAMBOL_CODE", "MATEAMPHUR_CODE", "MATEPROVINCE_CODE", "MATEADDR_POSTCODE", "MATEADDR_PHONE", "LASTKEEP_DATE", "MATE_CARDPERSON", "MATE_SALARYID", "UPDATE_BYENTRYID", "UPDATE_BYENTRYIP", "TAMBOL_DESC", "KEEPSAL_FLAG", "UPDATE_BYLASTDOC", "REMEMB_FLAG") VALUES (:COOP_ID, :MEMBER_NO, :PRENAME_CODE, :MEMB_NAME, :MEMB_SURNAME, :MEMB_ENAME, :MEMB_ESURNAME, :MEMBGROUP_CODE, :MEMBTYPE_CODE, :SIGNATURE_NAME, :BIRTH_DATE, :MEMBER_DATE, :DEAD_STATUS, :DEAD_DATE, :RETRY_STATUS, :RETRY_DATE, :RESIGN_STATUS, :RESIGN_DATE, :RESIGNCAUSE_CODE, :CLOSE_DATE, :SEX, :MARIAGE_STATUS, :ADDR_NO, :ADDR_MOO, :ADDR_SOI, :ADDR_VILLAGE, :ADDR_ROAD, :TAMBOL_CODE, :AMPHUR_CODE, :PROVINCE_CODE, :ADDR_POSTCODE, :ADDR_PHONE, :ADDR_MOBILEPHONE, :CURRADDR_NO, :CURRADDR_MOO, :CURRADDR_SOI, :CURRADDR_VILLAGE, :CURRADDR_ROAD, :CURRTAMBOL_CODE, :CURRAMPHUR_CODE, :CURRPROVINCE_CODE, :CURRADDR_POSTCODE, :CURRADDR_PHONE, :ADDR_EMAIL, :MEM_TELWORK, :MATE_NAME, :CARD_PERSON, :CARD_TAX, :MEMBER_CARD, :WORK_DATE, :POSITION_CODE, :POSITION_DESC, :LEVEL_CODE, :DEPARTMENT_CODE, :SALARY_AMOUNT, :SALARY_ID, :FIRSTFEE_STATUS, :MEMBER_STATUS, :MEMREF_FLAG, :MEMBER_REF, :KLONGTOON_FLAG, :HAVE_GAIN, :PAUSEKEEP_FLAG, :PAUSEKEEP_DATE, :FIRST_KEEPDATE, :LNPROVIDENTFUND_FLAG, :ALLOWLOAN_FLAG, :DROPGURANTEE_FLAG, :TRANSRIGHT_FLAG, :DROPLOANALL_FLAG, :DIVIDEND_FLAG, :AVERAGE_FLAG, :SEQUEST_DIVAVG, :REMARK, :MEMBER_TYPE, :DIVAVGSHOW_FLAG, :PRINTRECEIPTADDR_TYPE, :WEB_CODE, :IVR_CODE, :MEMBTRANS_DATE, :ACCUM_INTEREST, :SUMINT_LASTYEAR, :MISSPAYLON_AMT, :MISSPAYSHR_AMT, :MATE_MBFLAG, :MATE_MBNO, :EXPENSE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :APPL_DOCNO, :APPLTYPE_CODE, :COMPOUNDKEEP_GROUP, :COMPOUNDKEEP_DATE, :COMPOUNDKEEP_STATUS, :COMPOUNDKEEP_PERIOD, :COMPOUNDKEEP_DUEDATE, :COMPOUNDKEEP_NMLDATE, :INSURANCE_FLAG, :CREMATION_STATUS, :NATIONALITY, :INCOMEETC_AMT, :FATHER_NAME, :MATHER_NAME, :SUBGROUP_CODE, :EMP_TYPE, :MATEADDR_NO, :MATEADDR_MOO, :MATEADDR_VILLAGE, :MATEADDR_SOI, :MATEADDR_ROAD, :MATETAMBOL_CODE, :MATEAMPHUR_CODE, :MATEPROVINCE_CODE, :MATEADDR_POSTCODE, :MATEADDR_PHONE, :LASTKEEP_DATE, :MATE_CARDPERSON, :MATE_SALARYID, :UPDATE_BYENTRYID, :UPDATE_BYENTRYIP, :TAMBOL_DESC, :KEEPSAL_FLAG, :UPDATE_BYLASTDOC, :REMEMB_FLAG) SELECT COOP_ID, MEMBER_NO, PRENAME_CODE, MEMB_NAME, MEMB_SURNAME, MEMB_ENAME, MEMB_ESURNAME, MEMBGROUP_CODE, MEMBTYPE_CODE, SIGNATURE_NAME, BIRTH_DATE, MEMBER_DATE, DEAD_STATUS, DEAD_DATE, RETRY_STATUS, RETRY_DATE, RESIGN_STATUS, RESIGN_DATE, RESIGNCAUSE_CODE, CLOSE_DATE, SEX, MARIAGE_STATUS, ADDR_NO, ADDR_MOO, ADDR_SOI, ADDR_VILLAGE, ADDR_ROAD, TAMBOL_CODE, AMPHUR_CODE, PROVINCE_CODE, ADDR_POSTCODE, ADDR_PHONE, ADDR_MOBILEPHONE, CURRADDR_NO, CURRADDR_MOO, CURRADDR_SOI, CURRADDR_VILLAGE, CURRADDR_ROAD, CURRTAMBOL_CODE, CURRAMPHUR_CODE, CURRPROVINCE_CODE, CURRADDR_POSTCODE, CURRADDR_PHONE, ADDR_EMAIL, MEM_TELWORK, MATE_NAME, CARD_PERSON, CARD_TAX, MEMBER_CARD, WORK_DATE, POSITION_CODE, POSITION_DESC, LEVEL_CODE, DEPARTMENT_CODE, SALARY_AMOUNT, SALARY_ID, FIRSTFEE_STATUS, MEMBER_STATUS, MEMREF_FLAG, MEMBER_REF, KLONGTOON_FLAG, HAVE_GAIN, PAUSEKEEP_FLAG, PAUSEKEEP_DATE, FIRST_KEEPDATE, LNPROVIDENTFUND_FLAG, ALLOWLOAN_FLAG, DROPGURANTEE_FLAG, TRANSRIGHT_FLAG, DROPLOANALL_FLAG, DIVIDEND_FLAG, AVERAGE_FLAG, SEQUEST_DIVAVG, REMARK, MEMBER_TYPE, DIVAVGSHOW_FLAG, PRINTRECEIPTADDR_TYPE, WEB_CODE, IVR_CODE, MEMBTRANS_DATE, ACCUM_INTEREST, SUMINT_LASTYEAR, MISSPAYLON_AMT, MISSPAYSHR_AMT, MATE_MBFLAG, MATE_MBNO, EXPENSE_CODE, EXPENSE_BANK, EXPENSE_BRANCH, EXPENSE_ACCID, APPL_DOCNO, APPLTYPE_CODE, COMPOUNDKEEP_GROUP, COMPOUNDKEEP_DATE, COMPOUNDKEEP_STATUS, COMPOUNDKEEP_PERIOD, COMPOUNDKEEP_DUEDATE, COMPOUNDKEEP_NMLDATE, INSURANCE_FLAG, CREMATION_STATUS, NATIONALITY, INCOMEETC_AMT, FATHER_NAME, MATHER_NAME, SUBGROUP_CODE, EMP_TYPE, MATEADDR_NO, MATEADDR_MOO, MATEADDR_VILLAGE, MATEADDR_SOI, MATEADDR_ROAD, MATETAMBOL_CODE, MATEAMPHUR_CODE, MATEPROVINCE_CODE, MATEADDR_POSTCODE, MATEADDR_PHONE, LASTKEEP_DATE, MATE_CARDPERSON, MATE_SALARYID, UPDATE_BYENTRYID, UPDATE_BYENTRYIP, TAMBOL_DESC, KEEPSAL_FLAG, UPDATE_BYLASTDOC, REMEMB_FLAG FROM MBMEMBMASTER UPDATE "MBMEMBMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "PRENAME_CODE" = :PRENAME_CODE, "MEMB_NAME" = :MEMB_NAME, "MEMB_SURNAME" = :MEMB_SURNAME, "MEMB_ENAME" = :MEMB_ENAME, "MEMB_ESURNAME" = :MEMB_ESURNAME, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "SIGNATURE_NAME" = :SIGNATURE_NAME, "BIRTH_DATE" = :BIRTH_DATE, "MEMBER_DATE" = :MEMBER_DATE, "DEAD_STATUS" = :DEAD_STATUS, "DEAD_DATE" = :DEAD_DATE, "RETRY_STATUS" = :RETRY_STATUS, "RETRY_DATE" = :RETRY_DATE, "RESIGN_STATUS" = :RESIGN_STATUS, "RESIGN_DATE" = :RESIGN_DATE, "RESIGNCAUSE_CODE" = :RESIGNCAUSE_CODE, "CLOSE_DATE" = :CLOSE_DATE, "SEX" = :SEX, "MARIAGE_STATUS" = :MARIAGE_STATUS, "ADDR_NO" = :ADDR_NO, "ADDR_MOO" = :ADDR_MOO, "ADDR_SOI" = :ADDR_SOI, "ADDR_VILLAGE" = :ADDR_VILLAGE, "ADDR_ROAD" = :ADDR_ROAD, "TAMBOL_CODE" = :TAMBOL_CODE, "AMPHUR_CODE" = :AMPHUR_CODE, "PROVINCE_CODE" = :PROVINCE_CODE, "ADDR_POSTCODE" = :ADDR_POSTCODE, "ADDR_PHONE" = :ADDR_PHONE, "ADDR_MOBILEPHONE" = :ADDR_MOBILEPHONE, "CURRADDR_NO" = :CURRADDR_NO, "CURRADDR_MOO" = :CURRADDR_MOO, "CURRADDR_SOI" = :CURRADDR_SOI, "CURRADDR_VILLAGE" = :CURRADDR_VILLAGE, "CURRADDR_ROAD" = :CURRADDR_ROAD, "CURRTAMBOL_CODE" = :CURRTAMBOL_CODE, "CURRAMPHUR_CODE" = :CURRAMPHUR_CODE, "CURRPROVINCE_CODE" = :CURRPROVINCE_CODE, "CURRADDR_POSTCODE" = :CURRADDR_POSTCODE, "CURRADDR_PHONE" = :CURRADDR_PHONE, "ADDR_EMAIL" = :ADDR_EMAIL, "MEM_TELWORK" = :MEM_TELWORK, "MATE_NAME" = :MATE_NAME, "CARD_PERSON" = :CARD_PERSON, "CARD_TAX" = :CARD_TAX, "MEMBER_CARD" = :MEMBER_CARD, "WORK_DATE" = :WORK_DATE, "POSITION_CODE" = :POSITION_CODE, "POSITION_DESC" = :POSITION_DESC, "LEVEL_CODE" = :LEVEL_CODE, "DEPARTMENT_CODE" = :DEPARTMENT_CODE, "SALARY_AMOUNT" = :SALARY_AMOUNT, "SALARY_ID" = :SALARY_ID, "FIRSTFEE_STATUS" = :FIRSTFEE_STATUS, "MEMBER_STATUS" = :MEMBER_STATUS, "MEMREF_FLAG" = :MEMREF_FLAG, "MEMBER_REF" = :MEMBER_REF, "KLONGTOON_FLAG" = :KLONGTOON_FLAG, "HAVE_GAIN" = :HAVE_GAIN, "PAUSEKEEP_FLAG" = :PAUSEKEEP_FLAG, "PAUSEKEEP_DATE" = :PAUSEKEEP_DATE, "FIRST_KEEPDATE" = :FIRST_KEEPDATE, "LNPROVIDENTFUND_FLAG" = :LNPROVIDENTFUND_FLAG, "ALLOWLOAN_FLAG" = :ALLOWLOAN_FLAG, "DROPGURANTEE_FLAG" = :DROPGURANTEE_FLAG, "TRANSRIGHT_FLAG" = :TRANSRIGHT_FLAG, "DROPLOANALL_FLAG" = :DROPLOANALL_FLAG, "DIVIDEND_FLAG" = :DIVIDEND_FLAG, "AVERAGE_FLAG" = :AVERAGE_FLAG, "SEQUEST_DIVAVG" = :SEQUEST_DIVAVG, "REMARK" = :REMARK, "MEMBER_TYPE" = :MEMBER_TYPE, "DIVAVGSHOW_FLAG" = :DIVAVGSHOW_FLAG, "PRINTRECEIPTADDR_TYPE" = :PRINTRECEIPTADDR_TYPE, "WEB_CODE" = :WEB_CODE, "IVR_CODE" = :IVR_CODE, "MEMBTRANS_DATE" = :MEMBTRANS_DATE, "ACCUM_INTEREST" = :ACCUM_INTEREST, "SUMINT_LASTYEAR" = :SUMINT_LASTYEAR, "MISSPAYLON_AMT" = :MISSPAYLON_AMT, "MISSPAYSHR_AMT" = :MISSPAYSHR_AMT, "MATE_MBFLAG" = :MATE_MBFLAG, "MATE_MBNO" = :MATE_MBNO, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "APPL_DOCNO" = :APPL_DOCNO, "APPLTYPE_CODE" = :APPLTYPE_CODE, "COMPOUNDKEEP_GROUP" = :COMPOUNDKEEP_GROUP, "COMPOUNDKEEP_DATE" = :COMPOUNDKEEP_DATE, "COMPOUNDKEEP_STATUS" = :COMPOUNDKEEP_STATUS, "COMPOUNDKEEP_PERIOD" = :COMPOUNDKEEP_PERIOD, "COMPOUNDKEEP_DUEDATE" = :COMPOUNDKEEP_DUEDATE, "COMPOUNDKEEP_NMLDATE" = :COMPOUNDKEEP_NMLDATE, "INSURANCE_FLAG" = :INSURANCE_FLAG, "CREMATION_STATUS" = :CREMATION_STATUS, "NATIONALITY" = :NATIONALITY, "INCOMEETC_AMT" = :INCOMEETC_AMT, "FATHER_NAME" = :FATHER_NAME, "MATHER_NAME" = :MATHER_NAME, "SUBGROUP_CODE" = :SUBGROUP_CODE, "EMP_TYPE" = :EMP_TYPE, "MATEADDR_NO" = :MATEADDR_NO, "MATEADDR_MOO" = :MATEADDR_MOO, "MATEADDR_VILLAGE" = :MATEADDR_VILLAGE, "MATEADDR_SOI" = :MATEADDR_SOI, "MATEADDR_ROAD" = :MATEADDR_ROAD, "MATETAMBOL_CODE" = :MATETAMBOL_CODE, "MATEAMPHUR_CODE" = :MATEAMPHUR_CODE, "MATEPROVINCE_CODE" = :MATEPROVINCE_CODE, "MATEADDR_POSTCODE" = :MATEADDR_POSTCODE, "MATEADDR_PHONE" = :MATEADDR_PHONE, "LASTKEEP_DATE" = :LASTKEEP_DATE, "MATE_CARDPERSON" = :MATE_CARDPERSON, "MATE_SALARYID" = :MATE_SALARYID, "UPDATE_BYENTRYID" = :UPDATE_BYENTRYID, "UPDATE_BYENTRYIP" = :UPDATE_BYENTRYIP, "TAMBOL_DESC" = :TAMBOL_DESC, "KEEPSAL_FLAG" = :KEEPSAL_FLAG, "UPDATE_BYLASTDOC" = :UPDATE_BYLASTDOC, "REMEMB_FLAG" = :REMEMB_FLAG WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO))