USP_DATALIST_STEWARDSHIPPACKAGEPROCESSES
This returns a list of stewardship packages.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_STEWARDSHIPPACKAGEPROCESSES
as
set nocount on;
select
STEWARDSHIPPACKAGEPROCESS.ID,
STEWARDSHIPPACKAGEPROCESS.NAME,
STEWARDSHIPPACKAGEPROCESS.DESCRIPTION,
STEWARDSHIPPACKAGEPROCESS.WORDTEMPLATEFILENAME,
dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(STEWARDSHIPPACKAGEPROCESS.BUSINESSPROCESSVIEWID)
from
dbo.STEWARDSHIPPACKAGEPROCESS
order by
STEWARDSHIPPACKAGEPROCESS.NAME;