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


CREATE proc JMO_PRB_Selp (
   @k_prb_scdn      char(65),
   @k_prb_name      char(65),
   @k_prb_jno       char(5),
   @k_prb_seq       char(5)
)
as
begin
   Select
      prb_scdn,
      prb_name,
      prb_jno,
      prb_seq,
      prb_parm1,
      prb_parm2,
      prb_parm3,
      prb_parm4

   From jmo_prb
   Where
       prb_scdn         >= @k_prb_scdn      and
       prb_name         >= @k_prb_name      and
       prb_jno          >= @k_prb_jno       and
       prb_seq          >= @k_prb_seq       
   Order by
       prb_scdn,
       prb_name,
       prb_jno,
       prb_seq
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_PRB_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Selp] TO [uniuser]
GO