sql server – Updtae table row with another row value

I have a table with the below data for example,

USER_NO USER_NAME DESCRIPTION SALE_NO REASON_CANCELLED ROW_NUMBER RE_RUN
ABC123 MR Sunil 40.00 x 12.00 CS1 1
ABC123 MR Sunil 50.00 x 15.00 CS2 Transferred 2
ABC124 MR Sunil 30.00 x 10.00 CS3 1

I have a below table and I got the Row_Number over partitioning by USER_NO.

In the Re-RUN column of SALE_ID CS2 , I want to have the value as CS1 – because they both have the same USER_NO and the Reason_cancelled is present for SALE_NO CS2.

The cross apply i snot working for update. Can you please let me know how to do it ?

Thanks