USP_POSTTOGLPROCESS_GETSYSTEMNAME
Get the account system name for Post process.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_POSTTOGLPROCESS_GETSYSTEMNAME(@ID uniqueidentifier)
with execute as owner
as
begin
select
PDACCOUNTSYSTEM.NAME
from dbo.BUSINESSPROCESSSTATUS
inner join dbo.POSTTOGLPROCESS on BUSINESSPROCESSSTATUS.BUSINESSPROCESSPARAMETERSETID = POSTTOGLPROCESS.ID
inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTSYSTEM.ID = POSTTOGLPROCESS.PDACCOUNTSYSTEMID
where BUSINESSPROCESSSTATUS.ID = @ID;
end