ALTER PROC [dbo].[TR_REQ_PAY_AUTO_GET_BILL_EFFECTIVE_TYPE_B]
@p_REQ_PAY_AUTO_TYPE varchar(20) = NULL
AS
BEGIN	
	SELECT
	B.BILLCODE AS billCode, 
	B.PRVCODE AS prvCode, 
	B.SEVCODE AS sevCode, 
	CAST(FORMAT (DATEADD(DAY,-7, GETDATE()), 'dd/MM/yyyy') AS NVARCHAR) AS fromDate, 
	B.CUSTOMER_CODE AS customerNo
	FROM TR_REQ_PAYMENT_AUTO A
	LEFT JOIN TR_REQ_PAY_AUTO_RECURRING B ON A.REQ_PAY_AUTO_ID = B.REQ_PAY_AUTO_ID
	WHERE A.REQ_PAY_AUTO_TYPE = 'B' 
	AND A.AUTH_STATUS_KT = 'A' 
	AND A.RECORD_STATUS = '1' 
	AND A.REQ_PAY_AUTO_STATUS = 'EFFECTIVE'
	AND A.CONTRACT_ID IS NOT NULL
	AND B.IS_REGISTER = '1'
	AND ISNULL(B.BILLID, '') <> ''
END
--29052023_secretkey