SELECT "LNCONTCOLL"."REF_COLLNO", "LNCONTMASTER"."LOANCONTRACT_NO", "LNCONTMASTER"."MEMBER_NO", "LNCONTMASTER"."LOANTYPE_CODE", "LNCONTMASTER"."LOANAPPROVE_AMT", "LNCONTMASTER"."WITHDRAWABLE_AMT", "LNCONTMASTER"."PRINCIPAL_BALANCE", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "LNLOANTYPE"."PREFIX", "LNCONTCOLL"."COLL_PERCENT", "LNCONTCOLL"."BASE_PERCENT", "LNLOANTYPE"."LOANTYPE_DESC" FROM "LNCONTCOLL", "LNCONTMASTER", "MBMEMBMASTER", "MBUCFPRENAME", "LNLOANTYPE" WHERE ( "LNCONTMASTER"."LOANCONTRACT_NO" = "LNCONTCOLL"."LOANCONTRACT_NO" ) and ( "MBMEMBMASTER"."MEMBER_NO" = "LNCONTMASTER"."MEMBER_NO" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "LNCONTMASTER"."LOANTYPE_CODE" = "LNLOANTYPE"."LOANTYPE_CODE" ) and ( "MBMEMBMASTER"."COOP_ID" = "LNCONTMASTER"."COOP_ID" ) and ( "LNCONTMASTER"."COOP_ID" = "LNCONTCOLL"."COOP_ID" ) and ( "LNCONTMASTER"."COOP_ID" = "LNLOANTYPE"."COOP_ID" ) select lnreqloan.loanrequest_docno, lnreqloan.member_no, lnreqloan.loantype_code, lnreqloan.loanrequest_amt, lnreqloancoll.collactive_amt, lnreqloancoll.collactive_percent, lnreqloancoll.loancolltype_code, lnreqloancoll.collbase_percent, lnloantype.cntmangrtval_flag, lnloantype.mangrtpermgrp_code, mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname from lnreqloan, lnreqloancoll, lnloantype, mbmembmaster, mbucfprename where ( lnreqloancoll.loanrequest_docno = lnreqloan.loanrequest_docno ) and ( lnreqloan.loantype_code = lnloantype.loantype_code ) and ( lnreqloan.member_no = mbmembmaster.member_no ) and ( mbucfprename.prename_code = mbmembmaster.prename_code ) and ( lnreqloan.coop_id = lnreqloancoll.coop_id ) and ( lnreqloan.coop_id = lnloantype.coop_id ) and ( lnreqloan.coop_id = mbmembmaster.coop_id ) and ( ( lnreqloan.loanrequest_status in (8,11) ) and ( lnreqloancoll.ref_collno = :as_refcollno ) and ( lnreqloancoll.loancolltype_code = :as_lncolltype ) ) SELECT MANGRTPERMGRP_CODE, MANGRTPERMGRP_DESC, MANGRTTIME_TYPE, EXPORTRIGTH_FLAG, MEMBER_TYPE FROM LNGRPMANGRTPERM SELECT "MBMEMBMASTER"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBMEMBMASTER"."BIRTH_DATE", "MBMEMBMASTER"."MEMBER_DATE", "MBMEMBMASTER"."SALARY_AMOUNT", "MBMEMBMASTER"."WORK_DATE", "MBMEMBMASTER"."RETRY_DATE", "SHSHAREMASTER"."SHARESTK_AMT", "SHSHAREMASTER"."LAST_PERIOD", "SHSHAREMASTER"."PERIODSHARE_AMT", "SHSHAREMASTER"."PAYMENT_STATUS", "SHSHAREMASTER"."SHAREARREAR_AMT", "SHSHARETYPE"."UNITSHARE_VALUE", "MBUCFMEMBTYPE"."MEMBTYPE_CODE", "MBUCFMEMBTYPE"."MEMBTYPE_DESC", "MBMEMBMASTER"."APPLTYPE_CODE", "MBMEMBMASTER"."MEMBER_TYPE", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME" , "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."RESIGN_STATUS" FROM "MBMEMBMASTER", "MBUCFMEMBGROUP", "SHSHAREMASTER", "SHSHARETYPE", "MBUCFMEMBTYPE", "MBUCFPRENAME" WHERE ( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and ( "SHSHAREMASTER"."MEMBER_NO" = "MBMEMBMASTER"."MEMBER_NO" ) and ( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) and ( "MBMEMBMASTER"."MEMBTYPE_CODE" = "MBUCFMEMBTYPE"."MEMBTYPE_CODE" ) and ( "MBMEMBMASTER"."COOP_ID" = "MBUCFMEMBGROUP"."COOP_ID" ) and ( "MBMEMBMASTER"."COOP_ID" = "SHSHAREMASTER"."COOP_ID" ) and ( "MBMEMBMASTER"."COOP_ID" = "MBUCFMEMBTYPE"."COOP_ID" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "SHSHAREMASTER"."COOP_ID" = "SHSHARETYPE"."COOP_ID" ) SELECT "DPDEPTMASTER"."DEPTACCOUNT_NO", "DPDEPTMASTER"."DEPTTYPE_CODE", "DPDEPTTYPE"."DEPTTYPE_DESC", "DPDEPTMASTER"."MEMBER_NO", "DPDEPTMASTER"."DEPTOPEN_DATE", "DPDEPTMASTER"."DEPTACCOUNT_NAME", "DPDEPTMASTER"."BEGINBAL", "DPDEPTMASTER"."PRNCBAL", "DPDEPTMASTER"."WITHDRAWABLE_AMT", "DPDEPTMASTER"."SEQUEST_AMOUNT", "DPDEPTMASTER"."DEPTCLOSE_DATE", "DPDEPTMASTER"."DEPTCLOSE_STATUS" FROM "DPDEPTMASTER", "DPDEPTTYPE" WHERE ( "DPDEPTTYPE"."DEPTTYPE_CODE" = "DPDEPTMASTER"."DEPTTYPE_CODE" ) and ( "DPDEPTMASTER"."COOP_ID" = "DPDEPTTYPE"."COOP_ID" ) DELETE FROM "LNCOLLMASTER" WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNCOLLMASTER" ("COLLMAST_NO", "MEMBER_NO", "COLLMAST_REFNO", "COLLMASTTYPE_CODE", "COLLMAST_DESC", "LANDESTIMATE_AMT", "HOUSEESTIMATE_AMT", "ESTIMATE_PRICE", "MORTGAGE_PRICE", "MORTGAGE_DATE", "EXPIRE_DATE", "REDEEM_FLAG", "REDEEM_DATE", "REMARK", "LAND_NO", "SURVEY_NO", "BOOK_NO", "PAGE_NO", "GROUP_NO", "COOP_ID") VALUES (:COLLMAST_NO, :MEMBER_NO, :COLLMAST_REFNO, :COLLMASTTYPE_CODE, :COLLMAST_DESC, :LANDESTIMATE_AMT, :HOUSEESTIMATE_AMT, :ESTIMATE_PRICE, :MORTGAGE_PRICE, :MORTGAGE_DATE, :EXPIRE_DATE, :REDEEM_FLAG, :REDEEM_DATE, :REMARK, :LAND_NO, :SURVEY_NO, :BOOK_NO, :PAGE_NO, :GROUP_NO, :COOP_ID) SELECT "LNCOLLMASTER"."COLLMAST_NO", "LNCOLLMASTER"."MEMBER_NO", "LNCOLLMASTER"."COLLMAST_REFNO", "LNCOLLMASTER"."COLLMASTTYPE_CODE", "LNCOLLMASTER"."COLLMAST_DESC", "LNCOLLMASTER"."LANDESTIMATE_AMT", "LNCOLLMASTER"."HOUSEESTIMATE_AMT", "LNCOLLMASTER"."ESTIMATE_PRICE", "LNCOLLMASTER"."MORTGAGE_PRICE", "LNCOLLMASTER"."MORTGAGE_DATE", "LNCOLLMASTER"."EXPIRE_DATE", "LNCOLLMASTER"."REDEEM_FLAG", "LNCOLLMASTER"."REDEEM_DATE", "LNCOLLMASTER"."REMARK", "LNCOLLMASTER"."LAND_NO", "LNCOLLMASTER"."SURVEY_NO", "LNCOLLMASTER"."BOOK_NO", "LNCOLLMASTER"."PAGE_NO", "LNCOLLMASTER"."GROUP_NO", "LNCOLLMASTER"."COOP_ID" FROM "LNCOLLMASTER" UPDATE "LNCOLLMASTER" SET "COLLMAST_NO" = :COLLMAST_NO, "MEMBER_NO" = :MEMBER_NO, "COLLMAST_REFNO" = :COLLMAST_REFNO, "COLLMASTTYPE_CODE" = :COLLMASTTYPE_CODE, "COLLMAST_DESC" = :COLLMAST_DESC, "LANDESTIMATE_AMT" = :LANDESTIMATE_AMT, "HOUSEESTIMATE_AMT" = :HOUSEESTIMATE_AMT, "ESTIMATE_PRICE" = :ESTIMATE_PRICE, "MORTGAGE_PRICE" = :MORTGAGE_PRICE, "MORTGAGE_DATE" = :MORTGAGE_DATE, "EXPIRE_DATE" = :EXPIRE_DATE, "REDEEM_FLAG" = :REDEEM_FLAG, "REDEEM_DATE" = :REDEEM_DATE, "REMARK" = :REMARK, "LAND_NO" = :LAND_NO, "SURVEY_NO" = :SURVEY_NO, "BOOK_NO" = :BOOK_NO, "PAGE_NO" = :PAGE_NO, "GROUP_NO" = :GROUP_NO, "COOP_ID" = :COOP_ID WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) SELECT "LNCOLLMASTMEMCO"."COLLMAST_NO", "LNCOLLMASTMEMCO"."MEMCO_NO", "LNCOLLMASTMEMCO"."COLLMASTMAIN_FLAG", "MBUCFPRENAME"."PRENAME_SHORT", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME" FROM "LNCOLLMASTMEMCO", "MBMEMBMASTER", "MBUCFPRENAME" WHERE ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "LNCOLLMASTMEMCO"."MEMCO_NO" = "MBMEMBMASTER"."MEMBER_NO" )