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


CREATE proc JMO_TRG_Self (
   @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
end
GO
GRANT EXECUTE ON  [dbo].[JMO_TRG_Self] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Self] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRG_Self] TO [uniadmin]
GO