/****** Object:  Stored Procedure dbo.JMO_JHR_Del    Script Date: 12/1/2005 11:49:18 PM ******/


CREATE proc JMO_JHR_Del (
   @k_jhr_jschd     char(65),
   @k_jhr_name      char(65),
   @k_jhr_jno       char(5),
   @k_jhr_key       char(12)
)
as
begin
   Delete From jmo_jhr
   Where
       jhr_jschd        = @k_jhr_jschd     and
       jhr_name         = @k_jhr_name      and
       jhr_jno          = @k_jhr_jno       and
       jhr_key          = @k_jhr_key

end
GO
GRANT EXECUTE ON  [dbo].[JMO_JHR_Del] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Del] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Del] TO [uniadmin]
GO