ALTER PROCEDURE [dbo].[TR_ROLE_NOTIFI_ID]
@PO_ID	varchar(500),
@TYPE VARCHAR(100)
AS
	PRINT @TYPE

	DECLARE 
		@BRANCH_CREATE VARCHAR(15),
		@DEP_CREATE VARCHAR(15),
		@BRANCH_TYPE VARCHAR(15),
		@FATHER_ID VARCHAR(15),
		--@FLAG VARCHAR(1), -- FLAG = 1: THANH TOÁN / TẠM ỨNG
		---------BAODNQ 26/10/2022 : TĂNG KÍCH THƯỚC BIẾN @FLAG
		@FLAG VARCHAR(5), -- FLAG = 1: THANH TOÁN / TẠM ỨNG
		@AUTH_STATUS VARCHAR(10),
		@PROCESS VARCHAR(10),
		@MAKER_ID VARCHAR(15),
		@DEP_CODE VARCHAR(15),
		@NV_XL_MS VARCHAR(15)
	DECLARE @ROLE_CURRENT VARCHAR(15), @USER_RECIVE_MAIL VARCHAR(15), @REQ_TYPE VARCHAR(15)
	DECLARE @SYS_PREFIX VARCHAR(15),@PAGE NVARCHAR(200)
	DECLARE @l_LST_REQ_ID TABLE (
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[REQ_PAY_ID] [VARCHAR](50) NULL)
	INSERT INTO @l_LST_REQ_ID SELECT VALUE FROM WSISPLIT(@PO_ID,',')
	DECLARE @LST_POID TABLE(ID VARCHAR(15))
	DECLARE @LST_USER_RECIVE TABLE (TLNAME VARCHAR(10))
	--- DECLARE TABLE NHAN DU LIEU LA USER NAME DANG O BUOC PHE DUYET HIEN TAI
	DECLARE @PL_PROCESS_CURRENT_SEARCH_TEMP TABLE
	(
	REQ_ID varchar(15),
	PROCESS_ID varchar(10),
	DVDM_NAME nvarchar(500),
	TLNAME nvarchar(255),
	TLFullName nvarchar(255),
	NOTES nvarchar(500)
	)
	-----BAODNQ 5/1/2021 : Thêm gửi mail cho GDDV, TP, PP----------
	DECLARE @p_MAKER_ID VARCHAR(15), @p_ROLE_ID VARCHAR(15), @p_ROLE_NAME VARCHAR(15) 
	DECLARE @LST_ROLE TABLE(ROLE_ID VARCHAR(15), ROLE_NAME VARCHAR(15))
	---------BAODNQ 2/11/2022 : Lấy mã code phòng ban tạo-------------
	DECLARE @p_DEP_CREATE_CODE VARCHAR(15)
	--------------------------
	IF @TYPE = 'PO'
	BEGIN
		INSERT INTO @LST_POID VALUES(@PO_ID)
		SET @FLAG = 0
	END ELSE
	IF @TYPE = 'USE'
	BEGIN
		INSERT INTO @LST_POID SELECT B.PO_ID 
		FROM ASS_MASTER_PO B WHERE B.ASSET_ID = (SELECT A.ASSET_ID FROM ASS_USE A WHERE A.USE_ID = @PO_ID)
		SET @FLAG = 0
	END ELSE
	IF @TYPE = 'USE_MUILT'
	BEGIN
		INSERT INTO @LST_POID SELECT B.PO_ID 
		FROM ASS_MASTER_PO B WHERE B.ASSET_ID IN (SELECT A.ASSET_ID FROM ASS_USE_MULTI_DT A WHERE A.USER_MASTER_ID = @PO_ID)
		GROUP BY B.PO_ID
		SET @FLAG = 0
	END ELSE
	IF @TYPE = 'USE_ADDNEW'
	BEGIN
		INSERT INTO @LST_POID SELECT B.PO_ID 
		FROM ASS_ADDNEW_PO B WHERE B.ADDNEW_ID = @PO_ID
		SET @FLAG = 0
	END 	
	-- Tạm ứng 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_SEND_APR')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		IF(EXISTS(SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND (TRASFER_USER_RECIVE IS NOT NULL AND TRASFER_USER_RECIVE <>'')))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				(SELECT TRASFER_USER_RECIVE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
			END
			ELSE
			BEGIN
				SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				IF(@BRANCH_TYPE = 'PGD' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @FATHER_ID
					AND (	RoleName IN ('TPGD','PP') 
									OR RoleName IN (	SELECT ROLE_OLD 
														FROM TL_SYS_ROLE_MAPPING 
														WHERE ROLE_NEW IN ('TPGD','PP')
														AND RECORD_STATUS = 1
														AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
														AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')
													)
						)
				
				END
				ELSE IF(@BRANCH_TYPE = 'CN' )
				BEGIN
				
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE 
					AND (RoleName IN ('GDDV','PGD') OR RoleName IN (	SELECT ROLE_OLD 
																		FROM TL_SYS_ROLE_MAPPING 
																		WHERE ROLE_NEW IN ('GDDV','PGD')
																		AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')
																	)
						)
					
				END
				ELSE IF(@BRANCH_TYPE = 'HS' )
				BEGIN
						INSERT INTO @LST_USER_RECIVE (TLNAME) 
						SELECT TLNANME FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND SECUR_CODE = @DEP_CREATE
						AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD
																		FROM TL_SYS_ROLE_MAPPING 
																		WHERE ROLE_NEW IN ('GDDV','PP') 
																		AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')
																		)
							)
				END
			END
	SET @FLAG = 1
	END 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_CONFIRM')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @REQ_TYPE =(SELECT TOP 1 REQ_TYPE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID=@PO_ID)
		SET @DEP_CODE =(SELECT TOP 1 DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID =@DEP_CREATE)
		IF(@BRANCH_TYPE = 'PGD' )
		BEGIN
			IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000015')) -- KHOI HO TRO
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='tunt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000016')) -- KHOI QUAN LY RUI RO
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='linhvtk')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000017')) -- KHOI TAI CHINH
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='nhalc')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000018')) -- KHOI CNTT
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='haipv')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000020')) -- KHOI CNTT
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='tuvm')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000022')) -- KHOI KHCN - KHACH HANG CA NHAN
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='sangnm1')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000022')) -- KHOI KHCN - KHACH HANG CA NHAN
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='nhannt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			-- PTGD
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000019')) -- KHOI VAN HANH
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='muoilvb')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000014')) -- KHOI TRUC THUOC TGD
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='tupa')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @FATHER_ID
				AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD 
																FROM TL_SYS_ROLE_MAPPING 
																WHERE ROLE_NEW IN ('TPGD','PP') AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
			END
			
		END
		ELSE IF(@BRANCH_TYPE = 'CN' )
		BEGIN
			IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000015')) -- KHOI HO TRO
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='tunt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000016')) -- KHOI QUAN LY RUI RO
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='linhvtk')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000017')) -- KHOI TAI CHINH
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='nhalc')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000018')) -- KHOI CNTT
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='haipv')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000020')) -- KHOI CNTT
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='tuvm')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000022')) -- KHOI KHCN - KHACH HANG CA NHAN
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='sangnm1')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000022')) -- KHOI KHCN - KHACH HANG CA NHAN
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE TLNANME ='nhannt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			-- PTGD
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000019')) -- KHOI VAN HANH
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='muoilvb')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000014')) -- KHOI TRUC THUOC TGD
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='tupa')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE 
				AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD 
																FROM TL_SYS_ROLE_MAPPING 
																WHERE ROLE_NEW IN ('GDDV','PGD') AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
			END
		END
		ELSE IF(@BRANCH_TYPE = 'HS' )
		BEGIN
			IF(EXISTS(SELECT PROCESS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND (PROCESS ='' OR PROCESS IS NULL)))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD 
																FROM TL_SYS_ROLE_MAPPING 
																WHERE ROLE_NEW IN ('GDDV','PP') AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
			END
			ELSE
			BEGIN
				
				IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I'))
				BEGIN
					IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='tunt')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06907%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='linhvtk')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06908%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='nhalc')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06909%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='haipv')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06921%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='sangnm1')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
				END
				-- NEU CAP TIEP THEO LA PTGD
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I'))
				BEGIN
					/*
					IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='hantt')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					*/
					IF(@DEP_CODE ='0690405')
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='tupa')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					---- LUCTV 24.11.2022 BO SUNG GUI MAIL PTGD KHOI VAN HANH
					IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000019') 
					OR EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='muoilvb')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
				END
				-- NEU CAP TIEP THEO LA TKTGD
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TKTGD' AND @REQ_TYPE ='I'))
				BEGIN
					INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
				END
				-- NEU CAP TIEP THEO LA TKHDQT
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TKHDQT' AND @REQ_TYPE ='I'))
				BEGIN
					INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TKHDQT'
				END
				-- NEU CAP TIEP THEO LA TGD
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TGD' AND @REQ_TYPE ='I'))
				BEGIN
					INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TGD'
				END
				-- NEU CAP TIEP THEO LA HDQT
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='HDQT' AND @REQ_TYPE ='I'))
				BEGIN
					INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='HDQT'
				END
			END
		END
		SET @FLAG = 1
	END 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_APR')
	BEGIN
		SET @REQ_TYPE =(SELECT TOP 1 REQ_TYPE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID=@PO_ID)
		--SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		SET @BRANCH_CREATE = (SELECT TOP 1 BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		SET @DEP_CREATE = (SELECT TOP 1 DEP_ID FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		SET @DEP_CODE =(SELECT TOP 1 DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID =@DEP_CREATE)
		 /*
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TKTGD' AND @REQ_TYPE ='I'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TKHDQT' AND @REQ_TYPE ='I'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TKHDQT'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TGD' AND @REQ_TYPE ='I'))
		BEGIN
			--SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='TGD')
			--INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TGD'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='HDQT' AND @REQ_TYPE ='I'))
		BEGIN
			--SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='TGD')
			--INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='HDQT'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I'))
		BEGIN
			IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
				BEGIN
					SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='tunt')
					INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
				END
				ELSE IF((@DEP_CODE LIKE'%06907%'))
				BEGIN
					SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='linhvtk')
					INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
				END
				ELSE IF((@DEP_CODE LIKE'%06908%'))
				BEGIN
					SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='nhalc')
					INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
				END
				ELSE IF((@DEP_CODE LIKE'%06909%'))
				BEGIN
					SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='haipv')
					INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
				END
				ELSE IF((@DEP_CODE LIKE'%06921%'))
				BEGIN
					SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='sangnm1')
					INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
				END
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I'))
		BEGIN
			/*
			IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='hantt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			*/
			IF( @DEP_CODE ='0690405')
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='tupa')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			---- LUCTV 24.11.2022 BO SUNG GUI MAIL PTGD KHOI VAN HANH
			ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I' AND DVDM_ID ='DM0000000000019') 
			OR EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I') )
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='muoilvb')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
		END
		*/
		
		IF(EXISTS(SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND AUTH_STATUS ='A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TOP 1 MAKER_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID 

			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TLNANME FROM TL_USER 
			WHERE 1=1
			AND (RoleName = 'KSV' AND TLSUBBRID = 'DV0001' AND SECUR_CODE ='DEP000000000022')
			--OR TLNANME IN (SELECT TLNAME FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW ='KSV' AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL) AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL) AND RECORD_STATUS = 1)
		END
		SET @FLAG = 1
	END
	-- Điều phối tạm ứng/ thanh toán PL_REQUEST_PROCESS_CHILD
	ELSE IF (@TYPE = 'TR_REQ_PAYMENT_TRANSFER')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID IN (SELECT REQ_PAY_ID FROM @l_LST_REQ_ID) AND TYPE_JOB = 'XL' AND STATUS_JOB ='C'
		SET @FLAG = 1
	END
	-- 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_SEND_APR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
		SET @FLAG = 1
	END
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_SEND_SUG')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
		SET @FLAG = 1
	END
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_APPR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		SET @FLAG = 1
	END
	-- Thanh toán
	ELSE IF (@TYPE = 'TR_REQ_PAYMENT_SEND_APR')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
			IF(EXISTS(SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND (TRASFER_USER_RECIVE IS NOT NULL AND TRASFER_USER_RECIVE <>'')))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				(SELECT TRASFER_USER_RECIVE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
			END
			ELSE
			BEGIN
				SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				IF(@BRANCH_TYPE = 'PGD' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD 
																	FROM TL_SYS_ROLE_MAPPING 
																	WHERE ROLE_NEW IN ('TPGD','PP') AND RECORD_STATUS = 1  AND BRANCH_ID =@BRANCH_CREATE
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
				END
				ELSE IF(@BRANCH_TYPE = 'CN' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE 
					AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD 
																	FROM TL_SYS_ROLE_MAPPING 
																	WHERE ROLE_NEW IN ('GDDV','PGD') AND RECORD_STATUS = 1 AND BRANCH_ID =@BRANCH_CREATE
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
				END
				ELSE IF(@BRANCH_TYPE = 'HS' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND SECUR_CODE = @DEP_CREATE
					AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD 
																	FROM TL_SYS_ROLE_MAPPING 
																	WHERE ROLE_NEW IN ('GDDV','PP') AND RECORD_STATUS = 1 AND BRANCH_ID =@BRANCH_CREATE AND DEP_ID =@DEP_CREATE
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
				END
			END
			SET @FLAG = 1
	END 
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_APR')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		IF(@AUTH_STATUS  = 'A')
		BEGIN
			SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)

			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TOP 1 MAKER_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID 

			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TLNANME FROM TL_USER 
			WHERE 1=1 
			AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD 
												FROM TL_SYS_ROLE_MAPPING 
												WHERE ROLE_NEW = 'KSV' AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
			AND TLSUBBRID = 'DV0001' AND SECUR_CODE ='DEP000000000022'

			SET @FLAG = 1
		END
	END
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_CONFIRM')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		SET @PROCESS = ( SELECT TOP 1 PROCESS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		IF(@AUTH_STATUS  = 'U' AND @PROCESS = '0')
		BEGIN
			SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			IF(@BRANCH_TYPE = 'PGD' )
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD 
																FROM TL_SYS_ROLE_MAPPING 
																WHERE ROLE_NEW IN ('TPGD','PP') AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
				
			END
			ELSE IF(@BRANCH_TYPE = 'CN' )
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE 
				AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD 
																FROM TL_SYS_ROLE_MAPPING 
																WHERE ROLE_NEW IN ('GDDV','PGD') AND RECORD_STATUS = 1
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
			END
			ELSE IF(@BRANCH_TYPE = 'HS' )
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD 
																FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP') AND RECORD_STATUS = 1 AND BRANCH_ID =@BRANCH_CREATE AND DEP_ID =@DEP_CREATE
																		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
																		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE ='')))
			END
			SET @FLAG = 1
		END
	END
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_KT_SEND_APR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
		SET @FLAG = 1
	END
	ELSE IF (@TYPE = 'TR_REQ_PAYMENT_KT_SEND_SUG')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
		SET @FLAG = 1
	END
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_KT_APR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		SET @FLAG = 1
	END
	-- Tờ trình chủ trương
	ELSE IF(@TYPE = 'PL_SEND_APP' OR @TYPE ='PL_REQUEST_DOC_App'  OR @TYPE ='REQ_PROCESS_CHILD_Upd' OR @TYPE='REQ_PROCESS_CHILD_App')
	BEGIN
		SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
		INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
		EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='PL_REQ_PROCESS_CHILD_Ins')
	BEGIN
		DECLARE @PLREQ_ID VARCHAR(15)
		WHILE((SELECT COUNT(*) FROM @l_LST_REQ_ID) >0)
		BEGIN
			SET @PLREQ_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PLREQ_ID,@MAKER_ID,'TTCT-DVKD'
			DELETE FROM @l_LST_REQ_ID WHERE REQ_PAY_ID =@PLREQ_ID
		END
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='REQUEST_DOC_PROCESS_Approve')
	BEGIN
		IF(NOT EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='APPROVE'))
		BEGIN
			IF(NOT EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='TGD'))
			BEGIN
				SET @FLAG = 2
				--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
				EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
			END
			ELSE IF (EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='TGD'))
			BEGIN
				SET @FLAG = 2
				--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
				EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
				--INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP (REQ_ID,TLNAME) SELECT @PO_ID, TLNANME FROM TL_USER WHERE RoleName ='TGD'
			END
			ELSE IF (EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='HDQT'))
			BEGIN
				SET @FLAG = 2
				--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
				EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
				--INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP (REQ_ID,TLNAME) SELECT @PO_ID, TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
			END
		END
		ELSE
		BEGIN
			SET @FLAG = 3
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			--INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			--EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @REQ_ID,@MAKER_ID,'TTCT-DVKD'
		END
	END
	ELSE IF(@TYPE='RESEND_REQUEST_DOC_PROCESS_Approve') --- LUCTV 28.11.2022 BO SUNG THEM 1 TYPE DE ANH BAOTQ GUI MAIL VE THU KY TGD DE THU KY TGD COPY LINK GUI CEO TRONG TRUONG HOP CEO MISS MAIL
	BEGIN
		IF (EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='TGD'))
			BEGIN
				SET @FLAG = 2
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP (REQ_ID,TLNAME) SELECT @PO_ID, TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
			END
		ELSE IF (EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='HDQT'))
			BEGIN
				SET @FLAG = 2
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP (REQ_ID,TLNAME) SELECT @PO_ID, TLNANME FROM TL_USER WHERE RoleName ='TKHDQT'
		END
	END --- LUCTV 28.11.2022
	-------------------------------------------------------------------------------------------------------
	----- PHIẾU YÊU CẦU MUA SẮM --------------
	ELSE IF(@TYPE = 'TR_REQUEST_DOC_SendApp' OR @TYPE ='TR_REQUEST_DOC_App' OR @TYPE ='TR_REQ_PROCESS_CHILD_App' OR @TYPE ='TR_REQ_PROCESS_CHILD_Upd' OR @TYPE='REQ_PROCESS_CHILD_App')
	BEGIN
		-------------------Nếu PYCMS chưa hoàn tất-------------------
		IF(NOT EXISTS(SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='APPROVE'))
		BEGIN
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
			SET @FLAG = 2
		END
		-------------------Nếu PYCMS hoàn tất-------------------
		ELSE
		BEGIN
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			SET @NV_XL_MS =(SELECT TOP 1 USER_DVMS FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			SET @FLAG = 4
		END
	END
	ELSE IF(@TYPE='TR_REQ_PROCESS_CHILD_Ins')
	BEGIN
		
		DECLARE @REQ_DOC_ID VARCHAR(15)
		WHILE((SELECT COUNT(*) FROM @l_LST_REQ_ID) >0)
		BEGIN
			SET @REQ_DOC_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @REQ_DOC_ID,@MAKER_ID,'PYCMS-DVKD'
			DELETE FROM @l_LST_REQ_ID WHERE REQ_PAY_ID =@REQ_DOC_ID
		END
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='TR_REQUEST_DOC_PROCESS_Approve')
	BEGIN
		IF(NOT EXISTS(SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='APPROVE'))
		BEGIN
			--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
			SET @FLAG = 3
		END
		ELSE
		BEGIN
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			SET @NV_XL_MS =(SELECT TOP 1 USER_DVMS FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			SET @FLAG = 4
		END
	END
	----------------BAODNQ 20/10/2022 ; LẮP MAIL GỬI KHI CHUYỂN PYCMS CHO DVCM-----------------
	ELSE IF(@TYPE = 'TR_REQUEST_DOC_MOVE_DVCM')
	BEGIN
		SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
		INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
		EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
		SET @FLAG = 2
	END
	---------------ENDBAODNQ-----------------------------

	------BAODNQ 4/1/2022: --------------
	-----Khai báo DTSD nội bộ - gửi YC phê duyệt-------
	ELSE IF @TYPE='BUD_CONTRACT_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM BUD_CONTRACT_MASTER A WHERE A.CONTRACT_ID = @PO_ID)

		END
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--(SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PPGD'))
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--(SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG'))
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--(SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP'))
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		
		SET @FLAG = 5
	END
	
	-----Khai báo DTSD nội bộ - trung gian duyệt thành công-------
	ELSE IF @TYPE='BUD_CONTRACT_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PPGD'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 5
	END
	-----Khai báo DTSD nội bộ - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-------
	ELSE IF @TYPE='BUD_CONTRACT_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM BUD_CONTRACT_MASTER A WHERE A.CONTRACT_ID = @PO_ID)
		
		SET @FLAG = 5
	END
	---Quản lý hợp đồng khách thuê - gửi YC phê duyệt-----
	ELSE IF @TYPE='BUD_CONTRACT_CUST_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM BUD_CONTRACT_CUST_MASTER A WHERE A.CONTRACT_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END

		SET @FLAG = 5
	END
	---Quản lý hợp đồng khách thuê - trung gian duyệt thành công-----
	ELSE IF @TYPE='BUD_CONTRACT_CUST_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 5
	END
	---Quản lý hợp đồng khách thuê - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='BUD_CONTRACT_CUST_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM BUD_CONTRACT_CUST_MASTER A WHERE A.CONTRACT_ID = @PO_ID)
		SET @FLAG = 5
	END

	------datmq 7/1/2022: --------------
	-----Quản lý trụ sở - gửi YC phê duyệt-------
	ELSE IF @TYPE='BUD_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM BUD_MASTER A WHERE A.BUILDING_ID = @PO_ID)
		END
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 6
	END
	-----Quản lý trụ sở - trung gian duyệt thành công-------
	ELSE IF @TYPE='BUD_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PPGD'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 6
	END
	---Quản lý trụ sở - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='BUD_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM BUD_MASTER A WHERE A.BUILDING_ID = @PO_ID)
		SET @FLAG = 6
	END
	-----PhongNT 15/9/2022: Quản lý TSCĐ/CCLĐ--------
	-- Thêm mới tài sản HCQT
	
	ELSE IF @TYPE = 'ASS_SEND_TDV'
	BEGIN
		--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
		SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
		  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
		)x)

		SELECT @PAGE = sp.ID
		FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX

		
	 --   SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID)
		--SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		--SET @p_MAKER_ID = (SELECT MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID)
		--SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@PAGE='ASS_ADDNEW')
			BEGIN
				SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
				FROM (SELECT MAKER_ID FROM ASS_ADDNEW WHERE ADDNEW_ID =@PO_ID) A
				LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
				FROM (SELECT MAKER_ID FROM ASS_COLLECT_MULTI_MASTER WHERE COL_MULTI_MASTER_ID =@PO_ID) A
				LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
				FROM (SELECT MAKER_ID FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID =@PO_ID) A
				LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
				FROM (SELECT MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID =@PO_ID) A
				LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID	
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
				FROM (SELECT MAKER_ID FROM ASS_LIQUIDATION WHERE LIQ_ID =@PO_ID) A
				LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID	
			END
		ELSE IF(@PAGE='ASS_INVENTORY_MASTER')
			BEGIN
				IF((SELECT SIGN_USER FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @PO_ID) IS NOT NULL)
					BEGIN
						INSERT INTO @LST_USER_RECIVE (TLNAME)
						(SELECT SIGN_USER FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @PO_ID)
					END
				ELSE
					BEGIN
						SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
						FROM (SELECT MAKER_ID FROM ASS_INVENTORY_MASTER WHERE INVENT_ID =@PO_ID) A
						LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
					END
			END

		IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND BRANCH_ID = @BRANCH_CREATE
				AND DEP_ID = @DEP_CREATE
				AND ROLE_NEW IN ('GDDV','TP')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		ELSE IF(@BRANCH_TYPE IS NOT NULL)
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND BRANCH_ID = @BRANCH_CREATE
				AND ROLE_NEW IN ('GDDV','TPGD')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		SET @FLAG = 6
	END
	ELSE IF @TYPE = 'ASS_SEND_GDV'
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE('GDV','DV0001','DEP000000000022'))
			SET @FLAG = 6
		END
	ELSE IF @TYPE = 'ASS_REJECT_GDV'
		BEGIN
		--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
		SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
		  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
		)x)

		SELECT @PAGE = sp.ID
		FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX

			IF(@PAGE='ASS_ADDNEW')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				)

			END
		SET @FLAG = 6
	END
	ELSE IF @TYPE = 'ASS_SEND_KSV'
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE('KSV','DV0001','DEP000000000022'))
			SET @FLAG = 6
		END
	ELSE IF @TYPE = 'ASS_APPROVED'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
			  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)

			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX

			
		IF(@PAGE='ASS_ADDNEW')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				UNION
				SELECT MAKER_ID_KT
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				UNION
				SELECT MAKER_ID_KT
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				UNION
				SELECT MAKER_ID_KT
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				UNION
				SELECT MAKER_ID_KT
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				UNION
				SELECT MAKER_ID_KT
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				)

			END
		ELSE IF(@PAGE='ASS_UPDATE')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT MAKER_ID
			FROM ASS_UPDATE au WHERE au.UPDATE_ID = @PO_ID
			)

		END
		ELSE IF(@PAGE='ASS_INVENTORY_MASTER')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT MAKER_ID
			FROM ASS_INVENTORY_MASTER au WHERE au.INVENT_ID = @PO_ID
			)

		END
			SET @FLAG = 6
	END
	ELSE IF @TYPE = 'ASS_SEND_NT'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
			  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)

			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
      
		IF(@PAGE='ASS_ADDNEW')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				)
			END
    ELSE IF(@PAGE='ASS_UPDATE')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_UPDATE au WHERE UPDATE_ID = @PO_ID
				)
			END
   ELSE IF(@PAGE='ASS_COST_ALLOCATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_COST_ALLOCATION au WHERE au.COS_ID = @PO_ID
				)
      END
	    ELSE IF(@PAGE='CON_MASTER')
			BEGIN
				
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM CON_MASTER CM WHERE CM.CONSTRUCT_ID = @PO_ID
				)
      END
		 ELSE IF(@PAGE='CON_LAYOUT_BLUEPRINT')
			BEGIN
				
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM CON_LAYOUT_BLUEPRINT CM WHERE CM.CON_LAYOUT_BLUEPRINT_ID = @PO_ID
				)
      END
		SET @FLAG = 6
	END
	ELSE IF @TYPE = 'ASS_SEND_CONFIRM'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
				SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)

			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX

			DECLARE @BRANCH_ID VARCHAR(20),@DEP_ID VARCHAR(20)
		
		IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				SELECT TOP 1 @BRANCH_CREATE = A.BRANCH_ID,@DEP_CREATE = A.DEPT_ID_USE,@BRANCH_TYPE = B.BRANCH_TYPE
				FROM  dbo.ASS_COLLECT_MULTI_DT A
				LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID =B.BRANCH_ID
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				ORDER BY COLLECT_MULTI_ID ASC
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				SELECT TOP 1 @BRANCH_CREATE = A.BRANCH_ID, @DEP_CREATE = DEPT_ID,@BRANCH_TYPE = B.BRANCH_TYPE
				FROM  dbo.ASS_USE_MULTI_DT A
				LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID =B.BRANCH_ID
				WHERE A.USER_MASTER_ID = @PO_ID
				ORDER BY USE_MULTI_ID ASC
			END
		
    
		IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID AND DEP_ID = @DEP_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE AND DEP_ID = @DEP_CREATE))
				AND ROLE_NEW IN ('GDDV','TP')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		ELSE
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE))
				AND ROLE_NEW IN ('GDDV','TPGD')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		SET @FLAG =6
	END
	ELSE IF @TYPE ='ASS_TRANSFER_CONFIRM_HANDOVER'
	BEGIN
		SELECT TOP 1 @BRANCH_CREATE=A.BRANCH_ID_OLD,@DEP_CREATE =DEPT_ID_OLD,@BRANCH_TYPE =b.BRANCH_TYPE
		FROM  dbo.ASS_TRANSFER_MULTI_DT A
		LEFT  JOIN dbo.CM_BRANCH B ON B.BRANCH_ID = A.BRANCH_ID_OLD
		WHERE A.TRANS_MULTI_MASTER_ID = @PO_ID
		ORDER BY TRANSFER_MULTI_ID ASC

		IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID AND DEP_ID = @DEP_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE AND DEP_ID = @DEP_CREATE))
				AND ROLE_NEW IN ('GDDV','TP')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		ELSE
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE))
				AND ROLE_NEW IN ('GDDV','TPGD')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		SET @FLAG =6
	END
	ELSE IF @TYPE ='ASS_TRANSFER_CONFIRM_RECEIVER'
	BEGIN
		SELECT TOP 1 @BRANCH_CREATE =A.BRANCH_ID,@DEP_CREATE = DEPT_ID,@BRANCH_TYPE =b.BRANCH_TYPE
		FROM  dbo.ASS_TRANSFER_MULTI_DT A
		LEFT  JOIN dbo.CM_BRANCH B ON B.BRANCH_ID = A.BRANCH_ID
		WHERE A.TRANS_MULTI_MASTER_ID = @PO_ID
		ORDER BY TRANSFER_MULTI_ID ASC


		IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID AND DEP_ID = @DEP_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE AND DEP_ID = @DEP_CREATE))
				AND ROLE_NEW IN ('GDDV','TP')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		ELSE
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE))
				AND ROLE_NEW IN ('GDDV','TPGD')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		SET @FLAG =6
	END
	ELSE IF @TYPE ='ASS_INVENTORY_RECIVE_MAIL'
	BEGIN
		IF(EXISTS(SELECT 1 FROM ASS_INVENTORY_MASTER WHERE SIGN_USER IS NOT NULL AND CHECKER_ID_DVKD IS NULL AND INVENT_ID=@PO_ID))
			BEGIN
				SELECT @BRANCH_CREATE =BRANCH_ID,@DEP_ID = DEPT_ID FROM dbo.ASS_INVENTORY_MASTER WHERE INVENT_ID=@PO_ID
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE('GDDV',@BRANCH_CREATE,@DEP_ID))
			END
		ELSE
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT PARTY_NAME FROM dbo.ASS_INVENTORY_PARTY_DT WHERE IS_RECIVE_MAIL =1 AND INVENT_ID =@PO_ID)
			END
		
		SET @FLAG =6
	END
	ELSE IF @TYPE ='ASS_INVENTORY_MAIN'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		(SELECT PARTY_NAME FROM dbo.ASS_INVENTORY_PARTY_DT WHERE IS_MAIN = 1 AND INVENT_ID =@PO_ID)
		SET @FLAG =6
	END

	----------BAODNQ :15/2/2022 --Xử lý gửi mail cho phân hệ Quản lý BDS---------
	---Quản lý BDS- gửi YC phê duyệt-----
	ELSE IF @TYPE='RET_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT * FROM RET_MASTER WHERE RET_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM RET_MASTER A WHERE A.RET_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = 
				(SELECT  B.BRANCH_ID
				FROM RET_MASTER A
				LEFT JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
				WHERE RET_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_MASTER WHERE RET_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END

		SET @FLAG = 7
	END
	---Quản lý BDS - trung gian duyệt thành công-----
	ELSE IF @TYPE='RET_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = 
				(SELECT  B.BRANCH_ID
				FROM RET_MASTER A
				LEFT JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
				WHERE RET_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_MASTER WHERE RET_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---Quản lý BDS - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='RET_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM RET_MASTER A WHERE A.RET_ID = @PO_ID)
		SET @FLAG = 7
	END

	---Thông tin sửa chữa BDS- gửi YC phê duyệt-----
	ELSE IF @TYPE='RET_REPAIR_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM RET_REPAIR WHERE RP_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM RET_REPAIR A WHERE A.RP_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT OFFER_BRANCH FROM RET_REPAIR WHERE RP_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_REPAIR WHERE RP_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))

			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))

			END
		END

		SET @FLAG = 7
	END
	---Thông tin sửa chữa BDS - trung gian duyệt thành công-----
	ELSE IF @TYPE='RET_REPAIR_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT OFFER_BRANCH FROM RET_REPAIR WHERE RP_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_REPAIR WHERE RP_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))

		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))

		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))

		END
		
		SET @FLAG = 7
	END
	---Thông tin sửa chữa BDS - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='RET_REPAIR_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM RET_REPAIR A WHERE A.RP_ID = @PO_ID)
		SET @FLAG = 7
	END

	---BDS thuê làm trụ sở CN/PGD - gửi YC phê duyệt-----
	ELSE IF @TYPE='REAL_ESTATE_R_H_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM REAL_ESTATE_R_H A WHERE A.RET_R_H_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))

			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END

		SET @FLAG = 7
	END
	---BDS thuê làm trụ sở CN/PGD - trung gian duyệt thành công-----
	ELSE IF @TYPE='REAL_ESTATE_R_H_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---BDS thuê làm trụ sở CN/PGD - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='REAL_ESTATE_R_H_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM REAL_ESTATE_R_H A WHERE A.RET_R_H_ID = @PO_ID)
		SET @FLAG = 7
	END

	---BDS đang hoàn thiện thủ tục pháp lý - gửi YC phê duyệt-----
	ELSE IF @TYPE='REAL_ESTATE_L_C_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM REAL_ESTATE_L_C A WHERE A.RET_L_C_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END

		SET @FLAG = 7
	END
	---BDS đang hoàn thiện thủ tục pháp lý - trung gian duyệt thành công-----
	ELSE IF @TYPE='REAL_ESTATE_L_C_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---BDS đang hoàn thiện thủ tục pháp lý - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='REAL_ESTATE_L_C_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM REAL_ESTATE_L_C A WHERE A.RET_L_C_ID = @PO_ID)
		SET @FLAG = 7
	END
	--PHONGNT 24/2/2022 PHIẾU YÊU CẦU CÔNG TÁC--
	---PHIẾU YÊU CẦU CÔNG TÁC - gửi YC cho cấp phê duyệt trung gian---
	ELSE IF @TYPE='TR_REQUEST_JOB_FORM_SIGN'
	BEGIN
		DECLARE @SIGN_USER VARCHAR(20)
		SET @SIGN_USER = (SELECT SIGN_USER FROM TR_REQUEST_JOB_FORM WHERE REQ_ID = @PO_ID)
		IF (@SIGN_USER ='TKTGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
						SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE(@SIGN_USER,'','')
			END	
		ELSE IF (@SIGN_USER IS NOT NULL)
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
						(SELECT A.SIGN_USER FROM TR_REQUEST_JOB_FORM A WHERE A.REQ_ID = @PO_ID) 
			END

		SET @FLAG = 7
	END
	ELSE IF @TYPE='TR_REQUEST_JOB_FORM_SEND'
	BEGIN
		DECLARE @DVCM_ID VARCHAR(20)
		SELECT TOP 1 @ROLE_CURRENT = Temp.ROLE_USER, @DVCM_ID=Temp.DVDM_ID,@BRANCH_ID =Temp.BRANCH_ID,@DEP_ID=Temp.DEP_ID 
		FROM dbo.PL_REQUEST_PROCESS Temp WHERE Temp.REQ_ID=@PO_ID AND (Temp.STATUS='C' OR Temp.STATUS='R')

		IF(@ROLE_CURRENT IN ('GDK','PTGD'))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
							(SELECT TLNANME FROM dbo.FN_GET_USER_MANAGER_BY_DVCM(@ROLE_CURRENT,@DVCM_ID)) 
			END
		ELSE 
			BEGIN
				IF(EXISTS(SELECT 1 FROM dbo.FN_GET_USER_BY_ROLE(@ROLE_CURRENT,@BRANCH_ID,@DEP_ID)))
					BEGIN
						INSERT INTO @LST_USER_RECIVE (TLNAME)
								(SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE(@ROLE_CURRENT,@BRANCH_ID,@DEP_ID))
					END
				ELSE
					BEGIN
						INSERT INTO @LST_USER_RECIVE (TLNAME)
								(SELECT value FROM wsiSplit(@ROLE_CURRENT,','))
					END
			END
		SET @FLAG = 7
	END
	---Phiếu yêu cầu công tác - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='TR_REQUEST_JOB_FORM_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		(SELECT A.MAKER_ID FROM TR_REQUEST_JOB_FORM A WHERE A.REQ_ID = @PO_ID)
		UNION ALL
		(SELECT A.EMP_ID FROM TR_REQUEST_JOB_FORM A WHERE A.REQ_ID = @PO_ID)
		SET @FLAG = 7
	END
	--PHONGNT 24/2/2022 PHIẾU YÊU CẦU XE--
	---PHIẾU YÊU CẦU XE - gửi YC phê duyệt---
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_TDV'
	BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQUEST_CAR WHERE REQ_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM TR_REQUEST_CAR WHERE REQ_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)

			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER A
						JOIN AbpUserRoles B ON B.UserId = A.ID
						JOIN AbpRoles C ON C.Id=B.RoleId
						WHERE 1=1
						AND A.TLSUBBRID = @BRANCH_CREATE
						AND C.DisplayName IN ('TPGD', 'PPGD')
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER A
						JOIN AbpUserRoles B ON B.UserId = A.ID
						JOIN AbpRoles C ON C.Id=B.RoleId
						WHERE 1=1
						AND A.TLSUBBRID = @BRANCH_CREATE
						AND RoleName IN ('GDDV', 'PDG')
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER A
						JOIN AbpUserRoles B ON B.UserId = A.ID
						JOIN AbpRoles C ON C.Id=B.RoleId
						WHERE 1=1
						AND A.TLSUBBRID = @BRANCH_CREATE
						AND A.DEP_ID = @DEP_CREATE
						AND RoleName IN ('GDDV', 'TP','TBP','PP')
			END
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - gửi mail cho người cập nhật phiếu-----
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_USERUPD'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT USER_UPDATE FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - gửi mail cho CVĐĐ Xe-----
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_CV'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT CDVAL FROM CM_ALLCODE  WHERE CDNAME = 'REQCAR') 
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - gửi mail cho người tạo-----
	ELSE IF @TYPE='TR_REQUEST_CAR_COST_SEND_MAKER'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT MAKER_ID FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - CVĐĐ Xe đã duyệt, gửi mail cho Lãnh Đạo HC HO-----
	ELSE IF @TYPE='TR_REQUEST_CAR_COST_CV_App'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQUEST_CAR WHERE REQ_ID = @PO_ID)
		INSERT INTO @LST_USER_RECIVE (TLNAME)
					(SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND RoleName IN ('GDDV', 'PP'))
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - Gửi CV và người tạo-----
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_CV_USER'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT MAKER_ID FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT USER_UPDATE FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		SET @FLAG = 7
	END
	-- Kho vật liệu
	ELSE IF (@TYPE = 'MW_IN_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_IN_MASTER WHERE IN_ID = @PO_ID AND AUTH_STATUS = 'A' AND AUTH_STATUS_KT = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_IN_MASTER WHERE IN_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
	ELSE IF (@TYPE = 'MW_OUT_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_OUT WHERE OUT_ID = @PO_ID AND AUTH_STATUS = 'A' AND KT_AUTH_STATUS = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_OUT WHERE OUT_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
	ELSE IF (@TYPE = 'MW_TRANSFER_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_TRANSFER WHERE TRANSFER_ID = @PO_ID AND AUTH_STATUS = 'A' AND KT_AUTH_STATUS = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_TRANSFER WHERE TRANSFER_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
	ELSE IF (@TYPE = 'MW_LIQUID_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_LIQ_MASTER WHERE LIQ_ID = @PO_ID AND AUTH_STATUS = 'A' AND KT_AUTH_STATUS = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_LIQ_MASTER WHERE LIQ_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
  ELSE IF @TYPE = 'TR_REJECT_GDV'
		BEGIN
		--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
		SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
		  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
		)x)

		SELECT @PAGE = sp.ID
		FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
			IF(@PAGE='TR_REQ_PAYMENT')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM TR_REQ_PAYMENT 
				WHERE REQ_PAY_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='TR_REQ_ADVANCE_PAMENT')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM TR_REQ_ADVANCE_PAYMENT 
				WHERE REQ_PAY_ID = @PO_ID
				)
			END
		
		SET @FLAG = 6
	END
  ELSE IF @TYPE = 'TR_REJECT_NT'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
			  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)
      

			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
			
		IF(@PAGE='TR_REQ_PAYMENT')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM TR_REQ_PAYMENT 
				WHERE REQ_PAY_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='TR_REQ_ADVANCE_PAMENT')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM TR_REQ_ADVANCE_PAYMENT 
				WHERE REQ_PAY_ID = @PO_ID
				)
			END
		SET @FLAG = 6
	END

	----------------BAODNQ 26/10/2022 : GỬI MAIL QUẢN LÝ HỢP ĐỒNG-------------------
	--------------------NG TẠO GỬI YÊU CẦU PHÊ DUYỆT HỢP ĐỒNG--------------------
	ELSE IF (@TYPE = 'TR_CONTRACT_SEND_APP')
	BEGIN
		DECLARE @p_MAKER_BRANCH_CREATE VARCHAR(15), 
				@p_MAKER_BRANCH_TYPE VARCHAR(15),
				@p_MAKER_DEP_CREATE VARCHAR(15)
		SET @p_MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_CONTRACT WHERE CONTRACT_ID = @PO_ID)
		SET @p_MAKER_BRANCH_CREATE  = (SELECT TOP 1 TLSUBBRID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		SET @p_MAKER_BRANCH_TYPE = (SELECT TOP 1 BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @p_MAKER_BRANCH_CREATE)
		SET @p_MAKER_DEP_CREATE =(SELECT TOP 1 DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		SET @p_DEP_CREATE_CODE = (SELECT TOP 1 DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID = @p_MAKER_DEP_CREATE)
		IF(@p_MAKER_BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME
				FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @p_MAKER_BRANCH_CREATE
				AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF (@p_MAKER_BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME
				FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @p_MAKER_BRANCH_CREATE
				AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF (@p_MAKER_BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME
				FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @p_MAKER_BRANCH_CREATE
				AND DEP_ID = @p_MAKER_DEP_CREATE
				AND(
					(------------Nếu là phòng hành chính, k gửi mail cho GDDV-------------
						@p_DEP_CREATE_CODE = '0690604'
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TBP', 'TP', 'PP')) 
					)
					OR(------------Các phòng ban khác gửi mail bth-------------
						@p_DEP_CREATE_CODE <> '0690604'
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP')) 
					)
				)
		END

		SET @FLAG = 9
	END

	--------------------TRƯỞNG ĐV ĐÃ DUYỆT, TRẢ MAIL VỀ CHO NG TẠO---------------------
	ELSE IF (@TYPE = 'TR_CONTRACT_APPROVE')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT A.MAKER_ID FROM TR_CONTRACT A WHERE A.CONTRACT_ID = @PO_ID)
		SET @FLAG = 9
	END

	----------------BAODNQ 26/10/2022 : GỬI MAIL QUẢN LÝ PO-------------------
	--------------------NG TẠO GỬI YÊU CẦU PHÊ DUYỆT PO--------------------
	ELSE IF(@TYPE = 'TR_PO_MASTER_SEND_APP')
	BEGIN
		SET @BRANCH_CREATE = (SELECT TOP 1 BRANCH_ID FROM TR_PO_MASTER WHERE PO_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT TOP 1 BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_PO_MASTER WHERE PO_ID = @PO_ID)
		SET @DEP_CREATE = (SELECT TOP 1 DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		SET @p_DEP_CREATE_CODE = (SELECT TOP 1 DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID = @DEP_CREATE)

		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME
				FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF (@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME
				FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME
				FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND DEP_ID = @DEP_CREATE
				AND(
					(------------Nếu là phòng hành chính, k gửi mail cho GDDV-------------
						@p_DEP_CREATE_CODE = '0690604'
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TBP', 'TP', 'PP')) 
					)
					OR(------------Các phòng ban khác gửi mail bth-------------
						@p_DEP_CREATE_CODE <> '0690604'
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP')) 
					)
				)
				
		END

		SET @FLAG = 10
	END

	--------------------TRƯỞNG ĐV ĐÃ DUYỆT, TRẢ MAIL VỀ CHO NG TẠO---------------------
	ELSE IF(@TYPE = 'TR_PO_MASTER_APPROVE')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT A.MAKER_ID FROM TR_PO_MASTER A WHERE A.PO_ID = @PO_ID)
		SET @FLAG = 10
	END
	------------------END BAODNQ--------------------

	----- END PYC MUA SẮM --------------------

	----------------BAODNQ 30/11/2022 : GỬI MAIL ĐÁNH GIÁ NCC------------------------------
	---------------Ng tạo gửi phê duyệt, cấp trung gian duyệt, trưởng đơn vị duyệt---------------------
	---------------NVXL ĐMMS gửi phê duyệt, KSV/trưởng đơn vị ĐMMS duyệt, lãnh đạo khối/GDK hỗ trợ duyệt, điều phối xử lý---------------------------
	ELSE IF(@TYPE = 'TR_RATE_SUPPLIER_MASTER_SendAppr' OR @TYPE = 'TR_RATE_SUPPLIER_MASTER_Confirm' OR @TYPE = 'TR_RATE_SUPPLIER_MASTER_App'
			OR @TYPE = 'TR_RATE_SUPPLIER_PROCESS_CHILD_Upd' OR @TYPE = 'TR_RATE_SUPPLIER_PROCESS_CHILD_App'
			OR @TYPE = 'TR_RATE_SUPPLIER_MASTER_PROCESS_App' OR @TYPE = 'TR_RATE_SUPPLIER_PROCESS_CHILD_Ins')
	BEGIN
		SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_RATE_SUPPLIER_MASTER WHERE RATE_ID =@PO_ID)
		--------------Nếu phiếu chưa hoàn tất, gửi mail cho ng xử lý kế tiếp-----------------
		IF(NOT EXISTS(SELECT RATE_ID FROM TR_RATE_SUPPLIER_MASTER WHERE RATE_ID = @PO_ID AND PROCESS_STATUS = 'APPROVE'))
		BEGIN
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'RATE_SUP'
			SET @FLAG = 11
		END
		--------------Nếu đã hoàn tất, gửi mail cho ng tạo-----------------
		ELSE
		BEGIN
			INSERT INTO @LST_USER_RECIVE(TLNAME)
				SELECT @MAKER_ID
			SET @FLAG = 12
		END
		
	END

	---START hieuhm 09/11/2022 Gửi phê duyệt công trình, gửi mail cho người duyệt-----
	ELSE IF @TYPE='CON_MASTER_SendApp'
	BEGIN
		DECLARE @BRANCH_ID_CONMASTER VARCHAR(15) = '', @DEP_ID_CONMASTER VARCHAR(15) =''
		--SELECT @BRANCH_ID_CONMASTER = BRANCH_ID, @DEP_ID_CONMASTER = DEP_CREATE FROM CON_MASTER WHERE CONSTRUCT_ID = @PO_ID
		INSERT INTO @LST_USER_RECIVE (TLNAME) (SELECT TLNANME FROM [dbo].[FN_GET_USER_BY_ROLE] ('GDDV',@BRANCH_ID_CONMASTER,@DEP_ID_CONMASTER))
		SET @FLAG = 6
	END
	---END hieuhm 09/11/2022 Gửi phê duyệt công trình, gửi mail cho người duyệt-----

	---START hieuhm 11/11/2022 Phê duyệt công trình, gửi mail cho người tạo-----
	ELSE IF @TYPE='CON_MASTER_APP'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) (SELECT MAKER_ID FROM CON_MASTER CM WHERE CM.CONSTRUCT_ID = @PO_ID)		
		SET @FLAG = 6
	END
	---END hieuhm 11/11/2022 Phê duyệt công trình, gửi mail cho người tạo-----

	---START hieuhm 16/11/2022 Gửi phê duyệt layout bản vẽ, gửi mail cho người duyệt-----
	ELSE IF (@TYPE='CON_LAYOUT_BLUEPRINT_App' OR @TYPE ='CON_LAYOUT_BLUEPRINT_SendApp')
	BEGIN
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND [STATUS] = 'C' AND PROCESS_ID <> 'APPROVE'))
		BEGIN
			DECLARE @BRANCH_ID_CONLB VARCHAR(15) = '', @DEP_ID_CONLB VARCHAR(15) ='', @ROLE_CONLB VARCHAR(15) ='',@PROCESS_ID_CONLB VARCHAR(15) ='',@DVDM_ID_CONLB VARCHAR(15) =''
			SELECT @BRANCH_ID_CONLB = BRANCH_ID,@DEP_ID_CONLB = DEP_ID,@ROLE_CONLB = ROLE_USER,@PROCESS_ID_CONLB = PROCESS_ID,@DVDM_ID_CONLB = DVDM_ID FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND [STATUS] = 'C'
			IF(@PROCESS_ID_CONLB NOT IN ('GDK_HT','PTGD_TC','PTGD_VH'))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) (SELECT DISTINCT TLNANME FROM [dbo].[FN_GET_USER_BY_ROLE] (@ROLE_CONLB,@BRANCH_ID_CONLB,@DEP_ID_CONLB))
			END
			ELSE
			BEGIN
				DECLARE @BRANCH_TYPE_CONLB VARCHAR(15) = (SELECT BRANCH_TYPE FROM dbo.CM_BRANCH WHERE BRANCH_ID = @BRANCH_ID_CONLB)
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME FROM (
					SELECT TU.TLNANME, TU.TLFullName, TU.TLSUBBRID AS BRANCH_ID, TU.SECUR_CODE AS DEP_ID, R.DisplayName AS ROLE_OLD, TRM.ROLE_NEW,NULL AS EFF_DATE, NULL AS EXP_DATE
					FROM dbo.TL_USER TU
					LEFT JOIN dbo.AbpUserRoles UR ON TU.ID = UR.UserId
					INNER JOIN dbo.AbpRoles R ON R.Id = UR.RoleId
					LEFT JOIN (SELECT * FROM dbo.TL_SYS_ROLE_MAPPING RM WHERE RM.TLNAME IS NULL OR RM.TLNAME = '') TRM ON (TRM.ROLE_OLD = R.DisplayName)
					UNION ALL
					SELECT TU.TLNANME, TU.TLFullName, RM.BRANCH_ID, RM.DEP_ID, RM.ROLE_OLD, RM.ROLE_NEW, RM.EFF_DATE,RM.EXP_DATE
					FROM dbo.TL_USER TU
					LEFT JOIN dbo.TL_SYS_ROLE_MAPPING RM ON TU.TLNANME = RM.TLNAME
					WHERE CAST(RM.EXP_DATE AS DATE) >= CAST(GETDATE() AS DATE)
				) TMP 
				WHERE 1 = 1
				AND ((TMP.ROLE_OLD = @ROLE_CONLB OR TMP.ROLE_NEW = @ROLE_CONLB ) OR @ROLE_CONLB IS NULL OR @ROLE_CONLB = '')
				AND ((TMP.BRANCH_ID IN (SELECT BRANCH_ID FROM PL_COSTCENTER_DT WHERE COST_ID IN (select COST_ID from PL_COSTCENTER where DVDM_ID = @DVDM_ID_CONLB)) AND TMP.DEP_ID IN (SELECT DEP_ID FROM PL_COSTCENTER_DT WHERE COST_ID IN (select COST_ID from PL_COSTCENTER where DVDM_ID = @DVDM_ID_CONLB)))
					OR (NOT EXISTS(SELECT * FROM PL_COSTCENTER_DT WHERE COST_ID IN (select COST_ID from PL_COSTCENTER where DVDM_ID = @DVDM_ID_CONLB)))
				)
			END
		END
		SET @FLAG = 6
	END
	-----END hieuhm 16/11/2022 Gửi phê duyệt layout bản vẽ, gửi mail cho người duyệt-----
	IF(@FLAG = 0)
	BEGIN 
		SELECT A.*,B.TLFullName,B.EMAIL 
		FROM TL_ROLE_NOTIFICATION A
		LEFT JOIN TL_USER B ON A.TL_NAME=B.TLNANME
		WHERE EXISTS(SELECT * FROM @LST_POID WHERE ID = A.PO_ID)
		
	END
	ELSE IF(@FLAG = 1)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1 >2
		WHERE (A.TLNANME IN (SELECT * FROM @LST_USER_RECIVE))
		--AND A.TLNANME NOT IN  ('trungnq1','taila')
	END
	-- NEU LA TO TRINH CHU TRUONG, PYC MS THÌ TRA VE FLAG =2
	ELSE IF(@FLAG = 2)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1>2
		WHERE (A.TLNANME IN (SELECT TLNAME FROM @PL_PROCESS_CURRENT_SEARCH_TEMP))
		--AND A.TLNANME NOT IN  ('trungnq1','taila')
		
	END
	-- SAU KHI TT CHU TRUONG DUOC PHE DUYET THI THONG BAO CHO NGUOI TAO TO TRINH
	ELSE IF(@FLAG = 3)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1>2
		WHERE (A.TLNANME  =@MAKER_ID OR A.TLNANME IN (SELECT TLNAME FROM @PL_PROCESS_CURRENT_SEARCH_TEMP))
		--AND A.TLNANME NOT IN  ('trungnq1','taila')
	END
	-- SAU KHI PYCMS  DUOC PHE DUYET THI THONG BAO CHO NGUOI TAO VA NGUOI XU LY
	ELSE IF(@FLAG = 4)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1>2
		WHERE (A.TLNANME  =@MAKER_ID OR A.TLNANME =@NV_XL_MS)
		--AND A.TLNANME NOT IN  ('trungnq1','taila')
	END

	-----------Quản lý cho thuê----------------
	ELSE IF(@FLAG = 5)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END

	ELSE IF(@FLAG = 6)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------BAODNQ 15/2/2022: Quản lý BDS--------------------
	ELSE IF(@FLAG = 7)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------QUẢN LÝ THANH TOÁN TẠM ỨNG------------------
	ELSE IF(@FLAG = 8)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------BAODNQ 26/10/2022 QUẢN LÝ HỢP ĐỒNG MUA SẮM-------------------
	ELSE IF (@FLAG = 9)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------BAODNQ 26/10/2022 QUẢN LÝ PO-------------------
	ELSE IF (@FLAG = 10)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------BAODNQ 30/11/2022 ĐÁNH GIÁ NCC------------------
		-------------Nếu phiếu chưa hoàn tất---------------
	ELSE IF(@FLAG = 11)
	BEGIN
		SELECT TU.TLFullName, TU.EMAIL AS Email, TU.ID AS [USER_ID]
		FROM TL_USER TU
		WHERE TU.TLNANME IN (SELECT TLNAME FROM @PL_PROCESS_CURRENT_SEARCH_TEMP)
	END
		-------------Nếu phiếu đã hoàn tất---------------
	ELSE IF(@FLAG = 12)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END