SELECT "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBMEMBMASTER"."MEMBER_DATE", "MBMEMBMASTER"."SALARY_AMOUNT", ' ' as payadjust_tdate, "MBMEMBMASTER"."RESIGN_STATUS", "MBMEMBMASTER"."MEMBER_STATUS", "SHPAYMENTADJUST"."PAYADJUST_DOCNO", "SHPAYMENTADJUST"."MEMBER_NO", "SHPAYMENTADJUST"."PAYADJUST_DATE", "SHPAYMENTADJUST"."SHAREBEGIN_VALUE", "SHPAYMENTADJUST"."SHARESTK_VALUE", "SHPAYMENTADJUST"."SHRLAST_PERIOD", "SHPAYMENTADJUST"."PERIODBASE_VALUE", "SHPAYMENTADJUST"."OLD_PERIODVALUE", "SHPAYMENTADJUST"."OLD_PAYSTATUS", "SHPAYMENTADJUST"."NEW_PERIODVALUE", "SHPAYMENTADJUST"."NEW_PAYSTATUS", "SHPAYMENTADJUST"."SHRPAYADJ_STATUS", "SHPAYMENTADJUST"."APVIMMEDIATE_FLAG", "SHPAYMENTADJUST"."REMARK", "SHPAYMENTADJUST"."CHGSTOP_FLAG", "SHPAYMENTADJUST"."CHGCONT_FLAG", "SHPAYMENTADJUST"."CHGADD_FLAG", "SHPAYMENTADJUST"."CHGLOW_FLAG", "SHPAYMENTADJUST"."ENTRY_ID", "SHPAYMENTADJUST"."ENTRY_DATE", "SHPAYMENTADJUST"."APPROVE_ID", "SHPAYMENTADJUST"."APPROVE_DATE" , "SHPAYMENTADJUST"."COOP_ID", "SHPAYMENTADJUST"."MEMCOOP_ID", MBMEMBMASTER.SALARY_ID FROM "SHPAYMENTADJUST", "MBMEMBMASTER", "MBUCFPRENAME", "MBUCFMEMBGROUP" WHERE ( "SHPAYMENTADJUST"."MEMBER_NO" = "MBMEMBMASTER"."MEMBER_NO" ) and ( "SHPAYMENTADJUST"."MEMCOOP_ID" = "MBMEMBMASTER"."COOP_ID" ) and ( "MBUCFPRENAME"."PRENAME_CODE" = "MBMEMBMASTER"."PRENAME_CODE" ) and ( "MBMEMBMASTER"."MEMBGROUP_CODE" = "MBUCFMEMBGROUP"."MEMBGROUP_CODE" ) and ( ( shpaymentadjust.payadjust_docno = :as_reqdocno ) ) and ( shpaymentadjust.coop_id = :as_coopid )