SELECT MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBUCFMEMBGROUP.MEMBGROUP_DESC, SLSLIPPAYOUT.COOP_ID, SLSLIPPAYOUT.PAYOUTSLIP_NO, SLSLIPPAYOUT.MEMCOOP_ID, SLSLIPPAYOUT.MEMBER_NO, SLSLIPPAYOUT.DOCUMENT_NO, SLSLIPPAYOUT.POSTSLIP_NO, SLSLIPPAYOUT.SLIPTYPE_CODE, SLSLIPPAYOUT.SLIP_DATE, SLSLIPPAYOUT.OPERATE_DATE, SLSLIPPAYOUT.SHRLONTYPE_CODE, SLSLIPPAYOUT.CONCOOP_ID, SLSLIPPAYOUT.LOANCONTRACT_NO, SLSLIPPAYOUT.RCVPERIOD_FLAG, SLSLIPPAYOUT.RCV_PERIOD, SLSLIPPAYOUT.PAYOUT_AMT, SLSLIPPAYOUT.PAYOUTCLR_AMT, SLSLIPPAYOUT.PAYOUTNET_AMT, SLSLIPPAYOUT.BFPERIOD, SLSLIPPAYOUT.BFSHRCONT_BALAMT, SLSLIPPAYOUT.BFLASTRECEIVE_DATE, SLSLIPPAYOUT.BFCONTLAW_STATUS, SLSLIPPAYOUT.MONEYTYPE_CODE, SLSLIPPAYOUT.EXPENSE_BANK, SLSLIPPAYOUT.EXPENSE_BRANCH, SLSLIPPAYOUT.EXPENSE_ACCID, SLSLIPPAYOUT.BANKFEE_AMT, SLSLIPPAYOUT.BANKSRV_AMT, SLSLIPPAYOUT.ACCID_FLAG, SLSLIPPAYOUT.TOFROM_ACCID, SLSLIPPAYOUT.SLIP_STATUS, SLSLIPPAYOUT.SLIPCLEAR_NO, SLSLIPPAYOUT.MEMBGROUP_CODE, SLSLIPPAYOUT.ENTRY_ID, SLSLIPPAYOUT.ENTRY_DATE, SLSLIPPAYOUT.ENTRY_BYCOOPID FROM SLSLIPPAYOUT, MBMEMBMASTER, MBUCFPRENAME, MBUCFMEMBGROUP WHERE ( SLSLIPPAYOUT.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( SLSLIPPAYOUT.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and ( MBMEMBMASTER.COOP_ID = MBUCFMEMBGROUP.COOP_ID ) and ( MBMEMBMASTER.MEMBGROUP_CODE = MBUCFMEMBGROUP.MEMBGROUP_CODE ) DELETE FROM "SLSLIPPAYOUTDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYOUTSLIP_NO" = :Original_PAYOUTSLIP_NO) AND ("SLIPITEMTYPE_CODE" = :Original_SLIPITEMTYPE_CODE) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "SLSLIPPAYOUTDET" ("COOP_ID", "PAYOUTSLIP_NO", "SLIPITEMTYPE_CODE", "SEQ_NO", "SHRLONTYPE_CODE", "CONCOOP_ID", "LOANCONTRACT_NO", "DEPACCOUNT_NO", "SLIPITEM_DESC", "PRINCIPAL_PAYAMT", "INTEREST_PAYAMT", "ITEM_PAYAMT", "REF_DOCNO", "BFSHRCONT_BALAMT", "BFCONTLAW_STATUS") VALUES (:COOP_ID, :PAYOUTSLIP_NO, :SLIPITEMTYPE_CODE, :SEQ_NO, :SHRLONTYPE_CODE, :CONCOOP_ID, :LOANCONTRACT_NO, :DEPACCOUNT_NO, :SLIPITEM_DESC, :PRINCIPAL_PAYAMT, :INTEREST_PAYAMT, :ITEM_PAYAMT, :REF_DOCNO, :BFSHRCONT_BALAMT, :BFCONTLAW_STATUS) SELECT 0 as operate_flag, "SLSLIPPAYOUTDET"."COOP_ID", "SLSLIPPAYOUTDET"."PAYOUTSLIP_NO", "SLSLIPPAYOUTDET"."SLIPITEMTYPE_CODE", "SLSLIPPAYOUTDET"."SEQ_NO", "SLSLIPPAYOUTDET"."SHRLONTYPE_CODE", "SLSLIPPAYOUTDET"."CONCOOP_ID", "SLSLIPPAYOUTDET"."LOANCONTRACT_NO", "SLSLIPPAYOUTDET"."DEPACCOUNT_NO", "SLSLIPPAYOUTDET"."SLIPITEM_DESC", "SLSLIPPAYOUTDET"."PRINCIPAL_PAYAMT", "SLSLIPPAYOUTDET"."INTEREST_PAYAMT", "SLSLIPPAYOUTDET"."ITEM_PAYAMT", "SLSLIPPAYOUTDET"."REF_DOCNO", "SLSLIPPAYOUTDET"."BFSHRCONT_BALAMT", "SLSLIPPAYOUTDET"."BFCONTLAW_STATUS" FROM "SLSLIPPAYOUTDET" UPDATE "SLSLIPPAYOUTDET" SET "COOP_ID" = :COOP_ID, "PAYOUTSLIP_NO" = :PAYOUTSLIP_NO, "SLIPITEMTYPE_CODE" = :SLIPITEMTYPE_CODE, "SEQ_NO" = :SEQ_NO, "SHRLONTYPE_CODE" = :SHRLONTYPE_CODE, "CONCOOP_ID" = :CONCOOP_ID, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "DEPACCOUNT_NO" = :DEPACCOUNT_NO, "SLIPITEM_DESC" = :SLIPITEM_DESC, "PRINCIPAL_PAYAMT" = :PRINCIPAL_PAYAMT, "INTEREST_PAYAMT" = :INTEREST_PAYAMT, "ITEM_PAYAMT" = :ITEM_PAYAMT, "REF_DOCNO" = :REF_DOCNO, "BFSHRCONT_BALAMT" = :BFSHRCONT_BALAMT, "BFCONTLAW_STATUS" = :BFCONTLAW_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("PAYOUTSLIP_NO" = :Original_PAYOUTSLIP_NO) AND ("SLIPITEMTYPE_CODE" = :Original_SLIPITEMTYPE_CODE) AND ("SEQ_NO" = :Original_SEQ_NO))