SELECT MBMEMBMASTER.MEMBER_NO, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.MEMBGROUP_CODE, MBUCFMEMBGROUP.MEMBGROUP_DESC, MBMEMBMASTER.ACCUM_INTEREST, MBMEMBMASTER.RESIGN_STATUS, MBMEMBMASTER.REMARK, SHSHAREMASTER.SHAREBEGIN_AMT, SHSHARETYPE.UNITSHARE_VALUE , SHSHAREMASTER.SHARESTK_AMT FROM MBMEMBMASTER, MBUCFPRENAME, MBUCFMEMBGROUP, SHSHAREMASTER, SHSHARETYPE WHERE ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and ( MBUCFMEMBGROUP.MEMBGROUP_CODE = MBMEMBMASTER.MEMBGROUP_CODE ) and ( SHSHARETYPE.SHARETYPE_CODE = SHSHAREMASTER.SHARETYPE_CODE ) and ( MBMEMBMASTER.MEMBER_NO = SHSHAREMASTER.MEMBER_NO ) DELETE FROM "LNCOLLMASTER" WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "LNCOLLMASTER" ("COLLMAST_NO", "COLLMAST_REFNO", "COLLMASTTYPE_CODE", "COLLMAST_DESC", "MORTGAGE_PRICE", "REDEEM_FLAG", "COOP_ID", "LANDESTIMATE_AMT", "HOUSEESTIMATE_AMT", "ESTIMATE_PRICE", "MORTGAGE_DATE", "EXPIRE_DATE", "REDEEM_DATE", "REMARK", "BLINDLAND_FLAG", "MEMBER_NO", "LANDSIDE_NO", "COLLRELATION_CODE") VALUES (:COLLMAST_NO, :COLLMAST_REFNO, :COLLMASTTYPE_CODE, :COLLMAST_DESC, :MORTGAGE_PRICE, :REDEEM_FLAG, :COOP_ID, :LANDESTIMATE_AMT, :HOUSEESTIMATE_AMT, :ESTIMATE_PRICE, :MORTGAGE_DATE, :EXPIRE_DATE, :REDEEM_DATE, :REMARK, :BLINDLAND_FLAG, :MEMBER_NO, :LANDSIDE_NO, :COLLRELATION_CODE) SELECT LNCOLLMASTER.COLLMAST_NO, LNCOLLMASTER.COLLMAST_REFNO, LNCOLLMASTER.COLLMASTTYPE_CODE, LNCOLLMASTER.COLLMAST_DESC, LNCOLLMASTER.MORTGAGE_PRICE, LNCOLLMASTER.REDEEM_FLAG, LNCOLLMASTER.COOP_ID , LNCOLLMASTER.LANDESTIMATE_AMT, LNCOLLMASTER.HOUSEESTIMATE_AMT, LNCOLLMASTER.ESTIMATE_PRICE, LNCOLLMASTER.MORTGAGE_DATE, LNCOLLMASTER.EXPIRE_DATE, LNCOLLMASTER.REDEEM_DATE, LNCOLLMASTER.REMARK, LNCOLLMASTER.BLINDLAND_FLAG, LNCOLLMASTER.MEMBER_NO, LNCOLLMASTER.LANDSIDE_NO, LNCOLLMASTER.COLLRELATION_CODE FROM LNCOLLMASTER, LNCOLLMASTMEMCO WHERE ( LNCOLLMASTER.COLLMAST_NO = LNCOLLMASTMEMCO.COLLMAST_NO ) and ( LNCOLLMASTER.COOP_ID = LNCOLLMASTMEMCO.COOP_ID ) UPDATE "LNCOLLMASTER" SET "COLLMAST_NO" = :COLLMAST_NO, "COLLMAST_REFNO" = :COLLMAST_REFNO, "COLLMASTTYPE_CODE" = :COLLMASTTYPE_CODE, "COLLMAST_DESC" = :COLLMAST_DESC, "MORTGAGE_PRICE" = :MORTGAGE_PRICE, "REDEEM_FLAG" = :REDEEM_FLAG, "COOP_ID" = :COOP_ID, "LANDESTIMATE_AMT" = :LANDESTIMATE_AMT, "HOUSEESTIMATE_AMT" = :HOUSEESTIMATE_AMT, "ESTIMATE_PRICE" = :ESTIMATE_PRICE, "MORTGAGE_DATE" = :MORTGAGE_DATE, "EXPIRE_DATE" = :EXPIRE_DATE, "REDEEM_DATE" = :REDEEM_DATE, "REMARK" = :REMARK, "BLINDLAND_FLAG" = :BLINDLAND_FLAG, "MEMBER_NO" = :MEMBER_NO, "LANDSIDE_NO" = :LANDSIDE_NO, "COLLRELATION_CODE" = :COLLRELATION_CODE WHERE (("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("COOP_ID" = :Original_COOP_ID)) 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 ( LNCONTCOLL.COOP_ID = LNCONTMASTER.COOP_ID ) and ( LNCONTCOLL.LOANCONTRACT_NO = LNCONTMASTER.LOANCONTRACT_NO ) and ( LNCONTMASTER.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNCONTMASTER.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and ( LNCONTMASTER.COOP_ID = LNLOANTYPE.COOP_ID ) and ( LNCONTMASTER.LOANTYPE_CODE = LNLOANTYPE.LOANTYPE_CODE ) SELECT "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "LNCOLLMASTMEMCO"."COOP_ID", "LNCOLLMASTMEMCO"."COLLMAST_NO", "LNCOLLMASTMEMCO"."MEMCOOP_ID", "LNCOLLMASTMEMCO"."MEMCO_NO", "LNCOLLMASTMEMCO"."COLLMASTMAIN_FLAG" FROM "LNCOLLMASTMEMCO", "MBMEMBMASTER", "MBUCFPRENAME" WHERE ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "LNCOLLMASTMEMCO"."MEMCO_NO" = "MBMEMBMASTER"."MEMBER_NO" ) and ( "LNCOLLMASTMEMCO"."COOP_ID" = "MBMEMBMASTER"."COOP_ID" ) DELETE FROM "LNCOLLMASTPROP" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNCOLLMASTPROP" ("COOP_ID", "COLLMAST_NO", "SEQ_NO", "PROP_DESC") VALUES (:COOP_ID, :COLLMAST_NO, :SEQ_NO, :PROP_DESC) SELECT "LNCOLLMASTPROP"."COOP_ID", "LNCOLLMASTPROP"."COLLMAST_NO", "LNCOLLMASTPROP"."SEQ_NO", "LNCOLLMASTPROP"."PROP_DESC" FROM "LNCOLLMASTPROP" UPDATE "LNCOLLMASTPROP" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "SEQ_NO" = :SEQ_NO, "PROP_DESC" = :PROP_DESC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNCOLLMASTREVIEW" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("REVIEW_NO" = :Original_REVIEW_NO)) INSERT INTO "LNCOLLMASTREVIEW" ("COOP_ID", "COLLMAST_NO", "REVIEW_NO", "REVIEW_DATE", "ESTREVIEW_AMT", "REMARK") VALUES (:COOP_ID, :COLLMAST_NO, :REVIEW_NO, :REVIEW_DATE, :ESTREVIEW_AMT, :REMARK) SELECT "LNCOLLMASTREVIEW"."COOP_ID", "LNCOLLMASTREVIEW"."COLLMAST_NO", "LNCOLLMASTREVIEW"."REVIEW_NO", "LNCOLLMASTREVIEW"."REVIEW_DATE", "LNCOLLMASTREVIEW"."ESTREVIEW_AMT", "LNCOLLMASTREVIEW"."REMARK" FROM "LNCOLLMASTREVIEW" UPDATE "LNCOLLMASTREVIEW" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "REVIEW_NO" = :REVIEW_NO, "REVIEW_DATE" = :REVIEW_DATE, "ESTREVIEW_AMT" = :ESTREVIEW_AMT, "REMARK" = :REMARK WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("REVIEW_NO" = :Original_REVIEW_NO))