
[dbo].[XLedgerDeleteUnencounteredSubledgerHiddenIndicators]
CREATE PROCEDURE [dbo].[XLedgerDeleteUnencounteredSubledgerHiddenIndicators]
@xLedgerSyncHistoryId int
AS
begin
set nocount on
declare @items PriKeyToIntMap
insert into @items(Id,Value)
select XLedgerHiddenSubledger.XLedgerDbId, null
from XLedgerHiddenSubledger
where XLedgerSyncHistoryFid is null or XLedgerSyncHistoryFid <> @xLedgerSyncHistoryId
exec XLedgerImportSubledgerHiddenIndicators
@items = @items,
@xLedgerSyncHistoryId = @xLedgerSyncHistoryId
end
GO
GRANT EXECUTE ON [dbo].[XLedgerDeleteUnencounteredSubledgerHiddenIndicators] TO [MssExec]
GO