USP_AWARDMANAGEMENTSYNCEDRECORD_GET
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BUSINESSPROCESSPARAMETERSETID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_AWARDMANAGEMENTSYNCEDRECORD_GET
(
@BUSINESSPROCESSPARAMETERSETID uniqueidentifier
)
as
set nocount on;
select
ID,
BUSINESSPROCESSPARAMETERSETID,
AMRECORDID,
DATESYNCED
from dbo.AWARDMANAGEMENTSYNCEDRECORD
where BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID
order by AMRECORDID;