Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
951 B
2
Indexable
Never
	/*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;