UFN_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_GETLETTERCODES
Returns all letter codes for a given assign letter codes process.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASSIGNPLANNEDGIFTLETTERCODESPROCESSID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_GETLETTERCODES
(
@ASSIGNPLANNEDGIFTLETTERCODESPROCESSID uniqueidentifier
)
returns table
as
return
(
select
CODES.ID,
CODES.PLANNEDGIFTLETTERCODEID,
CODES.SEQUENCE
from
dbo.ASSIGNPLANNEDGIFTLETTERCODESPROCESSLETTERCODES CODES
inner join
dbo.PLANNEDGIFTLETTERCODE on CODES.PLANNEDGIFTLETTERCODEID = PLANNEDGIFTLETTERCODE.ID
where
ASSIGNPLANNEDGIFTLETTERCODESPROCESSID = @ASSIGNPLANNEDGIFTLETTERCODESPROCESSID
and PLANNEDGIFTLETTERCODE.ISACTIVE = 1
)