SQL:AdminICEvidenceTypeDefLink.searchByAdminICAndEvidenceTypeStatus

Operation Details

Description:
Sterotype:	nsmulti

SQL

SELECT
  AdminICEvidenceTypeDefLink.adminICEvidenceTypeDefLinkID,
  AdminICEvidenceTypeDefLink.evidenceTypeDefID
INTO
  :adminICEvidenceTypeDefLinkID,
  :evidenceTypeDefID
FROM
  AdminICEvidenceTypeDefLink,
  EvidenceTypeDef
WHERE AdminICEvidenceTypeDefLink.adminIntegratedCaseID = :adminIntegratedCaseID
  AND EvidenceTypeDef.evidenceTypeDefID = AdminICEvidenceTypeDefLink.evidenceTypeDefID
  AND EvidenceTypeDef.recordStatus = :recordStatus

Database SQL Operation: AdminICEvidenceTypeDefLink.searchByAdminICAndEvidenceTypeStatus