SELECT "MBMEMBMASTER"."COOP_ID", "MBMEMBMASTER"."MEMBER_NO", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBMEMBMASTER"."RESIGN_DATE", "MBUCFRESIGNCAUSE"."RESIGNCAUSE_DESC", "MBMEMBMASTER"."RESIGNCAUSE_CODE", "MBMEMBMASTER"."CLOSE_DATE", "MBMEMBMASTER"."MEMBER_STATUS" FROM "MBMEMBMASTER", "MBUCFPRENAME", "MBUCFMEMBGROUP", "MBUCFRESIGNCAUSE" WHERE ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and ( "MBMEMBMASTER"."RESIGNCAUSE_CODE" = "MBUCFRESIGNCAUSE"."RESIGNCAUSE_CODE" ) and ( ( MBMEMBMASTER.RESIGN_STATUS = 1 ) AND ( MBMEMBMASTER.MEMBER_STATUS = 1 ) AND ( "MBMEMBMASTER"."COOP_ID" = :as_coopid ) ) GROUP BY "MBMEMBMASTER"."COOP_ID", "MBMEMBMASTER"."MEMBER_NO", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBMEMBMASTER"."RESIGN_DATE", "MBMEMBMASTER"."RESIGNCAUSE_CODE", "MBUCFPRENAME"."PRENAME_DESC", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBUCFRESIGNCAUSE"."RESIGNCAUSE_DESC", "MBMEMBMASTER"."CLOSE_DATE", "MBMEMBMASTER"."MEMBER_STATUS" SELECT "LNCONTCOLL"."LOANCONTRACT_NO", "LNCONTMASTER"."MEMBER_NO", "LNCONTCOLL"."REF_COLLNO", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "LNCONTMASTER"."PRINCIPAL_BALANCE", "LNCONTCOLL"."COLL_PERCENT", lncontcoll.collactive_percent, "LNCONTMASTER"."WITHDRAWABLE_AMT", "LNCONTMASTER"."LOANAPPROVE_AMT", "LNCONTMASTER"."STARTCONT_DATE", "SHSHAREMASTER"."SHARESTK_AMT", "SHSHAREMASTER"."SHAREARREAR_AMT", "SHSHARETYPE"."UNITSHARE_VALUE" FROM "LNCONTCOLL", "LNCONTMASTER", "MBMEMBMASTER", "MBUCFPRENAME", "SHSHAREMASTER", "SHSHARETYPE" WHERE ( "LNCONTMASTER"."LOANCONTRACT_NO" = "LNCONTCOLL"."LOANCONTRACT_NO" ) and ( "MBMEMBMASTER"."MEMBER_NO" = "LNCONTMASTER"."MEMBER_NO" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "MBMEMBMASTER"."MEMBER_NO" = "SHSHAREMASTER"."MEMBER_NO" ) and ( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) and ( "LNCONTCOLL"."COOP_ID" = "LNCONTMASTER"."COOP_ID" ) and ( "LNCONTMASTER"."MEMCOOP_ID" = "MBMEMBMASTER"."COOP_ID" ) and ( "SHSHAREMASTER"."COOP_ID" = "SHSHARETYPE"."COOP_ID" ) and ( ( lncontcoll.loancolltype_code in ( '01', '05' ) ) AND ( lncontcoll.ref_collno = :as_refno ) AND ( lncontmaster.contract_status > 0 ) AND ( lncontcoll.coll_status = 1 ) ) AND "LNCONTCOLL"."COOP_ID" = :as_coopid SELECT "LNCONTMASTER"."LOANCONTRACT_NO", "LNLOANTYPE"."PREFIX", "LNCONTMASTER"."LOANAPPROVE_AMT", "LNCONTMASTER"."PERIOD_PAYMENT", "LNCONTMASTER"."STARTCONT_DATE", "LNCONTMASTER"."PRINCIPAL_BALANCE", "LNCONTMASTER"."LAST_PERIODPAY", "LNCONTMASTER"."INTEREST_ACCUM", "LNCONTMASTER"."PAYMENT_STATUS", "LNCONTMASTER"."CONTRACT_STATUS", "LNCONTMASTER"."LOANTYPE_CODE", "LNCONTMASTER"."WITHDRAWABLE_AMT", "LNCONTMASTER"."LASTRECEIVE_DATE", "LNCONTMASTER"."LASTPAYMENT_DATE", "LNCONTMASTER"."PERIOD_PAYAMT", "LNCONTMASTER"."PERIOD_PAYMENT_MAX", "LNCONTMASTER"."INTEREST_ARREAR", "LNCONTMASTER"."LOANPAYMENTCHG_DATE", "LNCONTMASTER"."INTEREST_RETURN", "LNCONTMASTER"."STATUS_DESC", "LNCONTMASTER"."CONTLAW_STATUS", "LNCONTMASTER"."TRANSFER_STATUS" FROM "LNCONTMASTER", "LNLOANTYPE" WHERE ( "LNLOANTYPE"."LOANTYPE_CODE" = "LNCONTMASTER"."LOANTYPE_CODE" ) and ( "LNCONTMASTER"."MEMCOOP_ID" = "LNLOANTYPE"."COOP_ID" ) and ( ( "LNCONTMASTER"."MEMBER_NO" = :as_memno ) AND ( "LNCONTMASTER"."MEMCOOP_ID" = :as_coopid ) ) SELECT "SHSHAREMASTER"."SHARETYPE_CODE", "SHSHARETYPE"."SHARETYPE_DESC", "SHSHARETYPE"."UNITSHARE_VALUE", "SHSHAREMASTER"."SHAREBEGIN_AMT", "SHSHAREMASTER"."SHARESTK_AMT", "SHSHAREMASTER"."LAST_PERIOD", "SHSHAREMASTER"."PERIODSHARE_AMT", "SHSHAREMASTER"."SHAREMASTER_STATUS", "SHSHAREMASTER"."PAYMENT_STATUS", "SHSHAREMASTER"."MEMBER_NO", "SHSHAREMASTER"."SHAREARREAR_AMT", "SHSHAREMASTER"."PERIODBASE_AMT", "SHSHAREMASTER"."PAYMENTSTOP_DATE" FROM "SHSHAREMASTER", "SHSHARETYPE" WHERE ( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" ) and ( "SHSHAREMASTER"."COOP_ID" = "SHSHARETYPE"."COOP_ID" ) and ( ( shsharemaster.member_no = :as_membno ) ) AND ( "SHSHAREMASTER"."COOP_ID" = :as_coopid )