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

CREATE proc JMO_GEN_Selp (
   @k_scp_key       char(8)
)
as
begin
   Select
      scp_key,
      scj_prty,
      scg_en1,
      scg_en2,
      scg_en6,
      sca_utotm,
      sca_utoit,
      scw_s,
      scd_tab,
      sch_istc,
      scm_xaudt,
      scq_name,
      scm_axpsr,
      scm_axinp,
      scm_axres
   From jmo_gen
   Where
       scp_key          >= @k_scp_key
   Order by
       scp_key
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_GEN_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Selp] TO [uniuser]
GO