FILE 2.txt
| 1 |
|
|---|---|
| 2 |
ALTER FUNCTION [dbo].[FN_CHECK_LIMIT_TR_REQ] |
| 3 |
( |
| 4 |
-- Add the parameters for the function here |
| 5 |
@REQ_ID VARCHAR(20), |
| 6 |
@p_role VARCHAR(20) |
| 7 |
) |
| 8 |
RETURNS BIT |
| 9 |
AS |
| 10 |
BEGIN |
| 11 |
DECLARE @DMMS_ID VARCHAR(20) |
| 12 |
|
| 13 |
SET @DMMS_ID =(SELECT DMMS_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID) |
| 14 |
|
| 15 |
|
| 16 |
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))) |
| 17 |
BEGIN |
| 18 |
RETURN 1 |
| 19 |
END |
| 20 |
|
| 21 |
|
| 22 |
|
| 23 |
RETURN 0 |
| 24 |
END |
| 25 |
|
| 26 |
|
| 27 |
|
| 28 |
|
| 29 |
|
| 30 |
GO |
| 31 |
|