DELETE FROM "MBMEMBMTHEXPENSE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SIGN_FLAG" = :Original_SIGN_FLAG) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "MBMEMBMTHEXPENSE" ("COOP_ID", "MEMBER_NO", "SIGN_FLAG", "SEQ_NO", "MTHEXPENSE_DESC", "MTHEXPENSE_AMT") VALUES (:COOP_ID, :MEMBER_NO, :SIGN_FLAG, :SEQ_NO, :MTHEXPENSE_DESC, :MTHEXPENSE_AMT) SELECT COOP_ID, MEMBER_NO, SIGN_FLAG, SEQ_NO, MTHEXPENSE_DESC, MTHEXPENSE_AMT FROM MBMEMBMTHEXPENSE UPDATE "MBMEMBMTHEXPENSE" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "SIGN_FLAG" = :SIGN_FLAG, "SEQ_NO" = :SEQ_NO, "MTHEXPENSE_DESC" = :MTHEXPENSE_DESC, "MTHEXPENSE_AMT" = :MTHEXPENSE_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("SIGN_FLAG" = :Original_SIGN_FLAG) AND ("SEQ_NO" = :Original_SEQ_NO)) SELECT "MBMEMBMASTER"."MEMBER_NO" , "MBUCFPRENAME"."PRENAME_DESC" , "MBMEMBMASTER"."MEMB_NAME" , "MBMEMBMASTER"."MEMB_SURNAME" , "MBMEMBMASTER"."MEMBGROUP_CODE" , "MBUCFMEMBGROUP"."MEMBGROUP_DESC" , "MBMEMBMASTER"."MEMBTYPE_CODE" , "MBUCFMEMBTYPE"."MEMBTYPE_DESC" , "MBMEMBMASTER"."MEMBER_STATUS" , "MBMEMBMASTER"."SEX" , "MBMEMBMASTER"."MEMBER_TYPE" FROM "MBMEMBMASTER" , "MBUCFMEMBGROUP" , "MBUCFMEMBTYPE" , "MBUCFPRENAME" WHERE ( "MBUCFMEMBGROUP"."MEMBGROUP_CODE" = "MBMEMBMASTER"."MEMBGROUP_CODE" ) and ( "MBUCFMEMBTYPE"."MEMBTYPE_CODE" = "MBMEMBMASTER"."MEMBTYPE_CODE" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" )