Hello ,
In you SP , you have set default value of @p_SiteId =0 means , if you will not pass the parameter value then it will be set to 0 by default . Moreover when you execute the SP then no need to pass that variable .
For reference check this :
Specifying a Parameter Default Value
thanks