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


CREATE proc JMO_SHR_Selp (
   @k_shr_name      char(65),
   @k_shr_key       char(12)
)
as
begin
   Select
      shr_name,
      shr_key,
      shr_avelp,
      shr_avcpu,
      shr_hcnt,
      shr_erdt,
      shr_msdt,
      shr_deddt,
      shr_adate,
      shr_vdate,
      shr_sdate,
      shr_edate,
      shr_ertm,
      shr_mstm,
      shr_dedtm,
      shr_atime,
      shr_vtime,
      shr_stime,
      shr_etime,
      shr_relpt,
      shr_rcput,
      shr_qual,
      shr_cc,
      shr_ws,
      shr_stat,
      shr_late,
      shr_cmrun,
      shr_cmhld,
      shr_cmrls,
      shr_cmcnc,
      shr_cmfrc,
      shr_avgtb,
      shr_qname
   From jmo_shr
   Where
       shr_name         >= @k_shr_name      and
       shr_key          >= @k_shr_key
   Order by
       shr_name,
       shr_key
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_SHR_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SHR_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_SHR_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SHR_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_SHR_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_SHR_Selp] TO [uniuser]
GO