DELETE FROM "LNNPLSUE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) INSERT INTO "LNNPLSUE" ("COOP_ID", "SUE_NO", "COURT_NAME", "MEMCOOP_ID", "MEMBER_NO", "SUE_DATE", "JUDGE_DATE", "LAWSET_STATUS", "LAWTYPE_CODE", "CASEBLACK_NO", "CASERED_NO", "WORKSTEP_CODE", "DEBTCLASS_CODE", "PAYTYPE_STATUS", "REMARK", "JUDGE_EVENT", "NOTICECONTROL_DATE") VALUES (:COOP_ID, :SUE_NO, :COURT_NAME, :MEMCOOP_ID, :MEMBER_NO, :SUE_DATE, :JUDGE_DATE, :LAWSET_STATUS, :LAWTYPE_CODE, :CASEBLACK_NO, :CASERED_NO, :WORKSTEP_CODE, :DEBTCLASS_CODE, :PAYTYPE_STATUS, :REMARK, :JUDGE_EVENT, :NOTICECONTROL_DATE) select * from LNNPLSUE UPDATE "LNNPLSUE" SET "COOP_ID" = :COOP_ID, "SUE_NO" = :SUE_NO, "COURT_NAME" = :COURT_NAME, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "SUE_DATE" = :SUE_DATE, "JUDGE_DATE" = :JUDGE_DATE, "LAWSET_STATUS" = :LAWSET_STATUS, "LAWTYPE_CODE" = :LAWTYPE_CODE, "CASEBLACK_NO" = :CASEBLACK_NO, "CASERED_NO" = :CASERED_NO, "WORKSTEP_CODE" = :WORKSTEP_CODE, "DEBTCLASS_CODE" = :DEBTCLASS_CODE, "PAYTYPE_STATUS" = :PAYTYPE_STATUS, "REMARK" = :REMARK, "JUDGE_EVENT" = :JUDGE_EVENT, "NOTICECONTROL_DATE" = :NOTICECONTROL_DATE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SUE_NO" = :Original_SUE_NO)) SELECT LNNPLSUE.COOP_ID , LNNPLSUE.SUE_NO , lnnplsue.tracking_no , LNNPLSUE.COURT_NAME , LNNPLSUE.MEMBER_NO, MBUCFPRENAME.PRENAME_DESC , MBMEMBMASTER.MEMB_NAME , MBMEMBMASTER.MEMB_SURNAME FROM LNNPLSUE , MBMEMBMASTER , MBUCFPRENAME WHERE ( LNNPLSUE.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNNPLSUE.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE )