select mbmembmaster.member_no, mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname, mbucfmembgroup.membgroup_desc, mbmembmaster.membgroup_code, mbmembmaster.member_type, mbmembmaster.membtype_code, mbmembmaster.member_status, mbmembmaster.member_date, mbucfmembtype.membtype_desc from mbmembmaster, mbucfprename, mbucfmembgroup, mbucfmembtype where ( mbucfprename.prename_code = mbmembmaster.prename_code ) and ( mbucfmembgroup.membgroup_code = mbmembmaster.membgroup_code ) and ( mbmembmaster.coop_id = mbucfmembgroup.coop_id ) and ( mbmembmaster.coop_id = mbucfmembtype.coop_id ) and ( mbmembmaster.membtype_code = mbucfmembtype.membtype_code ) select slslippayin.payinslip_no, slslippayin.sliptype_code, slslippayin.slip_date from slslippayin DELETE FROM "SLSLIPPAYIN" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYINSLIP_NO" = :Original_PAYINSLIP_NO)) INSERT INTO "SLSLIPPAYIN" ("COOP_ID", "PAYINSLIP_NO", "MEMCOOP_ID", "MEMBER_NO", "DOCUMENT_NO", "SLIPTYPE_CODE", "SLIP_DATE", "OPERATE_DATE", "SHARESTKBF_VALUE", "SHARESTK_VALUE", "INTACCUM_AMT", "MONEYTYPE_CODE", "FINBANKACC_NO", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "ACCID_FLAG", "TOFROM_ACCID", "REF_SYSTEM", "REF_SLIPNO", "REF_SLIPAMT", "SLIP_AMT", "SLIP_STATUS", "MEMBGROUP_CODE", "ENTRY_ID", "ENTRY_DATE", "CANCEL_ID", "CANCEL_DATE", "FINPOST_STATUS", "POSTTOVC_FLAG", "VOUCHER_NO", "CANCELTOVC_FLAG", "CANCELVC_NO") VALUES (:COOP_ID, :PAYINSLIP_NO, :MEMCOOP_ID, :MEMBER_NO, :DOCUMENT_NO, :SLIPTYPE_CODE, :SLIP_DATE, :OPERATE_DATE, :SHARESTKBF_VALUE, :SHARESTK_VALUE, :INTACCUM_AMT, :MONEYTYPE_CODE, :FINBANKACC_NO, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :ACCID_FLAG, :TOFROM_ACCID, :REF_SYSTEM, :REF_SLIPNO, :REF_SLIPAMT, :SLIP_AMT, :SLIP_STATUS, :MEMBGROUP_CODE, :ENTRY_ID, :ENTRY_DATE, :CANCEL_ID, :CANCEL_DATE, :FINPOST_STATUS, :POSTTOVC_FLAG, :VOUCHER_NO, :CANCELTOVC_FLAG, :CANCELVC_NO) select slslippayin.coop_id, slslippayin.payinslip_no, slslippayin.memcoop_id, slslippayin.member_no, slslippayin.document_no, slslippayin.sliptype_code, slslippayin.slip_date, slslippayin.operate_date, slslippayin.sharestkbf_value, slslippayin.sharestk_value, slslippayin.intaccum_amt, slslippayin.moneytype_code, slslippayin.finbankacc_no, slslippayin.expense_bank, slslippayin.expense_branch, slslippayin.expense_accid, slslippayin.accid_flag, slslippayin.tofrom_accid, slslippayin.ref_system, slslippayin.ref_slipno, slslippayin.ref_slipamt, slslippayin.slip_amt, slslippayin.slip_status, slslippayin.membgroup_code, slslippayin.entry_id, slslippayin.entry_date, slslippayin.cancel_id, slslippayin.cancel_date, slslippayin.finpost_status, slslippayin.posttovc_flag, slslippayin.voucher_no, slslippayin.canceltovc_flag, slslippayin.cancelvc_no from slslippayin UPDATE "SLSLIPPAYIN" SET "COOP_ID" = :COOP_ID, "PAYINSLIP_NO" = :PAYINSLIP_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "DOCUMENT_NO" = :DOCUMENT_NO, "SLIPTYPE_CODE" = :SLIPTYPE_CODE, "SLIP_DATE" = :SLIP_DATE, "OPERATE_DATE" = :OPERATE_DATE, "SHARESTKBF_VALUE" = :SHARESTKBF_VALUE, "SHARESTK_VALUE" = :SHARESTK_VALUE, "INTACCUM_AMT" = :INTACCUM_AMT, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "FINBANKACC_NO" = :FINBANKACC_NO, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "ACCID_FLAG" = :ACCID_FLAG, "TOFROM_ACCID" = :TOFROM_ACCID, "REF_SYSTEM" = :REF_SYSTEM, "REF_SLIPNO" = :REF_SLIPNO, "REF_SLIPAMT" = :REF_SLIPAMT, "SLIP_AMT" = :SLIP_AMT, "SLIP_STATUS" = :SLIP_STATUS, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "CANCEL_ID" = :CANCEL_ID, "CANCEL_DATE" = :CANCEL_DATE, "FINPOST_STATUS" = :FINPOST_STATUS, "POSTTOVC_FLAG" = :POSTTOVC_FLAG, "VOUCHER_NO" = :VOUCHER_NO, "CANCELTOVC_FLAG" = :CANCELTOVC_FLAG, "CANCELVC_NO" = :CANCELVC_NO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYINSLIP_NO" = :Original_PAYINSLIP_NO))