APPS.CS_SR_FUL_AMV_PKG SQL Statements

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

Line: 7

  PROCEDURE Update_AMV(p_file_id in Number)
  IS

  BEGIN
      UPDATE JTF_AMV_ATTACHMENTS
	    SET FILE_ID = p_file_id
      WHERE ATTACHMENT_USED_BY_ID = 1000;

Line: 15

      UPDATE FND_LOBS
        SET FILE_NAME = 'SRseed.html'
     WHERE  FILE_ID = p_file_id;

Line: 29

  END Update_AMV;