DELETE FROM "MBREQAPPL" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("APPL_DOCNO" = :Original_APPL_DOCNO)) INSERT INTO "MBREQAPPL" ("COOP_ID", "APPL_DOCNO", "APPLTYPE_CODE", "APPLY_DATE", "PRENAME_CODE", "MEMB_NAME", "MEMB_SURNAME", "MEMB_ENAME", "MEMB_ESURNAME", "MEMBGROUP_CODE", "BIRTH_DATE", "SEX", "MARIAGE", "MEMB_ADDR", "ADDR_GROUP", "SOI", "MOOBAN", "ROAD", "TAMBOL_CODE", "DISTRICT_CODE", "PROVINCE_CODE", "POSTCODE", "MEM_TEL", "MEM_TELMOBILE", "EMAIL_ADDRESS", "CURRADDR_NO", "CURRADDR_MOO", "CURRADDR_SOI", "CURRADDR_VILLAGE", "CURRADDR_ROAD", "CURRTAMBOL_CODE", "CURRAMPHUR_CODE", "CURRPROVINCE_CODE", "CURRADDR_POSTCODE", "CURRADDR_PHONE", "MEMREF_FLAG", "CARD_PERSON", "WORK_DATE", "RETRY_DATE", "DEPARTMENT_CODE", "POSITION_CODE", "POSITION_DESC", "LEVEL_CODE", "SALARY_ID", "SALARY_AMOUNT", "REMARK", "DATE_RESIGN", "RESIGNCAUSE_CODE", "OLD_MEMBER_NO", "MEMBER_REF", "APPL_STATUS", "ENTRY_ID", "ENTRY_DATE", "ENTRY_BYCOOPID", "APPROVE_ID", "APPROVE_DATE", "MEMNOFIX_FLAG", "MEMBER_NO", "MEMBER_TYPE", "MEMBTYPE_CODE", "EMP_TYPE", "MEM_TELWORK", "MEMBDATEFIX_FLAG", "MEMBDATEFIX_DATE", "LNDROPGRANTEE_FLAG", "NATIONALITY", "FATHER_NAME", "MATHER_NAME", "INCOMEETC_AMT", "MATE_NAME", "MATE_CARDPERSON", "MATE_SALARYID", "MATEADDR_NO", "MATEADDR_MOO", "MATEADDR_VILLAGE", "MATEADDR_SOI", "MATEADDR_ROAD", "MATETAMBOL_CODE", "MATEAMPHUR_CODE", "MATEPROVINCE_CODE", "MATEADDR_POSTCODE", "MATEADDR_PHONE", "EXPENSE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "PERIODSHARE_VALUE", "PERIODBASE_VALUE", "TAMBOL_DESC") VALUES (:COOP_ID, :APPL_DOCNO, :APPLTYPE_CODE, :APPLY_DATE, :PRENAME_CODE, :MEMB_NAME, :MEMB_SURNAME, :MEMB_ENAME, :MEMB_ESURNAME, :MEMBGROUP_CODE, :BIRTH_DATE, :SEX, :MARIAGE, :MEMB_ADDR, :ADDR_GROUP, :SOI, :MOOBAN, :ROAD, :TAMBOL_CODE, :DISTRICT_CODE, :PROVINCE_CODE, :POSTCODE, :MEM_TEL, :MEM_TELMOBILE, :EMAIL_ADDRESS, :CURRADDR_NO, :CURRADDR_MOO, :CURRADDR_SOI, :CURRADDR_VILLAGE, :CURRADDR_ROAD, :CURRTAMBOL_CODE, :CURRAMPHUR_CODE, :CURRPROVINCE_CODE, :CURRADDR_POSTCODE, :CURRADDR_PHONE, :MEMREF_FLAG, :CARD_PERSON, :WORK_DATE, :RETRY_DATE, :DEPARTMENT_CODE, :POSITION_CODE, :POSITION_DESC, :LEVEL_CODE, :SALARY_ID, :SALARY_AMOUNT, :REMARK, :DATE_RESIGN, :RESIGNCAUSE_CODE, :OLD_MEMBER_NO, :MEMBER_REF, :APPL_STATUS, :ENTRY_ID, :ENTRY_DATE, :ENTRY_BYCOOPID, :APPROVE_ID, :APPROVE_DATE, :MEMNOFIX_FLAG, :MEMBER_NO, :MEMBER_TYPE, :MEMBTYPE_CODE, :EMP_TYPE, :MEM_TELWORK, :MEMBDATEFIX_FLAG, :MEMBDATEFIX_DATE, :LNDROPGRANTEE_FLAG, :NATIONALITY, :FATHER_NAME, :MATHER_NAME, :INCOMEETC_AMT, :MATE_NAME, :MATE_CARDPERSON, :MATE_SALARYID, :MATEADDR_NO, :MATEADDR_MOO, :MATEADDR_VILLAGE, :MATEADDR_SOI, :MATEADDR_ROAD, :MATETAMBOL_CODE, :MATEAMPHUR_CODE, :MATEPROVINCE_CODE, :MATEADDR_POSTCODE, :MATEADDR_PHONE, :EXPENSE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :PERIODSHARE_VALUE, :PERIODBASE_VALUE, :TAMBOL_DESC) SELECT COOP_ID, APPL_DOCNO, APPLTYPE_CODE, APPLY_DATE, PRENAME_CODE, MEMB_NAME, MEMB_SURNAME, MEMB_ENAME, MEMB_ESURNAME, MEMBGROUP_CODE, BIRTH_DATE, SEX, MARIAGE, MEMB_ADDR, ADDR_GROUP, SOI, MOOBAN, ROAD, TAMBOL_CODE, DISTRICT_CODE, PROVINCE_CODE, POSTCODE, MEM_TEL, MEM_TELMOBILE, EMAIL_ADDRESS, CURRADDR_NO, CURRADDR_MOO, CURRADDR_SOI, CURRADDR_VILLAGE, CURRADDR_ROAD, CURRTAMBOL_CODE, CURRAMPHUR_CODE, CURRPROVINCE_CODE, CURRADDR_POSTCODE, CURRADDR_PHONE, MEMREF_FLAG, CARD_PERSON, WORK_DATE, RETRY_DATE, DEPARTMENT_CODE, POSITION_CODE, POSITION_DESC, LEVEL_CODE, SALARY_ID, SALARY_AMOUNT, REMARK, DATE_RESIGN, RESIGNCAUSE_CODE, OLD_MEMBER_NO, MEMBER_REF, APPL_STATUS, ENTRY_ID, ENTRY_DATE, ENTRY_BYCOOPID, APPROVE_ID, APPROVE_DATE, MEMNOFIX_FLAG, MEMBER_NO, MEMBER_TYPE, MEMBTYPE_CODE, EMP_TYPE, MEM_TELWORK, MEMBDATEFIX_FLAG, MEMBDATEFIX_DATE, LNDROPGRANTEE_FLAG, NATIONALITY, FATHER_NAME, MATHER_NAME, INCOMEETC_AMT, MATE_NAME, MATE_CARDPERSON, MATE_SALARYID, MATEADDR_NO, MATEADDR_MOO, MATEADDR_VILLAGE, MATEADDR_SOI, MATEADDR_ROAD, MATETAMBOL_CODE, MATEAMPHUR_CODE, MATEPROVINCE_CODE, MATEADDR_POSTCODE, MATEADDR_PHONE, EXPENSE_CODE, EXPENSE_BANK, EXPENSE_BRANCH, EXPENSE_ACCID, PERIODSHARE_VALUE, PERIODBASE_VALUE, TAMBOL_DESC FROM MBREQAPPL UPDATE "MBREQAPPL" SET "COOP_ID" = :COOP_ID, "APPL_DOCNO" = :APPL_DOCNO, "APPLTYPE_CODE" = :APPLTYPE_CODE, "APPLY_DATE" = :APPLY_DATE, "PRENAME_CODE" = :PRENAME_CODE, "MEMB_NAME" = :MEMB_NAME, "MEMB_SURNAME" = :MEMB_SURNAME, "MEMB_ENAME" = :MEMB_ENAME, "MEMB_ESURNAME" = :MEMB_ESURNAME, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "BIRTH_DATE" = :BIRTH_DATE, "SEX" = :SEX, "MARIAGE" = :MARIAGE, "MEMB_ADDR" = :MEMB_ADDR, "ADDR_GROUP" = :ADDR_GROUP, "SOI" = :SOI, "MOOBAN" = :MOOBAN, "ROAD" = :ROAD, "TAMBOL_CODE" = :TAMBOL_CODE, "DISTRICT_CODE" = :DISTRICT_CODE, "PROVINCE_CODE" = :PROVINCE_CODE, "POSTCODE" = :POSTCODE, "MEM_TEL" = :MEM_TEL, "MEM_TELMOBILE" = :MEM_TELMOBILE, "EMAIL_ADDRESS" = :EMAIL_ADDRESS, "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, "MEMREF_FLAG" = :MEMREF_FLAG, "CARD_PERSON" = :CARD_PERSON, "WORK_DATE" = :WORK_DATE, "RETRY_DATE" = :RETRY_DATE, "DEPARTMENT_CODE" = :DEPARTMENT_CODE, "POSITION_CODE" = :POSITION_CODE, "POSITION_DESC" = :POSITION_DESC, "LEVEL_CODE" = :LEVEL_CODE, "SALARY_ID" = :SALARY_ID, "SALARY_AMOUNT" = :SALARY_AMOUNT, "REMARK" = :REMARK, "DATE_RESIGN" = :DATE_RESIGN, "RESIGNCAUSE_CODE" = :RESIGNCAUSE_CODE, "OLD_MEMBER_NO" = :OLD_MEMBER_NO, "MEMBER_REF" = :MEMBER_REF, "APPL_STATUS" = :APPL_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "ENTRY_BYCOOPID" = :ENTRY_BYCOOPID, "APPROVE_ID" = :APPROVE_ID, "APPROVE_DATE" = :APPROVE_DATE, "MEMNOFIX_FLAG" = :MEMNOFIX_FLAG, "MEMBER_NO" = :MEMBER_NO, "MEMBER_TYPE" = :MEMBER_TYPE, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "EMP_TYPE" = :EMP_TYPE, "MEM_TELWORK" = :MEM_TELWORK, "MEMBDATEFIX_FLAG" = :MEMBDATEFIX_FLAG, "MEMBDATEFIX_DATE" = :MEMBDATEFIX_DATE, "LNDROPGRANTEE_FLAG" = :LNDROPGRANTEE_FLAG, "NATIONALITY" = :NATIONALITY, "FATHER_NAME" = :FATHER_NAME, "MATHER_NAME" = :MATHER_NAME, "INCOMEETC_AMT" = :INCOMEETC_AMT, "MATE_NAME" = :MATE_NAME, "MATE_CARDPERSON" = :MATE_CARDPERSON, "MATE_SALARYID" = :MATE_SALARYID, "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, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "PERIODSHARE_VALUE" = :PERIODSHARE_VALUE, "PERIODBASE_VALUE" = :PERIODBASE_VALUE, "TAMBOL_DESC" = :TAMBOL_DESC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("APPL_DOCNO" = :Original_APPL_DOCNO)) DELETE FROM "MBREQAPPLMONEYTR" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("APPL_DOCNO" = :Original_APPL_DOCNO) AND ("TRTYPE_CODE" = :Original_TRTYPE_CODE)) INSERT INTO "MBREQAPPLMONEYTR" ("COOP_ID", "APPL_DOCNO", "TRTYPE_CODE", "MONEYTYPE_CODE", "BANK_CODE", "BANK_BRANCH", "BANK_ACCID") VALUES (:COOP_ID, :APPL_DOCNO, :TRTYPE_CODE, :MONEYTYPE_CODE, :BANK_CODE, :BANK_BRANCH, :BANK_ACCID) SELECT "MBREQAPPLMONEYTR"."COOP_ID", "MBREQAPPLMONEYTR"."APPL_DOCNO", "MBREQAPPLMONEYTR"."TRTYPE_CODE", "MBREQAPPLMONEYTR"."MONEYTYPE_CODE", "MBREQAPPLMONEYTR"."BANK_CODE", "MBREQAPPLMONEYTR"."BANK_BRANCH", "MBREQAPPLMONEYTR"."BANK_ACCID" FROM "MBREQAPPLMONEYTR" UPDATE "MBREQAPPLMONEYTR" SET "COOP_ID" = :COOP_ID, "APPL_DOCNO" = :APPL_DOCNO, "TRTYPE_CODE" = :TRTYPE_CODE, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "BANK_CODE" = :BANK_CODE, "BANK_BRANCH" = :BANK_BRANCH, "BANK_ACCID" = :BANK_ACCID WHERE (("COOP_ID" = :Original_COOP_ID) AND ("APPL_DOCNO" = :Original_APPL_DOCNO) AND ("TRTYPE_CODE" = :Original_TRTYPE_CODE))