SELECT HRLOGLEAVE.COOP_ID, HRLOGLEAVE.EMP_NO, HRLOGLEAVE.SEQ_NO, HRLOGLEAVE.OPERATE_DATE, HRLOGLEAVE.LEAVE_CODE, HRLOGLEAVE.LEAVE_FROM, HRLOGLEAVE.LEAVE_TO, HRLOGLEAVE.TOTALDAY, HRLOGLEAVE.TOTALTIME, HRLOGLEAVE.LEAVE_CAUSE, HRLOGLEAVE.LEAVE_TEL, HRLOGLEAVE.LEAVE_PLACE, HRLOGLEAVE.APV_STATUS, HRLOGLEAVE.APV_DATE, HRLOGLEAVE.APV_REMARK, HRLOGLEAVE.APV_BYCODE, HRUCFLEAVECODE.LEAVE_DESC, HRUCFLEAVEAPVBY.APV_POSDESC FROM HRLOGLEAVE, HRUCFLEAVECODE, HRUCFLEAVEAPVBY WHERE HRLOGLEAVE.LEAVE_CODE = HRUCFLEAVECODE.LEAVE_CODE AND HRLOGLEAVE.APV_BYCODE = HRUCFLEAVEAPVBY.APV_BYCODE DELETE FROM "HREMPLOYEE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO)) INSERT INTO "HREMPLOYEE" ("COOP_ID", "EMP_NO", "PRENAME_CODE", "EMP_NAME", "EMP_SURNAME", "EMP_ENAME", "EMP_ESURNAME", "EMP_NICKNAME", "EMPTYPE_CODE", "DEPTGRP_CODE", "POS_CODE", "SEX", "BLOOD_GRP", "WEIGHT", "HEIGHT", "NATION", "RELIGION", "ADN_NO", "ADN_TAMBOL", "ADN_AMPHUR", "ADN_PROVINCE", "ADN_POSTCODE", "ADN_TEL", "ADN_EMAIL", "ADR_NO", "ADR_TAMBOL", "ADR_AMPHUR", "ADR_PROVINCE", "ADR_POSTCODE", "ID_CARD", "BIRTH_DATE", "WORK_DATE", "RESIGN_DATE", "CONTAIN_DATE", "TERM_DATE", "SALARY_ID", "SALARY_AMT", "SALEXP_CODE", "SALEXP_BANK", "SALEXP_BRANCH", "SALEXP_ACCID", "TAX_CALCODE", "TAX_BFAMT", "SS_STATUS", "SS_APPFIRSTSTS", "SS_BFAMT", "SS_APPDATE", "SS_RATE", "SS_HOSPITAL", "PROVF_STATUS", "PROVF_CORPRATE", "PROVF_EMPRATE", "PROVF_APPDATE", "PROVF_RESIGNDATE", "PROVF_BFAMT", "REF_MEMBNO", "EMP_STATUS") VALUES (:COOP_ID, :EMP_NO, :PRENAME_CODE, :EMP_NAME, :EMP_SURNAME, :EMP_ENAME, :EMP_ESURNAME, :EMP_NICKNAME, :EMPTYPE_CODE, :DEPTGRP_CODE, :POS_CODE, :SEX, :BLOOD_GRP, :WEIGHT, :HEIGHT, :NATION, :RELIGION, :ADN_NO, :ADN_TAMBOL, :ADN_AMPHUR, :ADN_PROVINCE, :ADN_POSTCODE, :ADN_TEL, :ADN_EMAIL, :ADR_NO, :ADR_TAMBOL, :ADR_AMPHUR, :ADR_PROVINCE, :ADR_POSTCODE, :ID_CARD, :BIRTH_DATE, :WORK_DATE, :RESIGN_DATE, :CONTAIN_DATE, :TERM_DATE, :SALARY_ID, :SALARY_AMT, :SALEXP_CODE, :SALEXP_BANK, :SALEXP_BRANCH, :SALEXP_ACCID, :TAX_CALCODE, :TAX_BFAMT, :SS_STATUS, :SS_APPFIRSTSTS, :SS_BFAMT, :SS_APPDATE, :SS_RATE, :SS_HOSPITAL, :PROVF_STATUS, :PROVF_CORPRATE, :PROVF_EMPRATE, :PROVF_APPDATE, :PROVF_RESIGNDATE, :PROVF_BFAMT, :REF_MEMBNO, :EMP_STATUS) select * from hremployee UPDATE "HREMPLOYEE" SET "COOP_ID" = :COOP_ID, "EMP_NO" = :EMP_NO, "PRENAME_CODE" = :PRENAME_CODE, "EMP_NAME" = :EMP_NAME, "EMP_SURNAME" = :EMP_SURNAME, "EMP_ENAME" = :EMP_ENAME, "EMP_ESURNAME" = :EMP_ESURNAME, "EMP_NICKNAME" = :EMP_NICKNAME, "EMPTYPE_CODE" = :EMPTYPE_CODE, "DEPTGRP_CODE" = :DEPTGRP_CODE, "POS_CODE" = :POS_CODE, "SEX" = :SEX, "BLOOD_GRP" = :BLOOD_GRP, "WEIGHT" = :WEIGHT, "HEIGHT" = :HEIGHT, "NATION" = :NATION, "RELIGION" = :RELIGION, "ADN_NO" = :ADN_NO, "ADN_TAMBOL" = :ADN_TAMBOL, "ADN_AMPHUR" = :ADN_AMPHUR, "ADN_PROVINCE" = :ADN_PROVINCE, "ADN_POSTCODE" = :ADN_POSTCODE, "ADN_TEL" = :ADN_TEL, "ADN_EMAIL" = :ADN_EMAIL, "ADR_NO" = :ADR_NO, "ADR_TAMBOL" = :ADR_TAMBOL, "ADR_AMPHUR" = :ADR_AMPHUR, "ADR_PROVINCE" = :ADR_PROVINCE, "ADR_POSTCODE" = :ADR_POSTCODE, "ID_CARD" = :ID_CARD, "BIRTH_DATE" = :BIRTH_DATE, "WORK_DATE" = :WORK_DATE, "RESIGN_DATE" = :RESIGN_DATE, "CONTAIN_DATE" = :CONTAIN_DATE, "TERM_DATE" = :TERM_DATE, "SALARY_ID" = :SALARY_ID, "SALARY_AMT" = :SALARY_AMT, "SALEXP_CODE" = :SALEXP_CODE, "SALEXP_BANK" = :SALEXP_BANK, "SALEXP_BRANCH" = :SALEXP_BRANCH, "SALEXP_ACCID" = :SALEXP_ACCID, "TAX_CALCODE" = :TAX_CALCODE, "TAX_BFAMT" = :TAX_BFAMT, "SS_STATUS" = :SS_STATUS, "SS_APPFIRSTSTS" = :SS_APPFIRSTSTS, "SS_BFAMT" = :SS_BFAMT, "SS_APPDATE" = :SS_APPDATE, "SS_RATE" = :SS_RATE, "SS_HOSPITAL" = :SS_HOSPITAL, "PROVF_STATUS" = :PROVF_STATUS, "PROVF_CORPRATE" = :PROVF_CORPRATE, "PROVF_EMPRATE" = :PROVF_EMPRATE, "PROVF_APPDATE" = :PROVF_APPDATE, "PROVF_RESIGNDATE" = :PROVF_RESIGNDATE, "PROVF_BFAMT" = :PROVF_BFAMT, "REF_MEMBNO" = :REF_MEMBNO, "EMP_STATUS" = :EMP_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("EMP_NO" = :Original_EMP_NO))