/*INSERT INTO EMONEY.EMONEYREQUESTS (BRANDTYPEID, AMOUNT, EXTERNALREQUESTID, ISCONFIRMED, IDENTIFIED, CUSTOMERID, ACCOUNTID, PAYMENTINSTRUMENTGROUPID, PAYMENTINSTRUMENTID, STATUS, "COMMENT", TRANSACTIONID, ACCOUNTTRANSID, INSERTUSER, UPDATEUSER, INSERTDATE, UPDATEDATE, EMAIL) VALUES
((SELECT BRANDTYPEID FROM ACCOUNT.BRANDTYPES b WHERE BRANDTYPECODE = ip_BrandTypeCode) , ip_AmountTrans, up_ExternalRequestID, 0, ip_ClientIdentification, up_CUSTOMERID, NULL, NULL, NULL, 0, '', 0, 0, ip_LoginUserID, ip_LoginUserID, CURRENT TIMESTAMP, CURRENT TIMESTAMP, ip_Email);
*/
UPDATE EMONEY.EMONEYREQUESTS
SET BRANDTYPEID = (SELECT BRANDTYPEID FROM ACCOUNT.BRANDTYPES b WHERE BRANDTYPECODE = ip_BrandTypeCode), AMOUNT = ip_AmountTrans, CUSTOMERID = up_CUSTOMERID, INSERTUSER = ip_LoginUserID, UPDATEUSER = ip_LoginUserID, INSERTDATE = CURRENT TIMESTAMP, UPDATEDATE = CURRENT TIMESTAMP, EMAIL = ip_Email
WHERE EMONEYREQUESTID = ip_EmoneyRequestID;