This is one of the procs, which having issues:
/****** Object: UserDefinedTableType [dbo].[Identifier_type]******/
CREATE TYPE [dbo].[Identifier_type] AS TABLE(
[id] [BIGINT] NOT NULL
)
GO
CREATE PROCEDURE [dbo].[WorkerABC_prc]
(@workerIds Identifier_type READONLY)
AS
BEGIN
SELECT swm.SyncWorkerId
FROM SyncWorkerMap swm
INNER JOIN @workerIds w
ON swm.SyncWorkerId = w.id
WHERE swm.IsAuditWorker = 0;
END;
GO