APPS.PA_PAPWPRIREP_XMLP_PKG SQL Statements

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

Line: 7

    SELECT
      SUBSTR(GL.NAME,1,50)
    INTO COMPANY_NAME_HEADER
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 29

      delete from  PA_PWP_RELEASE_REPORT where  request_id = P_REQUEST_ID ;