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

CREATE proc JMO_GBL_Selp (
   @k_gbl_name      char(8)
)
as
begin
   Select
      gbl_name,
      gbl_adate,
      gbl_atime,
      gbl_ldate,
      gbl_ltime,
      gbl_ndate,
      gbl_ntime,
      gbl_fdate,
      gbl_ftime,
      next_rpt,
      gbl_ltype,
      gbl_flag1,
      act_trkset,
      prescan_min,
      prescan_max,
      prescan_total,
      prescan_cnt                        
   From jmo_gbl
   Where
       gbl_name         >= @k_gbl_name
   Order by
       gbl_name
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_GBL_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Selp] TO [uniuser]
GO