DELETE FROM "MBREQAPPL" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("APPL_DOCNO" = :Original_APPL_DOCNO) AND ((:IsNull_APPLTYPE_CODE = 1 AND "APPLTYPE_CODE" IS NULL) OR ("APPLTYPE_CODE" = :Original_APPLTYPE_CODE)) AND ((:IsNull_APPLY_DATE = 1 AND "APPLY_DATE" IS NULL) OR ("APPLY_DATE" = :Original_APPLY_DATE)) AND ((:IsNull_PRENAME_CODE = 1 AND "PRENAME_CODE" IS NULL) OR ("PRENAME_CODE" = :Original_PRENAME_CODE)) AND ((:IsNull_MEMB_NAME = 1 AND "MEMB_NAME" IS NULL) OR ("MEMB_NAME" = :Original_MEMB_NAME)) AND ((:IsNull_MEMB_SURNAME = 1 AND "MEMB_SURNAME" IS NULL) OR ("MEMB_SURNAME" = :Original_MEMB_SURNAME)) AND ((:IsNull_MEMB_ENAME = 1 AND "MEMB_ENAME" IS NULL) OR ("MEMB_ENAME" = :Original_MEMB_ENAME)) AND ((:IsNull_MEMB_ESURNAME = 1 AND "MEMB_ESURNAME" IS NULL) OR ("MEMB_ESURNAME" = :Original_MEMB_ESURNAME)) AND ((:IsNull_MEMBGROUP_CODE = 1 AND "MEMBGROUP_CODE" IS NULL) OR ("MEMBGROUP_CODE" = :Original_MEMBGROUP_CODE)) AND ((:IsNull_BIRTH_DATE = 1 AND "BIRTH_DATE" IS NULL) OR ("BIRTH_DATE" = :Original_BIRTH_DATE)) AND ((:IsNull_SEX = 1 AND "SEX" IS NULL) OR ("SEX" = :Original_SEX)) AND ((:IsNull_MARIAGE = 1 AND "MARIAGE" IS NULL) OR ("MARIAGE" = :Original_MARIAGE)) AND ((:IsNull_MEMB_ADDR = 1 AND "MEMB_ADDR" IS NULL) OR ("MEMB_ADDR" = :Original_MEMB_ADDR)) AND ((:IsNull_ADDR_GROUP = 1 AND "ADDR_GROUP" IS NULL) OR ("ADDR_GROUP" = :Original_ADDR_GROUP)) AND ((:IsNull_SOI = 1 AND "SOI" IS NULL) OR ("SOI" = :Original_SOI)) AND ((:IsNull_MOOBAN = 1 AND "MOOBAN" IS NULL) OR ("MOOBAN" = :Original_MOOBAN)) AND ((:IsNull_ROAD = 1 AND "ROAD" IS NULL) OR ("ROAD" = :Original_ROAD)) AND ((:IsNull_TAMBOL_CODE = 1 AND "TAMBOL_CODE" IS NULL) OR ("TAMBOL_CODE" = :Original_TAMBOL_CODE)) AND ((:IsNull_DISTRICT_CODE = 1 AND "DISTRICT_CODE" IS NULL) OR ("DISTRICT_CODE" = :Original_DISTRICT_CODE)) AND ((:IsNull_PROVINCE_CODE = 1 AND "PROVINCE_CODE" IS NULL) OR ("PROVINCE_CODE" = :Original_PROVINCE_CODE)) AND ((:IsNull_POSTCODE = 1 AND "POSTCODE" IS NULL) OR ("POSTCODE" = :Original_POSTCODE)) AND ((:IsNull_MEM_TEL = 1 AND "MEM_TEL" IS NULL) OR ("MEM_TEL" = :Original_MEM_TEL)) AND ((:IsNull_MEM_TELMOBILE = 1 AND "MEM_TELMOBILE" IS NULL) OR ("MEM_TELMOBILE" = :Original_MEM_TELMOBILE)) AND ((:IsNull_EMAIL_ADDRESS = 1 AND "EMAIL_ADDRESS" IS NULL) OR ("EMAIL_ADDRESS" = :Original_EMAIL_ADDRESS)) AND ((:IsNull_CURRADDR_NO = 1 AND "CURRADDR_NO" IS NULL) OR ("CURRADDR_NO" = :Original_CURRADDR_NO)) AND ((:IsNull_CURRADDR_MOO = 1 AND "CURRADDR_MOO" IS NULL) OR ("CURRADDR_MOO" = :Original_CURRADDR_MOO)) AND ((:IsNull_CURRADDR_SOI = 1 AND "CURRADDR_SOI" IS NULL) OR ("CURRADDR_SOI" = :Original_CURRADDR_SOI)) AND ((:IsNull_CURRADDR_VILLAGE = 1 AND "CURRADDR_VILLAGE" IS NULL) OR ("CURRADDR_VILLAGE" = :Original_CURRADDR_VILLAGE)) AND ((:IsNull_CURRADDR_ROAD = 1 AND "CURRADDR_ROAD" IS NULL) OR ("CURRADDR_ROAD" = :Original_CURRADDR_ROAD)) AND ((:IsNull_CURRTAMBOL_CODE = 1 AND "CURRTAMBOL_CODE" IS NULL) OR ("CURRTAMBOL_CODE" = :Original_CURRTAMBOL_CODE)) AND ((:IsNull_CURRAMPHUR_CODE = 1 AND "CURRAMPHUR_CODE" IS NULL) OR ("CURRAMPHUR_CODE" = :Original_CURRAMPHUR_CODE)) AND ((:IsNull_CURRPROVINCE_CODE = 1 AND "CURRPROVINCE_CODE" IS NULL) OR ("CURRPROVINCE_CODE" = :Original_CURRPROVINCE_CODE)) AND ((:IsNull_CURRADDR_POSTCODE = 1 AND "CURRADDR_POSTCODE" IS NULL) OR ("CURRADDR_POSTCODE" = :Original_CURRADDR_POSTCODE)) AND ((:IsNull_CURRADDR_PHONE = 1 AND "CURRADDR_PHONE" IS NULL) OR ("CURRADDR_PHONE" = :Original_CURRADDR_PHONE)) AND ((:IsNull_MEMREF_FLAG = 1 AND "MEMREF_FLAG" IS NULL) OR ("MEMREF_FLAG" = :Original_MEMREF_FLAG)) AND ((:IsNull_CARD_PERSON = 1 AND "CARD_PERSON" IS NULL) OR ("CARD_PERSON" = :Original_CARD_PERSON)) AND ((:IsNull_WORK_DATE = 1 AND "WORK_DATE" IS NULL) OR ("WORK_DATE" = :Original_WORK_DATE)) AND ((:IsNull_RETRY_DATE = 1 AND "RETRY_DATE" IS NULL) OR ("RETRY_DATE" = :Original_RETRY_DATE)) AND ((:IsNull_DEPARTMENT_CODE = 1 AND "DEPARTMENT_CODE" IS NULL) OR ("DEPARTMENT_CODE" = :Original_DEPARTMENT_CODE)) AND ((:IsNull_POSITION_CODE = 1 AND "POSITION_CODE" IS NULL) OR ("POSITION_CODE" = :Original_POSITION_CODE)) AND ((:IsNull_POSITION_DESC = 1 AND "POSITION_DESC" IS NULL) OR ("POSITION_DESC" = :Original_POSITION_DESC)) AND ((:IsNull_LEVEL_CODE = 1 AND "LEVEL_CODE" IS NULL) OR ("LEVEL_CODE" = :Original_LEVEL_CODE)) AND ((:IsNull_SALARY_ID = 1 AND "SALARY_ID" IS NULL) OR ("SALARY_ID" = :Original_SALARY_ID)) AND ((:IsNull_SALARY_AMOUNT = 1 AND "SALARY_AMOUNT" IS NULL) OR ("SALARY_AMOUNT" = :Original_SALARY_AMOUNT)) AND ((:IsNull_REMARK = 1 AND "REMARK" IS NULL) OR ("REMARK" = :Original_REMARK)) AND ((:IsNull_DATE_RESIGN = 1 AND "DATE_RESIGN" IS NULL) OR ("DATE_RESIGN" = :Original_DATE_RESIGN)) AND ((:IsNull_RESIGNCAUSE_CODE = 1 AND "RESIGNCAUSE_CODE" IS NULL) OR ("RESIGNCAUSE_CODE" = :Original_RESIGNCAUSE_CODE)) AND ((:IsNull_OLD_MEMBER_NO = 1 AND "OLD_MEMBER_NO" IS NULL) OR ("OLD_MEMBER_NO" = :Original_OLD_MEMBER_NO)) AND ((:IsNull_MEMBER_REF = 1 AND "MEMBER_REF" IS NULL) OR ("MEMBER_REF" = :Original_MEMBER_REF)) AND ((:IsNull_APPL_STATUS = 1 AND "APPL_STATUS" IS NULL) OR ("APPL_STATUS" = :Original_APPL_STATUS)) AND ((:IsNull_ENTRY_ID = 1 AND "ENTRY_ID" IS NULL) OR ("ENTRY_ID" = :Original_ENTRY_ID)) AND ((:IsNull_ENTRY_DATE = 1 AND "ENTRY_DATE" IS NULL) OR ("ENTRY_DATE" = :Original_ENTRY_DATE)) AND ((:IsNull_ENTRY_BYCOOPID = 1 AND "ENTRY_BYCOOPID" IS NULL) OR ("ENTRY_BYCOOPID" = :Original_ENTRY_BYCOOPID)) AND ((:IsNull_APPROVE_ID = 1 AND "APPROVE_ID" IS NULL) OR ("APPROVE_ID" = :Original_APPROVE_ID)) AND ((:IsNull_APPROVE_DATE = 1 AND "APPROVE_DATE" IS NULL) OR ("APPROVE_DATE" = :Original_APPROVE_DATE)) AND ((:IsNull_MEMNOFIX_FLAG = 1 AND "MEMNOFIX_FLAG" IS NULL) OR ("MEMNOFIX_FLAG" = :Original_MEMNOFIX_FLAG)) AND ((:IsNull_MEMBER_NO = 1 AND "MEMBER_NO" IS NULL) OR ("MEMBER_NO" = :Original_MEMBER_NO)) AND ((:IsNull_MEMBER_TYPE = 1 AND "MEMBER_TYPE" IS NULL) OR ("MEMBER_TYPE" = :Original_MEMBER_TYPE)) AND ((:IsNull_MEMBTYPE_CODE = 1 AND "MEMBTYPE_CODE" IS NULL) OR ("MEMBTYPE_CODE" = :Original_MEMBTYPE_CODE)) AND ((:IsNull_EMP_TYPE = 1 AND "EMP_TYPE" IS NULL) OR ("EMP_TYPE" = :Original_EMP_TYPE)) AND ((:IsNull_MEM_TELWORK = 1 AND "MEM_TELWORK" IS NULL) OR ("MEM_TELWORK" = :Original_MEM_TELWORK)) AND ((:IsNull_MEMBDATEFIX_FLAG = 1 AND "MEMBDATEFIX_FLAG" IS NULL) OR ("MEMBDATEFIX_FLAG" = :Original_MEMBDATEFIX_FLAG)) AND ((:IsNull_MEMBDATEFIX_DATE = 1 AND "MEMBDATEFIX_DATE" IS NULL) OR ("MEMBDATEFIX_DATE" = :Original_MEMBDATEFIX_DATE)) AND ((:IsNull_LNDROPGRANTEE_FLAG = 1 AND "LNDROPGRANTEE_FLAG" IS NULL) OR ("LNDROPGRANTEE_FLAG" = :Original_LNDROPGRANTEE_FLAG)) AND ((:IsNull_NATIONALITY = 1 AND "NATIONALITY" IS NULL) OR ("NATIONALITY" = :Original_NATIONALITY)) AND ((:IsNull_FATHER_NAME = 1 AND "FATHER_NAME" IS NULL) OR ("FATHER_NAME" = :Original_FATHER_NAME)) AND ((:IsNull_MATHER_NAME = 1 AND "MATHER_NAME" IS NULL) OR ("MATHER_NAME" = :Original_MATHER_NAME)) AND ((:IsNull_INCOMEETC_AMT = 1 AND "INCOMEETC_AMT" IS NULL) OR ("INCOMEETC_AMT" = :Original_INCOMEETC_AMT)) AND ((:IsNull_MATE_NAME = 1 AND "MATE_NAME" IS NULL) OR ("MATE_NAME" = :Original_MATE_NAME)) AND ((:IsNull_MATE_CARDPERSON = 1 AND "MATE_CARDPERSON" IS NULL) OR ("MATE_CARDPERSON" = :Original_MATE_CARDPERSON)) AND ((:IsNull_MATE_SALARYID = 1 AND "MATE_SALARYID" IS NULL) OR ("MATE_SALARYID" = :Original_MATE_SALARYID)) AND ((:IsNull_MATEADDR_NO = 1 AND "MATEADDR_NO" IS NULL) OR ("MATEADDR_NO" = :Original_MATEADDR_NO)) AND ((:IsNull_MATEADDR_MOO = 1 AND "MATEADDR_MOO" IS NULL) OR ("MATEADDR_MOO" = :Original_MATEADDR_MOO)) AND ((:IsNull_MATEADDR_VILLAGE = 1 AND "MATEADDR_VILLAGE" IS NULL) OR ("MATEADDR_VILLAGE" = :Original_MATEADDR_VILLAGE)) AND ((:IsNull_MATEADDR_SOI = 1 AND "MATEADDR_SOI" IS NULL) OR ("MATEADDR_SOI" = :Original_MATEADDR_SOI)) AND ((:IsNull_MATEADDR_ROAD = 1 AND "MATEADDR_ROAD" IS NULL) OR ("MATEADDR_ROAD" = :Original_MATEADDR_ROAD)) AND ((:IsNull_MATETAMBOL_CODE = 1 AND "MATETAMBOL_CODE" IS NULL) OR ("MATETAMBOL_CODE" = :Original_MATETAMBOL_CODE)) AND ((:IsNull_MATEAMPHUR_CODE = 1 AND "MATEAMPHUR_CODE" IS NULL) OR ("MATEAMPHUR_CODE" = :Original_MATEAMPHUR_CODE)) AND ((:IsNull_MATEPROVINCE_CODE = 1 AND "MATEPROVINCE_CODE" IS NULL) OR ("MATEPROVINCE_CODE" = :Original_MATEPROVINCE_CODE)) AND ((:IsNull_MATEADDR_POSTCODE = 1 AND "MATEADDR_POSTCODE" IS NULL) OR ("MATEADDR_POSTCODE" = :Original_MATEADDR_POSTCODE)) AND ((:IsNull_MATEADDR_PHONE = 1 AND "MATEADDR_PHONE" IS NULL) OR ("MATEADDR_PHONE" = :Original_MATEADDR_PHONE)) AND ((:IsNull_EXPENSE_CODE = 1 AND "EXPENSE_CODE" IS NULL) OR ("EXPENSE_CODE" = :Original_EXPENSE_CODE)) AND ((:IsNull_EXPENSE_BANK = 1 AND "EXPENSE_BANK" IS NULL) OR ("EXPENSE_BANK" = :Original_EXPENSE_BANK)) AND ((:IsNull_EXPENSE_BRANCH = 1 AND "EXPENSE_BRANCH" IS NULL) OR ("EXPENSE_BRANCH" = :Original_EXPENSE_BRANCH)) AND ((:IsNull_EXPENSE_ACCID = 1 AND "EXPENSE_ACCID" IS NULL) OR ("EXPENSE_ACCID" = :Original_EXPENSE_ACCID)) AND ((:IsNull_PERIODSHARE_VALUE = 1 AND "PERIODSHARE_VALUE" IS NULL) OR ("PERIODSHARE_VALUE" = :Original_PERIODSHARE_VALUE)) AND ((:IsNull_PERIODBASE_VALUE = 1 AND "PERIODBASE_VALUE" IS NULL) OR ("PERIODBASE_VALUE" = :Original_PERIODBASE_VALUE)) AND ((:IsNull_TAMBOL_DESC = 1 AND "TAMBOL_DESC" IS NULL) OR ("TAMBOL_DESC" = :Original_TAMBOL_DESC)) AND ((:IsNull_REMEMB_FLAG = 1 AND "REMEMB_FLAG" IS NULL) OR ("REMEMB_FLAG" = :Original_REMEMB_FLAG)) AND ((:IsNull_DISTRICT_DESC = 1 AND "DISTRICT_DESC" IS NULL) OR ("DISTRICT_DESC" = :Original_DISTRICT_DESC)) AND ((:IsNull_PROVINCE_DESC = 1 AND "PROVINCE_DESC" IS NULL) OR ("PROVINCE_DESC" = :Original_PROVINCE_DESC))) 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", "REMEMB_FLAG", "DISTRICT_DESC", "PROVINCE_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, :REMEMB_FLAG, :DISTRICT_DESC, :PROVINCE_DESC) SELECT * 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, "REMEMB_FLAG" = :REMEMB_FLAG, "DISTRICT_DESC" = :DISTRICT_DESC, "PROVINCE_DESC" = :PROVINCE_DESC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("APPL_DOCNO" = :Original_APPL_DOCNO) AND ((:IsNull_APPLTYPE_CODE = 1 AND "APPLTYPE_CODE" IS NULL) OR ("APPLTYPE_CODE" = :Original_APPLTYPE_CODE)) AND ((:IsNull_APPLY_DATE = 1 AND "APPLY_DATE" IS NULL) OR ("APPLY_DATE" = :Original_APPLY_DATE)) AND ((:IsNull_PRENAME_CODE = 1 AND "PRENAME_CODE" IS NULL) OR ("PRENAME_CODE" = :Original_PRENAME_CODE)) AND ((:IsNull_MEMB_NAME = 1 AND "MEMB_NAME" IS NULL) OR ("MEMB_NAME" = :Original_MEMB_NAME)) AND ((:IsNull_MEMB_SURNAME = 1 AND "MEMB_SURNAME" IS NULL) OR ("MEMB_SURNAME" = :Original_MEMB_SURNAME)) AND ((:IsNull_MEMB_ENAME = 1 AND "MEMB_ENAME" IS NULL) OR ("MEMB_ENAME" = :Original_MEMB_ENAME)) AND ((:IsNull_MEMB_ESURNAME = 1 AND "MEMB_ESURNAME" IS NULL) OR ("MEMB_ESURNAME" = :Original_MEMB_ESURNAME)) AND ((:IsNull_MEMBGROUP_CODE = 1 AND "MEMBGROUP_CODE" IS NULL) OR ("MEMBGROUP_CODE" = :Original_MEMBGROUP_CODE)) AND ((:IsNull_BIRTH_DATE = 1 AND "BIRTH_DATE" IS NULL) OR ("BIRTH_DATE" = :Original_BIRTH_DATE)) AND ((:IsNull_SEX = 1 AND "SEX" IS NULL) OR ("SEX" = :Original_SEX)) AND ((:IsNull_MARIAGE = 1 AND "MARIAGE" IS NULL) OR ("MARIAGE" = :Original_MARIAGE)) AND ((:IsNull_MEMB_ADDR = 1 AND "MEMB_ADDR" IS NULL) OR ("MEMB_ADDR" = :Original_MEMB_ADDR)) AND ((:IsNull_ADDR_GROUP = 1 AND "ADDR_GROUP" IS NULL) OR ("ADDR_GROUP" = :Original_ADDR_GROUP)) AND ((:IsNull_SOI = 1 AND "SOI" IS NULL) OR ("SOI" = :Original_SOI)) AND ((:IsNull_MOOBAN = 1 AND "MOOBAN" IS NULL) OR ("MOOBAN" = :Original_MOOBAN)) AND ((:IsNull_ROAD = 1 AND "ROAD" IS NULL) OR ("ROAD" = :Original_ROAD)) AND ((:IsNull_TAMBOL_CODE = 1 AND "TAMBOL_CODE" IS NULL) OR ("TAMBOL_CODE" = :Original_TAMBOL_CODE)) AND ((:IsNull_DISTRICT_CODE = 1 AND "DISTRICT_CODE" IS NULL) OR ("DISTRICT_CODE" = :Original_DISTRICT_CODE)) AND ((:IsNull_PROVINCE_CODE = 1 AND "PROVINCE_CODE" IS NULL) OR ("PROVINCE_CODE" = :Original_PROVINCE_CODE)) AND ((:IsNull_POSTCODE = 1 AND "POSTCODE" IS NULL) OR ("POSTCODE" = :Original_POSTCODE)) AND ((:IsNull_MEM_TEL = 1 AND "MEM_TEL" IS NULL) OR ("MEM_TEL" = :Original_MEM_TEL)) AND ((:IsNull_MEM_TELMOBILE = 1 AND "MEM_TELMOBILE" IS NULL) OR ("MEM_TELMOBILE" = :Original_MEM_TELMOBILE)) AND ((:IsNull_EMAIL_ADDRESS = 1 AND "EMAIL_ADDRESS" IS NULL) OR ("EMAIL_ADDRESS" = :Original_EMAIL_ADDRESS)) AND ((:IsNull_CURRADDR_NO = 1 AND "CURRADDR_NO" IS NULL) OR ("CURRADDR_NO" = :Original_CURRADDR_NO)) AND ((:IsNull_CURRADDR_MOO = 1 AND "CURRADDR_MOO" IS NULL) OR ("CURRADDR_MOO" = :Original_CURRADDR_MOO)) AND ((:IsNull_CURRADDR_SOI = 1 AND "CURRADDR_SOI" IS NULL) OR ("CURRADDR_SOI" = :Original_CURRADDR_SOI)) AND ((:IsNull_CURRADDR_VILLAGE = 1 AND "CURRADDR_VILLAGE" IS NULL) OR ("CURRADDR_VILLAGE" = :Original_CURRADDR_VILLAGE)) AND ((:IsNull_CURRADDR_ROAD = 1 AND "CURRADDR_ROAD" IS NULL) OR ("CURRADDR_ROAD" = :Original_CURRADDR_ROAD)) AND ((:IsNull_CURRTAMBOL_CODE = 1 AND "CURRTAMBOL_CODE" IS NULL) OR ("CURRTAMBOL_CODE" = :Original_CURRTAMBOL_CODE)) AND ((:IsNull_CURRAMPHUR_CODE = 1 AND "CURRAMPHUR_CODE" IS NULL) OR ("CURRAMPHUR_CODE" = :Original_CURRAMPHUR_CODE)) AND ((:IsNull_CURRPROVINCE_CODE = 1 AND "CURRPROVINCE_CODE" IS NULL) OR ("CURRPROVINCE_CODE" = :Original_CURRPROVINCE_CODE)) AND ((:IsNull_CURRADDR_POSTCODE = 1 AND "CURRADDR_POSTCODE" IS NULL) OR ("CURRADDR_POSTCODE" = :Original_CURRADDR_POSTCODE)) AND ((:IsNull_CURRADDR_PHONE = 1 AND "CURRADDR_PHONE" IS NULL) OR ("CURRADDR_PHONE" = :Original_CURRADDR_PHONE)) AND ((:IsNull_MEMREF_FLAG = 1 AND "MEMREF_FLAG" IS NULL) OR ("MEMREF_FLAG" = :Original_MEMREF_FLAG)) AND ((:IsNull_CARD_PERSON = 1 AND "CARD_PERSON" IS NULL) OR ("CARD_PERSON" = :Original_CARD_PERSON)) AND ((:IsNull_WORK_DATE = 1 AND "WORK_DATE" IS NULL) OR ("WORK_DATE" = :Original_WORK_DATE)) AND ((:IsNull_RETRY_DATE = 1 AND "RETRY_DATE" IS NULL) OR ("RETRY_DATE" = :Original_RETRY_DATE)) AND ((:IsNull_DEPARTMENT_CODE = 1 AND "DEPARTMENT_CODE" IS NULL) OR ("DEPARTMENT_CODE" = :Original_DEPARTMENT_CODE)) AND ((:IsNull_POSITION_CODE = 1 AND "POSITION_CODE" IS NULL) OR ("POSITION_CODE" = :Original_POSITION_CODE)) AND ((:IsNull_POSITION_DESC = 1 AND "POSITION_DESC" IS NULL) OR ("POSITION_DESC" = :Original_POSITION_DESC)) AND ((:IsNull_LEVEL_CODE = 1 AND "LEVEL_CODE" IS NULL) OR ("LEVEL_CODE" = :Original_LEVEL_CODE)) AND ((:IsNull_SALARY_ID = 1 AND "SALARY_ID" IS NULL) OR ("SALARY_ID" = :Original_SALARY_ID)) AND ((:IsNull_SALARY_AMOUNT = 1 AND "SALARY_AMOUNT" IS NULL) OR ("SALARY_AMOUNT" = :Original_SALARY_AMOUNT)) AND ((:IsNull_REMARK = 1 AND "REMARK" IS NULL) OR ("REMARK" = :Original_REMARK)) AND ((:IsNull_DATE_RESIGN = 1 AND "DATE_RESIGN" IS NULL) OR ("DATE_RESIGN" = :Original_DATE_RESIGN)) AND ((:IsNull_RESIGNCAUSE_CODE = 1 AND "RESIGNCAUSE_CODE" IS NULL) OR ("RESIGNCAUSE_CODE" = :Original_RESIGNCAUSE_CODE)) AND ((:IsNull_OLD_MEMBER_NO = 1 AND "OLD_MEMBER_NO" IS NULL) OR ("OLD_MEMBER_NO" = :Original_OLD_MEMBER_NO)) AND ((:IsNull_MEMBER_REF = 1 AND "MEMBER_REF" IS NULL) OR ("MEMBER_REF" = :Original_MEMBER_REF)) AND ((:IsNull_APPL_STATUS = 1 AND "APPL_STATUS" IS NULL) OR ("APPL_STATUS" = :Original_APPL_STATUS)) AND ((:IsNull_ENTRY_ID = 1 AND "ENTRY_ID" IS NULL) OR ("ENTRY_ID" = :Original_ENTRY_ID)) AND ((:IsNull_ENTRY_DATE = 1 AND "ENTRY_DATE" IS NULL) OR ("ENTRY_DATE" = :Original_ENTRY_DATE)) AND ((:IsNull_ENTRY_BYCOOPID = 1 AND "ENTRY_BYCOOPID" IS NULL) OR ("ENTRY_BYCOOPID" = :Original_ENTRY_BYCOOPID)) AND ((:IsNull_APPROVE_ID = 1 AND "APPROVE_ID" IS NULL) OR ("APPROVE_ID" = :Original_APPROVE_ID)) AND ((:IsNull_APPROVE_DATE = 1 AND "APPROVE_DATE" IS NULL) OR ("APPROVE_DATE" = :Original_APPROVE_DATE)) AND ((:IsNull_MEMNOFIX_FLAG = 1 AND "MEMNOFIX_FLAG" IS NULL) OR ("MEMNOFIX_FLAG" = :Original_MEMNOFIX_FLAG)) AND ((:IsNull_MEMBER_NO = 1 AND "MEMBER_NO" IS NULL) OR ("MEMBER_NO" = :Original_MEMBER_NO)) AND ((:IsNull_MEMBER_TYPE = 1 AND "MEMBER_TYPE" IS NULL) OR ("MEMBER_TYPE" = :Original_MEMBER_TYPE)) AND ((:IsNull_MEMBTYPE_CODE = 1 AND "MEMBTYPE_CODE" IS NULL) OR ("MEMBTYPE_CODE" = :Original_MEMBTYPE_CODE)) AND ((:IsNull_EMP_TYPE = 1 AND "EMP_TYPE" IS NULL) OR ("EMP_TYPE" = :Original_EMP_TYPE)) AND ((:IsNull_MEM_TELWORK = 1 AND "MEM_TELWORK" IS NULL) OR ("MEM_TELWORK" = :Original_MEM_TELWORK)) AND ((:IsNull_MEMBDATEFIX_FLAG = 1 AND "MEMBDATEFIX_FLAG" IS NULL) OR ("MEMBDATEFIX_FLAG" = :Original_MEMBDATEFIX_FLAG)) AND ((:IsNull_MEMBDATEFIX_DATE = 1 AND "MEMBDATEFIX_DATE" IS NULL) OR ("MEMBDATEFIX_DATE" = :Original_MEMBDATEFIX_DATE)) AND ((:IsNull_LNDROPGRANTEE_FLAG = 1 AND "LNDROPGRANTEE_FLAG" IS NULL) OR ("LNDROPGRANTEE_FLAG" = :Original_LNDROPGRANTEE_FLAG)) AND ((:IsNull_NATIONALITY = 1 AND "NATIONALITY" IS NULL) OR ("NATIONALITY" = :Original_NATIONALITY)) AND ((:IsNull_FATHER_NAME = 1 AND "FATHER_NAME" IS NULL) OR ("FATHER_NAME" = :Original_FATHER_NAME)) AND ((:IsNull_MATHER_NAME = 1 AND "MATHER_NAME" IS NULL) OR ("MATHER_NAME" = :Original_MATHER_NAME)) AND ((:IsNull_INCOMEETC_AMT = 1 AND "INCOMEETC_AMT" IS NULL) OR ("INCOMEETC_AMT" = :Original_INCOMEETC_AMT)) AND ((:IsNull_MATE_NAME = 1 AND "MATE_NAME" IS NULL) OR ("MATE_NAME" = :Original_MATE_NAME)) AND ((:IsNull_MATE_CARDPERSON = 1 AND "MATE_CARDPERSON" IS NULL) OR ("MATE_CARDPERSON" = :Original_MATE_CARDPERSON)) AND ((:IsNull_MATE_SALARYID = 1 AND "MATE_SALARYID" IS NULL) OR ("MATE_SALARYID" = :Original_MATE_SALARYID)) AND ((:IsNull_MATEADDR_NO = 1 AND "MATEADDR_NO" IS NULL) OR ("MATEADDR_NO" = :Original_MATEADDR_NO)) AND ((:IsNull_MATEADDR_MOO = 1 AND "MATEADDR_MOO" IS NULL) OR ("MATEADDR_MOO" = :Original_MATEADDR_MOO)) AND ((:IsNull_MATEADDR_VILLAGE = 1 AND "MATEADDR_VILLAGE" IS NULL) OR ("MATEADDR_VILLAGE" = :Original_MATEADDR_VILLAGE)) AND ((:IsNull_MATEADDR_SOI = 1 AND "MATEADDR_SOI" IS NULL) OR ("MATEADDR_SOI" = :Original_MATEADDR_SOI)) AND ((:IsNull_MATEADDR_ROAD = 1 AND "MATEADDR_ROAD" IS NULL) OR ("MATEADDR_ROAD" = :Original_MATEADDR_ROAD)) AND ((:IsNull_MATETAMBOL_CODE = 1 AND "MATETAMBOL_CODE" IS NULL) OR ("MATETAMBOL_CODE" = :Original_MATETAMBOL_CODE)) AND ((:IsNull_MATEAMPHUR_CODE = 1 AND "MATEAMPHUR_CODE" IS NULL) OR ("MATEAMPHUR_CODE" = :Original_MATEAMPHUR_CODE)) AND ((:IsNull_MATEPROVINCE_CODE = 1 AND "MATEPROVINCE_CODE" IS NULL) OR ("MATEPROVINCE_CODE" = :Original_MATEPROVINCE_CODE)) AND ((:IsNull_MATEADDR_POSTCODE = 1 AND "MATEADDR_POSTCODE" IS NULL) OR ("MATEADDR_POSTCODE" = :Original_MATEADDR_POSTCODE)) AND ((:IsNull_MATEADDR_PHONE = 1 AND "MATEADDR_PHONE" IS NULL) OR ("MATEADDR_PHONE" = :Original_MATEADDR_PHONE)) AND ((:IsNull_EXPENSE_CODE = 1 AND "EXPENSE_CODE" IS NULL) OR ("EXPENSE_CODE" = :Original_EXPENSE_CODE)) AND ((:IsNull_EXPENSE_BANK = 1 AND "EXPENSE_BANK" IS NULL) OR ("EXPENSE_BANK" = :Original_EXPENSE_BANK)) AND ((:IsNull_EXPENSE_BRANCH = 1 AND "EXPENSE_BRANCH" IS NULL) OR ("EXPENSE_BRANCH" = :Original_EXPENSE_BRANCH)) AND ((:IsNull_EXPENSE_ACCID = 1 AND "EXPENSE_ACCID" IS NULL) OR ("EXPENSE_ACCID" = :Original_EXPENSE_ACCID)) AND ((:IsNull_PERIODSHARE_VALUE = 1 AND "PERIODSHARE_VALUE" IS NULL) OR ("PERIODSHARE_VALUE" = :Original_PERIODSHARE_VALUE)) AND ((:IsNull_PERIODBASE_VALUE = 1 AND "PERIODBASE_VALUE" IS NULL) OR ("PERIODBASE_VALUE" = :Original_PERIODBASE_VALUE)) AND ((:IsNull_TAMBOL_DESC = 1 AND "TAMBOL_DESC" IS NULL) OR ("TAMBOL_DESC" = :Original_TAMBOL_DESC)) AND ((:IsNull_REMEMB_FLAG = 1 AND "REMEMB_FLAG" IS NULL) OR ("REMEMB_FLAG" = :Original_REMEMB_FLAG)) AND ((:IsNull_DISTRICT_DESC = 1 AND "DISTRICT_DESC" IS NULL) OR ("DISTRICT_DESC" = :Original_DISTRICT_DESC)) AND ((:IsNull_PROVINCE_DESC = 1 AND "PROVINCE_DESC" IS NULL) OR ("PROVINCE_DESC" = :Original_PROVINCE_DESC))) DELETE FROM "LNLAWMBMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO)) INSERT INTO "LNLAWMBMASTER" ("COOP_ID", "MEMBER_NO", "PRENAME_CODE", "MEMB_NAME", "MEMB_SURNAME", "MEMBGROUP_CODE", "MEMBTYPE_CODE", "BIRTH_DATE", "MEMBER_DATE", "ADDR_NO", "ADDR_MOO", "ADDR_SOI", "ADDR_VILLAGE", "ADDR_ROAD", "TAMBOL_CODE", "AMPHUR_CODE", "PROVINCE_CODE", "ADDR_POSTCODE", "ADDR_PHONE", "MATE_NAME", "CARD_PERSON", "REMARK", "MEMBER_TYPE", "T_PROVINCE", "T_AMPHUR", "T_TAMBOL") VALUES (:COOP_ID, :MEMBER_NO, :PRENAME_CODE, :MEMB_NAME, :MEMB_SURNAME, :MEMBGROUP_CODE, :MEMBTYPE_CODE, :BIRTH_DATE, :MEMBER_DATE, :ADDR_NO, :ADDR_MOO, :ADDR_SOI, :ADDR_VILLAGE, :ADDR_ROAD, :TAMBOL_CODE, :AMPHUR_CODE, :PROVINCE_CODE, :ADDR_POSTCODE, :ADDR_PHONE, :MATE_NAME, :CARD_PERSON, :REMARK, :MEMBER_TYPE, :T_PROVINCE, :T_AMPHUR, :T_TAMBOL) select * from lnlawmbmaster UPDATE "LNLAWMBMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "PRENAME_CODE" = :PRENAME_CODE, "MEMB_NAME" = :MEMB_NAME, "MEMB_SURNAME" = :MEMB_SURNAME, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "BIRTH_DATE" = :BIRTH_DATE, "MEMBER_DATE" = :MEMBER_DATE, "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, "MATE_NAME" = :MATE_NAME, "CARD_PERSON" = :CARD_PERSON, "REMARK" = :REMARK, "MEMBER_TYPE" = :MEMBER_TYPE, "T_PROVINCE" = :T_PROVINCE, "T_AMPHUR" = :T_AMPHUR, "T_TAMBOL" = :T_TAMBOL WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO))