USP_REPORT_DEFAULTCREDITCARDRECEIPT_GETORDERINFORMATION

create procedure [dbo].[USP_REPORT_DEFAULTCREDITCARDRECEIPT_GETORDERINFORMATION]
as
    set nocount on;
    set transaction isolation level read uncommitted;

    select top 1
        ORGANIZATIONINFORMATION.NAME,
        ORGANIZATIONINFORMATION.ADDRESSBLOCK,
        ORGANIZATIONINFORMATION.CITY,
        isnull(STATE.ABBREVIATION, N'') STATE,
        ORGANIZATIONINFORMATION.POSTCODE,
        ORGANIZATIONINFORMATION.PHONENUMBER,
        ORGANIZATIONINFORMATION.WEBADDRESS,
        cast(dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(getutcdate()) as nvarchar) TIMEOFPURCHASE
    from
        dbo.ORGANIZATIONINFORMATION
    left outer join
        dbo.STATE on ORGANIZATIONINFORMATION.STATEID = STATE.ID;

    return 0;