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


CREATE proc JMO_JHR_Selp (
   @k_jhr_jschd     char(65),
   @k_jhr_name      char(65),
   @k_jhr_jno       char(5),
   @k_jhr_key       char(12)
)
as
begin
   Select
      jhr_jschd,
      jhr_name,
      jhr_jno,
      jhr_key,
      jhr_ws,
      jhr_avcpu,
      jhr_hcnt,
      jhr_erdt,
      jhr_msdt,
      jhr_deddt,
      jhr_adate,
      jhr_vdate,
      jhr_sdate,
      jhr_edate,
      jhr_ertm,
      jhr_mstm,
      jhr_dedtm,
      jhr_atime,
      jhr_vtime,
      jhr_stime,
      jhr_etime,
      jhr_relpt,
      jhr_rcput,
      jhr_code,
      jhr_qual,
      jhr_stat,
      jhr_late,
      jhr_cmrun,
      jhr_cmhld,
      jhr_cmrls,
      jhr_cmcnc,
      jhr_cmfrc,
      jhr_cmstr,
      jhr_cmcmp,
      jhr_pid,
      jhr_uxjno,
      jhr_sysid,
      jhr_avelp,
      jhr_qname
   From jmo_jhr
   Where
       jhr_jschd        >= @k_jhr_jschd     and
       jhr_name         >= @k_jhr_name      and
       jhr_jno          >= @k_jhr_jno       and
       jhr_key          >= @k_jhr_key
   Order by
       jhr_jschd,
       jhr_name,
       jhr_jno,
       jhr_key
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JHR_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Selp] TO [uniuser]
GO