DECLARE @p_REQ_PAY_ID varchar(15) = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT where REQ_PAY_CODE = '052025/001237')
  DECLARE @quantity int, @quantity1 int, @quantity2 int, @quantity3 int
 SET @quantity = ( SELECT count(*)
	FROM TR_REQ_PAY_INVOICE A
  WHERE  (@p_REQ_PAY_ID = A.REQ_PAY_ID)	AND A.TYPE_FUNC='HC')

   SET @quantity1 = ( SELECT count(*)
	FROM TR_REQ_PAY_INVOICE A
	LEFT JOIN TR_REQ_PAYMENT B ON  A.REQ_PAY_ID = B.REQ_PAY_ID
	WHERE 1=1
	AND (@p_REQ_PAY_ID = A.REQ_PAY_ID)	AND A.TYPE_FUNC='HC')

   SET @quantity2 = ( SELECT count(*)
	FROM TR_REQ_PAY_INVOICE A
	LEFT JOIN TR_REQ_PAYMENT B ON  A.REQ_PAY_ID = B.REQ_PAY_ID
	LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID
	WHERE 1=1
	AND (@p_REQ_PAY_ID = A.REQ_PAY_ID)	AND A.TYPE_FUNC='HC')


  SET @quantity3 = ( SELECT count(*)
	FROM TR_REQ_PAY_INVOICE A
	LEFT JOIN TR_REQ_PAYMENT B ON  A.REQ_PAY_ID = B.REQ_PAY_ID
	LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID
	LEFT JOIN TL_USER US ON B.MAKER_ID = US.TLNANME
	WHERE 1=1
	AND (@p_REQ_PAY_ID = A.REQ_PAY_ID)	AND A.TYPE_FUNC='HC')

SELECT @quantity, @quantity1, @quantity2, @quantity3