create procedure [dbo].[MssWebDeleteOAndILocalServiceLocationMapping]
    @inOrderId int,
    @inLocalServiceId int,
    @inLocationId int
as
begin
    set nocount on;
    delete LocServOrderLocationMap from LocServOrderLocationMap
    inner join LocServ on LocServ.PriKey =  LocServOrderLocationMap.LocServFID and LocServ.OrdPriKey = @inOrderId
    where LocServOrderLocationMap.LocServFID = @inLocalServiceId
    and LocServOrderLocationMap.OrderLocationFID = @inLocationId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteOAndILocalServiceLocationMapping] TO [MssExec]
GO