CREATE procedure [dbo].[CM_BRANCH_USER_Combobox] 
@USER_LOGIN VARCHAR(15)
AS
BEGIN
	DECLARE @BRANCH_LOGIN varchar(15) =''
	declare @tmp table(BRANCH_ID varchar(15))
	declare @deptmp table(DEP_ID varchar(15))
	SELECT @BRANCH_LOGIN = TLSUBBRID FROM TL_USER WHERE TLNANME = @USER_LOGIN

	insert into @tmp SELECT BRANCH_ID  FROM [dbo].[CM_BRANCH_GETCHILDID_Funct](@BRANCH_LOGIN)
	IF(EXISTS(SELECT * FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_LOGIN AND BRANCH_TYPE = 'HS'))
	BEGIN
		insert into @deptmp SELECT DEP_ID FROM CM_DEPARTMENT WHERE BRANCH_ID = @BRANCH_LOGIN
	END
	SELECT BRANCH_ID, BRANCH_CODE,BRANCH_NAME FROM CM_BRANCH where BRANCH_ID IN (SELECT BRANCH_ID FROM @tmp)
	UNION ALL
	SELECT A.DEP_ID AS BRANCH_ID, A.DEP_CODE AS BRANCH_CODE, B.BRANCH_NAME + ' - ' + A.DEP_NAME AS BRANCH_NAME FROM CM_DEPARTMENT A
	LEFT JOIN CM_BRANCH B ON A.BRANCH_ID = B.BRANCH_ID
	where DEP_ID IN (SELECT DEP_ID FROM @deptmp)
END