APPS.WF_DIG_SIG_EVIDENCE_STORE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

  Select SIG_ID
    from wf_dig_sigs
    where Sig_Obj_Type = ObjType
      and Sig_Obj_ID = ObjID
      order by sig_id desc;

Line: 59

  Select nvl(Cert_ID,-1)
    into retval
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 85

  Select Sig_Flavor
    into retval
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 111

  Select Sig_Policy
    into retval
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 133

  Select Signature
    into Sig
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 155

  Select Sig_Obj_Type, Sig_Obj_ID, Plaintext
    into ObjType, ObjID, ObjText
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 187

  Select Status, Creation_Date, Signed_Date, Verified_Date,
	Last_Validation_Attempt, Validated_Complete_Date, Errbuf, ErrStack
    into SigStatus, CreationDate, SignedDate, VerifiedDate,
	LastAttValDate, ValidatedDate, Ebuf, Estack
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 220

  Select Requested_Signer_Type, Requested_Signer_ID
    into SignerType, SignerID
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 245

  Select c.Owner_domain, c.Owner_ID
    into SignerType, SignerID
    from wf_dig_sigs S, wf_dig_certs C
   where S.Sig_Id = SigID
     and S.cert_id = C.cert_id;

Line: 274

  Select Cert_Type
    into retval
    from wf_dig_certs
   where Cert_Id = CertID;