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


CREATE proc JMO_PRB_Self (
   @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_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Self] TO [uniadmin]
GO