alter PROCEDURE [dbo].[TR_CHECK_DEP]
@p_BRANCH_ID	VARCHAR(20)  = NULL,
@p_BRANCH_CODE	VARCHAR(20) = NULL,
@p_DEP_ID	VARCHAR(20)  = NULL,
@p_DEP_CODE	VARCHAR(20)  = NULL,
@p_TYPE	nvarchar(200)  = NULL
AS
	DECLARE @l_DEP_ID VARCHAR(20) = NULL;

	IF(@p_TYPE = 'TR_PAYMENT_KT')
	BEGIN
		IF(@p_BRANCH_CODE = '699' OR @p_BRANCH_CODE = '799' OR @p_BRANCH_CODE = '899' OR @p_BRANCH_CODE = '615' OR @p_BRANCH_CODE = '617')
		BEGIN
			SELECT '0' AS Result, '' ErrorDesc
			RETURN '0'
		END
		ELSE
		BEGIN
			SET @l_DEP_ID =	(	SELECT TOP 1 D.DEP_ID
									FROM CM_DEPARTMENT D
									WHERE  D.DEP_CODE= @P_DEP_CODE AND D.BRANCH_ID = @p_BRANCH_ID
								)
			--print @l_DEP_ID;
			IF(ISNULL(@l_DEP_ID, '') <> '')
			BEGIN
				SELECT '0' AS Result, '' ErrorDesc
				RETURN '0'
			END
			ELSE
			BEGIN
				SELECT '-1' AS Result, N'Mã phòng ban không hợp lệ' ErrorDesc
				RETURN '-1'
			END
		END
	END
	ELSE IF(@p_TYPE = 'MW_OUT_HC')
	BEGIN
		IF(@p_BRANCH_CODE = '699' OR @p_BRANCH_CODE = '799' OR @p_BRANCH_CODE = '899' OR @p_BRANCH_CODE = '615' OR @p_BRANCH_CODE = '617')
		BEGIN
			SELECT '0' AS Result, '' ErrorDesc
			RETURN '0'
		END
		ELSE
		BEGIN
			SET @l_DEP_ID =	(	SELECT TOP 1 D.DEP_ID
									FROM CM_DEPARTMENT D
									WHERE  D.DEP_CODE= @P_DEP_CODE AND D.BRANCH_ID = @p_BRANCH_ID
								)
			--print @l_DEP_ID;
			IF(ISNULL(@l_DEP_ID, '') <> '')
			BEGIN
				SELECT '0' AS Result, '' ErrorDesc
				RETURN '0'
			END
			ELSE
			BEGIN
				SELECT '-1' AS Result, N'Mã phòng ban không hợp lệ' ErrorDesc
				RETURN '-1'
			END
		END
	END
	ELSE
	BEGIN
		SELECT '-1' AS Result, N'Lỗi không xác định' ErrorDesc
		RETURN '-1'
	END

	--exec TR_CHECK_DEP @p_BRANCH_ID = 'DV0001', @p_BRANCH_CODE = '', @p_DEP_ID = '', @p_DEP_CODE = '7990000', @p_TYPE = 'TR_PAYMENT_KT'