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

CREATE proc JMO_JBR_Self (
   @k_jbr_scdn      char(65),
   @k_jbr_name      char(65),
   @k_jbr_jno       char(5)
   )
as
begin
   Select
      jbr_scdn,
      jbr_name,
      jbr_jno,
      jbr_ws,
      jbr_jobtyp,
      jbr_any,
      jbr_subu,
      jbr_abscd,
      jbr_jprty,
      jbr_abct,
      jbr_cal,
      jbr_erly,
      jbr_must,
      jbr_dedln,
      jbr_mxtim,
      jbr_avg,
      jbr_effdt,
      jbr_expdt,
      jbr_histc,
      jbr_flg1,
      jbr_bklog,
      jbr_recs1,
      jbr_desc,
      jbr_subfile,
      jbr_creus,
      jbr_credt,
      jbr_cretm,
      jbr_lusdt,
      jbr_lustm,
      jbr_user,
      jbr_skip,
      jbr_faill,
      jbr_failh,
      jbr_subp,
      jbr_domain,
      jbr_cycle,
      jbr_freq,
      jbr_count,
      jbr_ccal,
      jbr_cri,
      jbr_hact,
      jbr_nwact,
      jbr_cadj,
      jbr_sutyp,
      jbr_qname
   From jmo_jbr
   Where
       jbr_name         = @k_jbr_name      and
       jbr_jno          = @k_jbr_jno       and
       jbr_scdn         = @k_jbr_scdn
   Order by
       jbr_scdn,
       jbr_name,
       jbr_jno
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JBR_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JBR_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JBR_Self] TO [uniadmin]
GO