DELETE FROM "LNGRPMANGRTPERMDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MANGRTPERMGRP_CODE" = :Original_MANGRTPERMGRP_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNGRPMANGRTPERMDET" ("COOP_ID", "MANGRTPERMGRP_CODE", "SEQ_NO", "STARTSHARE_AMT", "ENDSHARE_AMT", "STARTMEMBER_TIME", "ENDMEMBER_TIME", "START_SALARY", "END_SALARY", "PERCENTSHARE", "PERCENTSALARY", "MAXGRT_AMT", "MULTIPLE_SHARE", "MULTIPLE_SALARY") VALUES (:COOP_ID, :MANGRTPERMGRP_CODE, :SEQ_NO, :STARTSHARE_AMT, :ENDSHARE_AMT, :STARTMEMBER_TIME, :ENDMEMBER_TIME, :START_SALARY, :END_SALARY, :PERCENTSHARE, :PERCENTSALARY, :MAXGRT_AMT, :MULTIPLE_SHARE, :MULTIPLE_SALARY) SELECT COOP_ID, MANGRTPERMGRP_CODE, SEQ_NO, STARTSHARE_AMT, ENDSHARE_AMT, STARTMEMBER_TIME, ENDMEMBER_TIME, START_SALARY, END_SALARY, PERCENTSHARE, PERCENTSALARY, MAXGRT_AMT, MULTIPLE_SHARE, MULTIPLE_SALARY FROM LNGRPMANGRTPERMDET UPDATE "LNGRPMANGRTPERMDET" SET "COOP_ID" = :COOP_ID, "MANGRTPERMGRP_CODE" = :MANGRTPERMGRP_CODE, "SEQ_NO" = :SEQ_NO, "STARTSHARE_AMT" = :STARTSHARE_AMT, "ENDSHARE_AMT" = :ENDSHARE_AMT, "STARTMEMBER_TIME" = :STARTMEMBER_TIME, "ENDMEMBER_TIME" = :ENDMEMBER_TIME, "START_SALARY" = :START_SALARY, "END_SALARY" = :END_SALARY, "PERCENTSHARE" = :PERCENTSHARE, "PERCENTSALARY" = :PERCENTSALARY, "MAXGRT_AMT" = :MAXGRT_AMT, "MULTIPLE_SHARE" = :MULTIPLE_SHARE, "MULTIPLE_SALARY" = :MULTIPLE_SALARY WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MANGRTPERMGRP_CODE" = :Original_MANGRTPERMGRP_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNGRPMANGRTPERM" WHERE (("MANGRTPERMGRP_CODE" = :Original_MANGRTPERMGRP_CODE) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNGRPMANGRTPERM" ("MANGRTPERMGRP_CODE", "MANGRTPERMGRP_DESC", "MANGRTTIME_TYPE", "MEMBER_TYPE", "GRTRIGHT_CONTFLAG", "GRTRIGHT_MEMFLAG", "GRTRIGHT_CONTRACT", "GRTRIGHT_MEMBER", "COOP_ID", "MEMBER_TIME") VALUES (:MANGRTPERMGRP_CODE, :MANGRTPERMGRP_DESC, :MANGRTTIME_TYPE, :MEMBER_TYPE, :GRTRIGHT_CONTFLAG, :GRTRIGHT_MEMFLAG, :GRTRIGHT_CONTRACT, :GRTRIGHT_MEMBER, :COOP_ID, :MEMBER_TIME) SELECT MANGRTPERMGRP_CODE, MANGRTPERMGRP_DESC, MANGRTTIME_TYPE, MEMBER_TYPE, GRTRIGHT_CONTFLAG, GRTRIGHT_MEMFLAG, GRTRIGHT_CONTRACT, GRTRIGHT_MEMBER, COOP_ID, member_time FROM LNGRPMANGRTPERM UPDATE "LNGRPMANGRTPERM" SET "MANGRTPERMGRP_CODE" = :MANGRTPERMGRP_CODE, "MANGRTPERMGRP_DESC" = :MANGRTPERMGRP_DESC, "MANGRTTIME_TYPE" = :MANGRTTIME_TYPE, "MEMBER_TYPE" = :MEMBER_TYPE, "GRTRIGHT_CONTFLAG" = :GRTRIGHT_CONTFLAG, "GRTRIGHT_MEMFLAG" = :GRTRIGHT_MEMFLAG, "GRTRIGHT_CONTRACT" = :GRTRIGHT_CONTRACT, "GRTRIGHT_MEMBER" = :GRTRIGHT_MEMBER, "COOP_ID" = :COOP_ID, "MEMBER_TIME" = :MEMBER_TIME WHERE (("MANGRTPERMGRP_CODE" = :Original_MANGRTPERMGRP_CODE) AND ("COOP_ID" = :Original_COOP_ID))