sp_depends 'GetCurrentDocPSCClient_Partner'

SELECT TOP 200 OBJECT_SCHEMA_NAME(object_id) AS sch1 
, OBJECT_NAME( object_id) AS obj1 , DEFINITION , *
FROM sys.sql_modules 
Where CHARINDEX ( 'GetCurrentDocPSCClient_Partner' , DEFINITION ) != 0

tp.Id_DocPSCClientTitle = dbo.GetCurrentDocPSCClient_Partner(tp.id_partner, @TTNDate, 2, @id_cm_client)

SELECT TOP 200 
object_name ( referencing_id) as obj1
, * 
FROM sys.sql_expression_dependencies
where referenced_entity_name = 'GetCurrentDocPSCClient_Partner'
ORDER BY 1