| Operation Details |  |
| Description: | Reads the EvidenceDescriptorID based on the correctionsetid, pendingremovalInd and NewInd. |
| Sterotype: | ns |
| SQL | |
select evidencedescriptorID, evidenceType, relatedID INTO :evidenceDescriptorID, :evidenceType, :relatedID FROM EVIDENCEDESCRIPTOR WHERE CORRECTIONSETID = :correctionSetID AND STATUSCODE = 'EDS1' AND NEWIND = '1' AND PENDINGUPDATEIND ='1'; |