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


CREATE proc JMO_PRT1_Selp (
   @k_prt_scdn      char(65),
   @k_prt_name      char(65),
   @k_prt_jno       char(5),
   @k_prt_qual      char(5),
   @k_prt_seq       char(5)
)
as
begin
   Select
      prt_scdn,
      prt_name,
      prt_jno,
      prt_qual,
      prt_seq,
      prt_parm1,
      prt_parm2,
      prt_parm3,
      prt_parm4
   From jmo_prt1
   Where
       prt_scdn         >= @k_prt_scdn      and
       prt_name         >= @k_prt_name      and
       prt_jno          >= @k_prt_jno       and
       prt_qual         >= @k_prt_qual      and
       prt_seq          >= @k_prt_seq
   Order by
       prt_scdn,
       prt_name,
       prt_jno,
       prt_qual,
       prt_seq
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Selp] TO [uniuser]
GO