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


CREATE proc JMO_STR1_Selp (
   @k_str_name      char(65),
   @k_str_qual      char(5)
)
as
begin
   Select
      str_name,
      str_qual,
      str_avgtb,
      str_ows,
      str_ws,
      str_wstyp,
      str_any,
      str_erly,
      str_must,
      str_dedln,
      str_mxtim,
      str_avgt,
      str_jcont,
      str_flg1,
      str_flg3,
      str_bklog,
      str_histc,
      str_desc,
      str_newpr,
      str_fordate,
      str_erdt,
      str_mudt,
      str_dedt,
      str_mxdt,
      str_adate,
      str_vdate,
      str_sdate,
      str_edate,
      str_pdate,
      str_atime,
      str_vtime,
      str_stime,
      str_etime,
      str_dprty,
      str_cc,
      str_hstat,
      str_rstat,
      str_flg5,
      str_cmrun,
      str_cmhld,
      str_cmrls,
      str_cmcnc,
      str_cmfrc,
      str_cal,
      str_faill,
      str_failh,
      str_subu,
      str_subp,
      str_domain,
      str_flg4,
      str_sutyp,
      str_qname
   From jmo_str1
   Where
       str_name         >= @k_str_name      and
       str_qual         >= @k_str_qual
   Order by
       str_name,
       str_qual
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_STR1_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Selp] TO [uniuser]
GO