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


CREATE proc JMO_PSRT_Selp (
   @k_psr_scdn      char(65),
   @k_psr_name      char(65),
   @k_psr_jno       char(5),
   @k_psr_qual      char(5),
   @k_psr_pscd      char(65),
   @k_psr_pjob      char(65),
   @k_psr_pjno      char(5),
   @k_psr_pqua      char(5)   
)
as
begin
   Select
      psr_scdn,
      psr_name,
      psr_jno,
      psr_qual,
      psr_pscd,
      psr_pjob,
      psr_pjno,
      psr_pqua,
      psr_flag
   From jmo_psrt
   Where
       psr_scdn         >= @k_psr_scdn      and
       psr_name         >= @k_psr_name      and
       psr_jno          >= @k_psr_jno       and
       psr_qual         >= @k_psr_qual      and
       psr_pscd         >= @k_psr_pscd      and
       psr_pjob         >= @k_psr_pjob      and
       psr_pjno         >= @k_psr_pjno      and
       psr_pqua         >= @k_psr_pqua  
       
   Order by
       psr_scdn,
       psr_name,
       psr_jno,
       psr_qual,
       psr_pscd,
       psr_pjob,
       psr_pjno,
       psr_pqua
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_PSRT_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSRT_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_PSRT_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSRT_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_PSRT_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSRT_Selp] TO [uniuser]
GO