create procedure [dbo].[MssWebCheckCanEditOrderInvoiceRequirement]
    @inOrderId int,
    @inSysUserId int
as
begin
    ;with UserAccessDetail as (
    select UserSecProfileId = UserAccess.SecProfilePriKey
    from Sysuser
    inner join UserAccess on Sysuser.SysUserID = UserAccess.SysUserID
    where Sysuser.SysUserID = @inSysUserId),
    OrderBranchId as (select BranchId = Orders.BranchPriKey from Orders where Orders.PriKey = @inOrderId)    
    select SecProfileDetail.ManagerFlag from SecProfileDetail
    inner join OrderBranchId on OrderBranchId.BranchId = SecProfileDetail.BranchPriKey
    inner join SecModules on SecModules.ModulePriKey = SecProfileDetail.ModulePriKey
    inner join UserAccessDetail on UserAccessDetail.UserSecProfileId = SecProfileDetail.SecProfilePriKey
    where SecModules.Description ='Order Information'
end
GO
GRANT EXECUTE ON  [dbo].[MssWebCheckCanEditOrderInvoiceRequirement] TO [MssExec]
GO