ALTER FUNCTION [dbo].[FN_CHECK_LIMIT_TR_REQ]
(	
	-- Add the parameters for the function here
	@REQ_ID VARCHAR(20),
	@p_role VARCHAR(20)
)
RETURNS  BIT
AS
BEGIN
DECLARE @DMMS_ID VARCHAR(20)

SET @DMMS_ID =(SELECT DMMS_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID)


IF( EXISTS(SELECT DMMS_ID FROM dbo.CM_DMMS WHERE DMMS_ID=@DMMS_ID AND EXISTS (SELECT CM_BRANCH.BRANCH_ID FROM dbo.CM_BRANCH WHERE CM_BRANCH.BRANCH_TYPE='HS' AND CM_DMMS.BRANCH_ID=CM_BRANCH.BRANCH_ID)))
BEGIN
	RETURN 1
END



RETURN 0
END





GO