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


CREATE proc JMO_SBR_Self (
   @k_sbr_name      char(65)
)
as
begin
   Select
      sbr_name,
      sbr_effdt,
      sbr_expdt,
      sbr_sprty,
      sbr_stype,
      sbr_any,
      sbr_ws,
      sbr_cal,
      sbr_erly,
      sbr_must,
      sbr_dedln,
      sbr_mxtim,
      sbr_avg,
      sbr_flg1,
      sbr_bklog,
      sbr_recs1,
      sbr_histc,
      sbr_creus,
      sbr_credt,
      sbr_cretm,
      sbr_lusdt,
      sbr_lustm,
      sbr_skip,
      sbr_user,
      sbr_desc,
      sbr_faill,
      sbr_failh,
      sbr_subu,
      sbr_subp,
      sbr_domain,
      sbr_ccal,
      sbr_cri,
      sbr_hact,
      sbr_nwact,
      sbr_cadj,
      sbr_sutyp,
      sbr_qname
   From jmo_sbr
   Where
       sbr_name         = @k_sbr_name
   Order by
       sbr_name
end
GO
GRANT EXECUTE ON  [dbo].[JMO_SBR_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SBR_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SBR_Self] TO [uniadmin]
GO