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


CREATE proc JMO_TRG_Selp (
   @k_trg_trev      char(9),
   @k_trg_trid      char(65)
)
as
begin
   Select
      trg_trev,
      trg_trid,
      trg_apc7,
      trg_desc,
      trg_jnam,
      trg_usid,
      trg_stan,
      trg_faill,
      trg_failh,
      trg_file,
      trg_ustat,
      trg_skip,
      trg_jobn,
      trg_scdn,
      trg_estar,
      trg_efend,
      trg_qnam,
      trg_bklog,                     
      trg_cal,                     
      trg_auto,                            
      trg_recs1,                  
      trg_ccal,                 
      trg_cri,                 
      trg_hact,                    
      trg_nwact,                
      trg_cadj
   From jmo_trg
   Where
       trg_trev         >= @k_trg_trev      and
       trg_trid         >= @k_trg_trid
   Order by
       trg_trev,
       trg_trid
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_TRG_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Selp] TO [uniuser]
GO