APPS.EDR_PSIG_MSCA_PAGE_FLOW SQL Statements

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

Line: 38

  SELECT min(signature_sequence) into l_sign_sequence
  FROM   edr_esignatures
  WHERE  EVENT_ID = p_event_id
  and    SIGNATURE_STATUS = 'PENDING';

Line: 77

  UPDATE EDR_ESIGNATURES
    SET SIGNATURE_STATUS      = p_action_code ,
        SIGNATURE_TYPE        = l_SIGNER_code,
        SIGNATURE_REASON_CODE = l_signing_reason_code,
        SIGNATURE_TIMESTAMP   = SYSDATE,
        SIGNER_COMMENTS       = l_signer_comment
   WHERE         EVENT_ID = p_event_id
   AND          user_name = p_user_name
   AND SIGNATURE_SEQUENCE = p_sign_sequence;