USE [AMSGD3]
GO
/****** Object:  StoredProcedure [dbo].[TR_REQ_PAY_ENTRIES_ById]    Script Date: 7/21/2022 10:17:56 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[MW_IN_Retry_Entries_ToCore]
@p_TRN_ID varchar(15) = NULL
AS
BEGIN
	
	IF(EXISTS(SELECT A.* FROM MW_ENTRIES_POST A WHERE A.TRN_ID = @p_TRN_ID AND (A.REF_NO IS NULL OR A.REF_NO = '')))
	BEGIN
		SELECT '-1' as Result, ''  LOG_ID , N'Các bút toán bắn vào core thất bại' ErrorDesc
		RETURN '-1'
	END
	ELSE
	BEGIN
		SELECT '0' as Result, ''  LOG_ID ,'' ErrorDesc
		RETURN '0'
	END
END