Mine

DECLARE @p_sCSVhMys VARCHAR(1000) 
SET @p_sCSVhMys = '' 
 
SELECT @p_sCSVhMys = @p_sCSVhMys + Convert(VARCHAR(255),P2.hMy) + ',' 
/* 
  ,P.sCode, P.sAddr1, P2.sCode, P2.sAddr1, LP.dPercent, 
   CASE P2.iType WHEN 3 Then 'Property' ELSE 'Property List' END 
*/ 
  FROM PROPERTY P JOIN LISTPROP LP ON P.hMy = LP.hPropList 
   JOIN PROPERTY P2 ON LP.hProperty = P2.hMy 
  WHERE 1 = 1 
          And P.sCode = 'alltara' 
 
exec ul_apply_credits @p_sCSVhMys