SELECT ' ' as slip_tdate, ' ' as operate_tdate, "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", 0 as crosscoop_flag, "SLSLIPPAYIN"."COOP_ID", "SLSLIPPAYIN"."PAYINSLIP_NO", "SLSLIPPAYIN"."MEMCOOP_ID", "SLSLIPPAYIN"."MEMBER_NO", "SLSLIPPAYIN"."DOCUMENT_NO", "SLSLIPPAYIN"."SLIPTYPE_CODE", "SLSLIPPAYIN"."SLIP_DATE", "SLSLIPPAYIN"."OPERATE_DATE", "SLSLIPPAYIN"."PAYINORDER_NO", "SLSLIPPAYIN"."SHARESTKBF_VALUE", "SLSLIPPAYIN"."SHARESTK_VALUE", "SLSLIPPAYIN"."INTACCUM_AMT", "SLSLIPPAYIN"."MONEYTYPE_CODE", "SLSLIPPAYIN"."EXPENSE_BANK", "SLSLIPPAYIN"."EXPENSE_BRANCH", "SLSLIPPAYIN"."EXPENSE_ACCID", "SLSLIPPAYIN"."ACCID_FLAG", "SLSLIPPAYIN"."TOFROM_ACCID", "SLSLIPPAYIN"."REF_OPEDOCNO", "SLSLIPPAYIN"."REF_NEWCONTNO", "SLSLIPPAYIN"."REF_SHARETYPE", "SLSLIPPAYIN"."REF_SYSTEM", "SLSLIPPAYIN"."REF_SLIPNO", "SLSLIPPAYIN"."REF_SLIPAMT", "SLSLIPPAYIN"."SLIP_AMT", "SLSLIPPAYIN"."SLIP_STATUS", "SLSLIPPAYIN"."MEMBGROUP_CODE", "SLSLIPPAYIN"."SUBGROUP_CODE", "SLSLIPPAYIN"."ENTRY_ID", "SLSLIPPAYIN"."ENTRY_DATE", "SLSLIPPAYIN"."CANCEL_ID", "SLSLIPPAYIN"."CANCEL_DATE", "SLSLIPPAYIN"."POSTTOVC_FLAG", "SLSLIPPAYIN"."VOUCHER_NO", "SLSLIPPAYIN"."CANCELTOVC_FLAG", "SLSLIPPAYIN"."CANCELVC_NO", "SLSLIPPAYIN"."PAYINTRETURN_STATUS", "SLSLIPPAYIN"."POST_TOFIN", "SLSLIPPAYIN"."FORWORD_FLAG" FROM "SLSLIPPAYIN", "MBMEMBMASTER", "MBUCFMEMBGROUP", "MBUCFPRENAME" WHERE ( "SLSLIPPAYIN"."MEMBER_NO" = "MBMEMBMASTER"."MEMBER_NO" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "SLSLIPPAYIN"."MEMBGROUP_CODE" = "MBUCFMEMBGROUP"."MEMBGROUP_CODE" ) and ( ( slslippayin.payinslip_no = :as_slipno ) )