Below is my store proc, all the information above has to be part of my where clause according to the requirements.

ALTER PROCEDURE [dbo].[prc_TopUpCancellation_xml]

@ApplicationID VARCHAR(10)

AS

SELECT

Application_Id

,Policy_Id

,Date_of_Disinvestment

,Original_Investment_Value

,Payout_Value

NB. now there from and where clause I have to extract it from that given Info