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

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