[dbo].[MssWebGetValuationDeclinedReasonLookups]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebGetValuationDeclinedReasonLookups

Properties
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

CREATE PROCEDURE [dbo].[MssWebGetValuationDeclinedReasonLookups]
as
begin
    set nocount on

    select
        [Key] = InternationalValuationDeclinedReasonID,
        [Value] = Reason
    from InternationalValuationDeclinedReason
    order by Reason

end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetValuationDeclinedReasonLookups] TO [MssExec]
GO

Uses

[dbo].[InternationalValuationDeclinedReason]
dbo