SELECT
  evidenceBrokerConfigID,
  sourceType,
  sourceID,
  sourceSystemID,
  targetType,
  targetID,
  sourceEvidenceType,
  targetEvidenceType,
  autoAcceptInd,
  webServicesInd,
  sharedType,
  shareVerificationsOption,
  externalSystem,
  recordStatus,
  readOnlyInd,
  logicESharingRules,
  logicESharingRulesFileName,
  trustedSource,
  versionNo
INTO
  :evidenceBrokerConfigID,
  :sourceType,
  :sourceID,
  :sourceSystemID,
  :targetType,
  :targetID,
  :sourceEvidenceType,
  :targetEvidenceType,
  :autoAcceptInd,
  :webServicesInd,
  :sharedType,
  :shareVerificationsOption,
  :externalSystem,
  :recordStatus,
  :readOnlyInd,
  :logicESharingRules,
  :logicESharingRulesFileName,
  :trustedSource,
  :versionNo 
FROM
  EvidenceBrokerConfig 
WHERE 
(
      targetID = :targetID 
      OR 
      targetID IS NULL
)
AND 
 (
    targetType = :targetType 
    OR 
    targetType IS NULL 
  )
  AND 
  (
    targetEvidenceType = :targetEvidenceType 
    OR 
    targetEvidenceType IS NULL 
  ) 
  AND
 (
      externalSystem = :targetSystemID 
      OR 
      externalSystem IS NULL
  )
  AND recordStatus = :recordStatus 
  ORDER BY sourceID,
  sourceType,
  sourceEvidenceType