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


CREATE proc JMO_JWB_Selp (
   @k_jwb_scdn      char(65),
   @k_jwb_name      char(65),
   @k_jwb_jno       char(5),
   @k_jwb_resn      char(17)
)
as
begin
   Select
      jwb_scdn,
      jwb_name,
      jwb_jno,
      jwb_resn,
      jwb_srt,
      jwb_srv,
      jwb_flag,
      jwb_desc
   From jmo_jwb
   Where
       jwb_scdn         >= @k_jwb_scdn      and
       jwb_name         >= @k_jwb_name      and
       jwb_jno          >= @k_jwb_jno       and
       jwb_resn         >= @k_jwb_resn
   Order by
       jwb_scdn,
       jwb_name,
       jwb_jno,
       jwb_resn
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JWB_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Selp] TO [uniuser]
GO