USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTADDRESSTOKENS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTADDRESSTOKENS
(
    @DATALOADED bit = 0 output,
    @VALUETYPE tinyint = null output,
    @COUNTRYID uniqueidentifier = null output
)
as
    set nocount on;
    set @DATALOADED = 1;
    set @VALUETYPE = 0;

    select top 1
        @COUNTRYID = DEFAULTCOUNTRYID
    from dbo.INTERNATIONALIZATIONINFO;

    -- If no default country exists, try for the US.  If that fails, raise an error.
    if @COUNTRYID is null
        select @COUNTRYID = ID
        from dbo.COUNTRY
        where ISO3166 = 'US';

    if @COUNTRYID is null
        raiserror('No system default country has been specified.', 13, 1);

    return 0;