USP_BBNC_GETPENDINGBATCHESFROMTEMPLATE

Retrieves a list of batches whose status is open, pending, declined or approved for the specified batch template id for BBNC.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_BBNC_GETPENDINGBATCHESFROMTEMPLATE(@BATCHTEMPLATEID uniqueidentifier)

            as

            set nocount on;            

            select ID
            from dbo.BATCH
            where BATCHTEMPLATEID = @BATCHTEMPLATEID
            and STATUSCODE = 0
            order by DATEADDED;