ALTER   PROC [dbo].[TR_REQ_PAY_PERIOD_BYID]
@p_REQ_PAY_ID VARCHAR(15)= NULL
AS
BEGIN
SELECT A.* ,ISNULL(B.CONTRACT_CODE,B.CONTRACT_ID) AS CONTRACT_CODE , B.CONTRACT_NAME, C.REQ_PAY_CODE, S.ACC_NUM,S.ACC_NAME,S.BANK_NAME,S.ACC_NUM_OUT,S.ACC_NAME_OUT,S.BANK_NAME_OUT, D.REQ_PAY_CODE AS SO_PHIEU_TAM_UNG,D.REQ_DT AS NGAY_TAM_UNG,
	S.TAX_NO AS SUP_TAX_NO, B.END_DT AS END_DT
FROM TR_REQ_PAY_PERIOD A
LEFT JOIN TR_CONTRACT B ON A.CONTRACT_ID = B.CONTRACT_ID
LEFT JOIN CM_SUPPLIER S ON B.SUP_ID = S.SUP_ID
LEFT JOIN TR_REQ_PAYMENT C ON A.REQ_PAY_ID = C.REQ_PAY_ID
LEFT JOIN TR_REQ_ADVANCE_PAYMENT D ON A.AD_PAY_ID = D.REQ_PAY_ID
WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

END