ALTER PROC [dbo].[TR_REQ_PAY_ENTRIES_ById]
@p_TRN_ID varchar(15) = NULL
AS
BEGIN
SELECT A.REQ_PAY_DT_ID, A.REQ_PAY_ID,A.FUNCTION_TYPE,A.REF_ID,A.ENTRY_PAIR,A.DR_CR,A.DR_CR_NAME,A.ACCT,ISNULL(C.ACC_NAME,'') AS ACCT_NAME,A.BRANCH_ID,A.DEP_ID,A.AMT,A.CURRENCY,A.EXC_RATE,A.TRN_DATE,A.TRN_DESC,
A.MAKER_ID,A.CREATE_DT,A.AUTH_STATUS,A.CHECKER_ID,A.APPROVE_DT,A.MAKER_ID_KT,A.CREATE_DT_KT,A.AUTH_STATUS_KT,A.CHECKER_ID_KT,A.RECORD_STATUS
, BR.BRANCH_CODE, BR.BRANCH_NAME, BR.BRANCH_CODE+' - '+ BR.BRANCH_NAME AS BR_FULLNAME,
DP.DEP_CODE, DP.DEP_NAME, DP.DEP_CODE+ ' - '+ DP.DEP_NAME AS DP_FULLNAME
FROM TR_REQ_PAY_ENTRIES A
LEFT JOIN CM_BRANCH BR ON A.BRANCH_ID = BR.BRANCH_ID
LEFT JOIN CM_DEPARTMENT DP ON A.DEP_ID= DP.DEP_ID
LEFT JOIN CM_ACCOUNT C ON A.ACCT = C.ACC_NO
WHERE A.REQ_PAY_ID =@p_TRN_ID OR @p_TRN_ID =''
END