FN_CHECK_LIMIT_TR_REQ.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 |
|
| 12 |
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) |
| 13 |
BEGIN |
| 14 |
RETURN 0 |
| 15 |
END |
| 16 |
|
| 17 |
|
| 18 |
DECLARE @DMMS_ID VARCHAR(20) |
| 19 |
|
| 20 |
|
| 21 |
SET @DMMS_ID =(SELECT DMMS_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID) |
| 22 |
|
| 23 |
|
| 24 |
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))) |
| 25 |
BEGIN |
| 26 |
RETURN 1 |
| 27 |
END |
| 28 |
|
| 29 |
|
| 30 |
|
| 31 |
RETURN 0 |
| 32 |
END |
| 33 |
|
| 34 |
|
| 35 |
|
| 36 |
|
| 37 |
|
| 38 |
|
| 39 |
|