SELECT "MBMEMBMASTER"."MEMBER_NO", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBMEMBMASTER"."MEMBTYPE_CODE", "MBUCFMEMBTYPE"."MEMBTYPE_DESC", "MBMEMBMASTER"."ACCUM_INTEREST", "MBMEMBMASTER"."MEMBER_STATUS", "MBMEMBMASTER"."MEMBER_DATE" FROM "MBMEMBMASTER", "MBUCFMEMBGROUP", "MBUCFMEMBTYPE", "MBUCFPRENAME" WHERE ( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and ( "MBUCFMEMBTYPE"."MEMBTYPE_CODE" = "MBMEMBMASTER"."MEMBTYPE_CODE" ) and ( "MBUCFPRENAME"."PRENAME_CODE" = "MBMEMBMASTER"."PRENAME_CODE" ) SELECT "SHSHARETYPE"."SHARETYPE_DESC", "SHSHARETYPE"."SHARE_VALUE", "SHSHAREMASTER"."MEMBER_NO", "SHSHAREMASTER"."SHARETYPE_CODE", "SHSHAREMASTER"."SHARESTK_AMT" FROM "SHSHAREMASTER", "SHSHARETYPE" WHERE ( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) SELECT SHSHARETYPE.SHARE_VALUE , SHSHAREMASTER.* FROM SHSHAREMASTER , SHSHARETYPE WHERE ( SHSHAREMASTER.SHARETYPE_CODE = SHSHARETYPE.SHARETYPE_CODE ) DELETE FROM "SHSHARESTATEMENT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SHARETYPE_CODE" = :Original_SHARETYPE_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "SHSHARESTATEMENT" ("COOP_ID", "MEMBER_NO", "SHARETYPE_CODE", "SEQ_NO", "SLIP_DATE", "OPERATE_DATE", "SHARE_DATE", "ACCOUNT_DATE", "REF_DOCNO", "REF_SLIPNO", "SHRITEMTYPE_CODE", "PERIOD", "SHARE_AMOUNT", "SHARESTK_AMT", "SHRARREARBF_AMT", "SHRARREAR_AMT", "MONEYTYPE_CODE", "ITEM_STATUS", "ENTRY_ID", "ENTRY_DATE", "ENTRY_BYCOOPID", "STATUS_DESC", "REMARK", "CALDIV_STATUS") VALUES (:COOP_ID, :MEMBER_NO, :SHARETYPE_CODE, :SEQ_NO, :SLIP_DATE, :OPERATE_DATE, :SHARE_DATE, :ACCOUNT_DATE, :REF_DOCNO, :REF_SLIPNO, :SHRITEMTYPE_CODE, :PERIOD, :SHARE_AMOUNT, :SHARESTK_AMT, :SHRARREARBF_AMT, :SHRARREAR_AMT, :MONEYTYPE_CODE, :ITEM_STATUS, :ENTRY_ID, :ENTRY_DATE, :ENTRY_BYCOOPID, :STATUS_DESC, :REMARK, :CALDIV_STATUS) SELECT SHSHARESTATEMENT.* FROM SHSHARESTATEMENT UPDATE "SHSHARESTATEMENT" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "SHARETYPE_CODE" = :SHARETYPE_CODE, "SEQ_NO" = :SEQ_NO, "SLIP_DATE" = :SLIP_DATE, "OPERATE_DATE" = :OPERATE_DATE, "SHARE_DATE" = :SHARE_DATE, "ACCOUNT_DATE" = :ACCOUNT_DATE, "REF_DOCNO" = :REF_DOCNO, "REF_SLIPNO" = :REF_SLIPNO, "SHRITEMTYPE_CODE" = :SHRITEMTYPE_CODE, "PERIOD" = :PERIOD, "SHARE_AMOUNT" = :SHARE_AMOUNT, "SHARESTK_AMT" = :SHARESTK_AMT, "SHRARREARBF_AMT" = :SHRARREARBF_AMT, "SHRARREAR_AMT" = :SHRARREAR_AMT, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "ITEM_STATUS" = :ITEM_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "ENTRY_BYCOOPID" = :ENTRY_BYCOOPID, "STATUS_DESC" = :STATUS_DESC, "REMARK" = :REMARK, "CALDIV_STATUS" = :CALDIV_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SHARETYPE_CODE" = :Original_SHARETYPE_CODE) AND ("SEQ_NO" = :Original_SEQ_NO))