oracle中查询某个存储过程是否存在

SELECT DISTINCT NAME
  FROM USER_SOURCE
 WHERE TYPE = 'PROCEDURE'
   and name in
       ('TS_ZM_WMQYJLJGMYMSZMSQB',    
'CKTS_ZM_DLJKHWZMSQB',          
'CKTS_ZM_CKHJCPMSZMSBB',        
'CKTS_ZM_ZYMSGJCKJYZMSQBZB',    
'CKTS_ZM_LLJGMSZMSQBZB',        
'CKTS_ZM_DLCKHWZMSQBZB',        
'CKTS_ZM_LLJGCKHWMSZMHXSQBZB',  
'CKTS_ZM_CKHWWTSZMSQB',         
'CKTS_ZM_STNXZSHWJXSEDKZMSQB',  
'CKTS_ZM_JLJGMYMSZM_SH',        
'CKTS_ZM_DLJKHWZMSQB',          
'CKTS_ZM_TYYBJSWZM_SH',         
'CKTS_ZM_CKHJCPMSZMSBB_SH',     
'CKTS_ZM_ZYMSGJCKJYZMSQBZB',    
'CKTS_ZM_LLJGMSZMSQBZB',        
'CKTS_ZM_DLZKHWZM_SH',          
'CKTS_ZM_LLJGMYMSHXZMSQB',      
'CKTS_ZM_CKHWWTSZMSQB',         
'CKTS_ZM_STNXZSHWJXSEDKZMSQB',  
'CKTS_ZM_TYYBSWTSZMSQB');