select lm.loancontract_no, ct.loancolltype_desc, lc.ref_collno, lc.description, nvl( lm.principal_balance, 0 )+nvl( lm.withdrawable_amt, 0 ) as prnbal_amt, lc.collactive_percent, ( nvl( lm.principal_balance, 0 )+nvl( lm.withdrawable_amt, 0 ) ) * ( lc.collactive_percent / 100 ) as collactive_amt from lncontmaster lm, lncontcoll lc,lnucfloancolltype ct where ( lm.coop_id = lc.coop_id ) and ( lm.loancontract_no = lc.loancontract_no ) and ( ct.loancolltype_code = lc.loancolltype_code ) and ( lm.contract_status > 0 ) SELECT "KPTEMPRECEIVEDET"."MEMBER_NO", "KPTEMPRECEIVE"."RECEIPT_NO", "KPTEMPRECEIVEDET"."RECV_PERIOD", "KPTEMPRECEIVEDET"."KEEPITEMTYPE_CODE", "KPTEMPRECEIVEDET"."DESCRIPTION", "KPTEMPRECEIVEDET"."PERIOD", "KPTEMPRECEIVEDET"."PRINCIPAL_PAYMENT", "KPTEMPRECEIVEDET"."INTEREST_PAYMENT", "KPTEMPRECEIVEDET"."ITEM_PAYMENT", "KPTEMPRECEIVEDET"."LOANCONTRACT_NO", "KPTEMPRECEIVE"."KEEPING_STATUS", "KPTEMPRECEIVEDET"."KEEPITEM_STATUS", "KPTEMPRECEIVEDET"."REF_MEMBNO", "KPTEMPRECEIVE"."MEMBER_NO", "KPUCFKEEPITEMTYPE"."SORT_IN_RECEIVE", "KPTEMPRECEIVEDET"."ITEM_BALANCE", "KPTEMPRECEIVEDET"."SHRLONTYPE_CODE", "KPUCFKEEPITEMTYPE"."SIGN_FLAG" FROM "KPTEMPRECEIVE", "KPTEMPRECEIVEDET", "KPUCFKEEPITEMTYPE" WHERE ( "KPTEMPRECEIVE"."KPSLIP_NO" = "KPTEMPRECEIVEDET"."KPSLIP_NO" ) and ( "KPTEMPRECEIVEDET"."KEEPITEMTYPE_CODE" = "KPUCFKEEPITEMTYPE"."KEEPITEMTYPE_CODE" ) and ( "KPTEMPRECEIVE"."COOP_ID" = "KPTEMPRECEIVEDET"."COOP_ID" ) and ( "KPTEMPRECEIVE"."COOP_ID" = "KPUCFKEEPITEMTYPE"."COOP_ID" ) DELETE FROM "MBGAINMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "MBGAINMASTER" ("COOP_ID", "MEMBER_NO", "SEQ_NO", "GAIN_NAME", "GAIN_SURNAME", "GAIN_ADDR", "GAIN_RELATION", "REMARK", "WRITE_DATE", "WRITE_AT", "AGE") VALUES (:COOP_ID, :MEMBER_NO, :SEQ_NO, :GAIN_NAME, :GAIN_SURNAME, :GAIN_ADDR, :GAIN_RELATION, :REMARK, :WRITE_DATE, :WRITE_AT, :AGE) SELECT "MBGAINMASTER"."COOP_ID", "MBGAINMASTER"."MEMBER_NO", "MBGAINMASTER"."SEQ_NO", "MBGAINMASTER"."GAIN_NAME", "MBGAINMASTER"."GAIN_SURNAME", "MBGAINMASTER"."GAIN_ADDR", "MBGAINMASTER"."GAIN_RELATION", "MBGAINMASTER"."REMARK", "MBGAINMASTER"."WRITE_DATE", "MBGAINMASTER"."WRITE_AT", "MBGAINMASTER"."AGE" FROM "MBGAINMASTER" UPDATE "MBGAINMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "SEQ_NO" = :SEQ_NO, "GAIN_NAME" = :GAIN_NAME, "GAIN_SURNAME" = :GAIN_SURNAME, "GAIN_ADDR" = :GAIN_ADDR, "GAIN_RELATION" = :GAIN_RELATION, "REMARK" = :REMARK, "WRITE_DATE" = :WRITE_DATE, "WRITE_AT" = :WRITE_AT, "AGE" = :AGE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) SELECT "LNINSURANCEFIRE"."INSURANCE_NO", "LNINSURANCEFIRE"."MEMBER_NO", "LNINSURANCEFIRE"."LOANCONTRACT_NO", "LNINSURANCEFIRE"."PRINCIPAL_BALANCE", "LNINSURANCEFIRE"."STARTINSURE_DATE", "LNINSURANCEFIRE"."EXPIREINSURE_DATE", "LNINSURANCEFIRE"."INSURANCE_AMT", "LNINSURANCEFIRE"."INSURENET_AMT", "LNINSURANCEFIRE"."INSUREPAY_STATUS" FROM "LNINSURANCEFIRE" SELECT "KPUCFKEEPOTHITEMTYPE"."KEEPOTHITEMTYPE_CODE", "KPUCFKEEPOTHITEMTYPE"."KEEPOTHITEMTYPE_DESC", "KPRCVKEEPOTHER"."KEEPOTHER_TYPE", "KPRCVKEEPOTHER"."STARTKEEP_PERIOD", "KPRCVKEEPOTHER"."LASTKEEP_PERIOD", "KPRCVKEEPOTHER"."DESCRIPTION", "KPRCVKEEPOTHER"."ITEM_PAYMENT" FROM "KPRCVKEEPOTHER", "KPUCFKEEPOTHITEMTYPE" WHERE ( "KPRCVKEEPOTHER"."COOP_ID" = "KPUCFKEEPOTHITEMTYPE"."COOP_ID" ) SELECT lnloantype.loantype_code, lnloantype.loantype_desc, lnmembpauseloan.pauseloan_cause FROM lnmembpauseloan, lnloantype WHERE ( lnmembpauseloan.loantype_code = lnloantype.loantype_code ) select memold_no, memnew_no, apv_date, apv_id from mbreqtranmb SELECT KPMASTRECEIVE.MEMBER_NO, KPMASTRECEIVE.RECV_PERIOD, KPMASTRECEIVE.REF_MEMBNO, KPMASTRECEIVE.RECEIPT_NO, KPMASTRECEIVE.RECEIPT_DATE, KPMASTRECEIVE.MEMBGROUP_CODE, KPMASTRECEIVE.KEEPING_STATUS, KPMASTRECEIVE.RECEIVE_AMT FROM KPMASTRECEIVE select lm.member_no, mpre.prename_desc,mb.memb_name,mb.memb_surname , ( sm.sharestk_amt * 10 ) as sharestk_value, lc.loancontract_no, nvl( lm.principal_balance, 0 )+nvl( lm.withdrawable_amt, 0 ) as prnbal_amt, lc.collactive_percent, (nvl( lm.principal_balance, 0 )+nvl( lm.withdrawable_amt, 0 ))*( lc.collactive_percent / 100 ) as collactive_amt from lncontcoll lc, lncontmaster lm, mbmembmaster mb, mbucfprename mpre, shsharemaster sm where ( lc.coop_id = lm.coop_id ) and ( lc.loancontract_no = lm.loancontract_no ) and ( lm.memcoop_id = mb.coop_id ) and ( lm.member_no = mb.member_no ) and ( lm.memcoop_id = sm.coop_id ) and ( lm.member_no = sm.member_no ) and ( mb.prename_code = mpre.prename_code ) and ( lc.loancolltype_code = '01' ) and ( lm.contract_status > 0 ) DELETE FROM "WRTFUNDSTATEMENT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "WRTFUNDSTATEMENT" ("COOP_ID", "MEMBER_NO", "SEQ_NO", "OPERATE_DATE", "WRTITEMTYPE_CODE", "WRTFUND_AMT", "WRTFUND_BALANCE", "REF_CONTNO", "MONEYTYPE_CODE", "ITEM_STATUS", "ENTRY_ID", "ENTRY_DATE", "REF_DOCNO") VALUES (:COOP_ID, :MEMBER_NO, :SEQ_NO, :OPERATE_DATE, :WRTITEMTYPE_CODE, :WRTFUND_AMT, :WRTFUND_BALANCE, :REF_CONTNO, :MONEYTYPE_CODE, :ITEM_STATUS, :ENTRY_ID, :ENTRY_DATE, :REF_DOCNO) select * from wrtfundstatement UPDATE "WRTFUNDSTATEMENT" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "SEQ_NO" = :SEQ_NO, "OPERATE_DATE" = :OPERATE_DATE, "WRTITEMTYPE_CODE" = :WRTITEMTYPE_CODE, "WRTFUND_AMT" = :WRTFUND_AMT, "WRTFUND_BALANCE" = :WRTFUND_BALANCE, "REF_CONTNO" = :REF_CONTNO, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "ITEM_STATUS" = :ITEM_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "REF_DOCNO" = :REF_DOCNO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SEQ_NO" = :Original_SEQ_NO))