USP_REPORT_DEFAULTREFUNDCREDITCARDRECEIPT_GETORDERINFORMATION

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

    select top 1
        NAME,
        ADDRESSBLOCK,
        CITY,
        coalesce(ABBREVIATION, '') STATE,
        POSTCODE,
        PHONENUMBER,
        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;