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