DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

USE [AMSGD3]

GO

/****** Object:  StoredProcedure [dbo].[TR_REQ_PAY_SERVICE_ById]    Script Date: 5/11/2022 3:05:29 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROC [dbo].[TR_REQ_PAY_SERVICE_ById]

@p_REQ_PAY_ID varchar(15)

AS

BEGIN

	SELECT A.*,P.REQ_CODE AS EMP_NAME, D.DEP_CODE, D.DEP_NAME, A.SERVICE_NAME AS REQ_PAY_SERVICE_NAME, A.TOTAL_AMT AS TOTAL_AMT_SERVICE

	FROM TR_REQ_PAY_SERVICE A 

	--LEFT JOIN TL_USER T ON A.EMP_ID = T.TLNANME

	LEFT JOIN PL_REQUEST_DOC P ON A.EMP_ID = P.REQ_ID

	LEFT JOIN CM_DEPARTMENT D ON A.DEPT_ID= D.DEP_ID

	WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

END