USP_DATALIST_INCENTIVELEVELBASICINFO
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_INCENTIVELEVELBASICINFO
(
@ID uniqueidentifier
)
as
set nocount on;
select IL.ID, IL.NAME, IL.DESCRIPTION, IL.TYPE, TYPECODE, MAXIMUMAMOUNT, MAXIMUMNUMBER, MAXIMUMRETENTION, IL.DATECHANGED, IL.EVENTID,E.NAME from dbo.FAFINCENTIVELEVEL IL(nolock)
left join EVENT E on e.ID=EVENTID
where IL.ID = @ID