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

IF( (SELECT SUM(TOTAL_AMT) FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID=@REQ_ID AND  TRAN_TYPE_ID NOT IN (SELECT TRN_TYPE FROM dbo.CM_TRAN_TYPE WHERE NOTES='XK' ))  <=5000000)
BEGIN
	RETURN 0
END


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