APPS.JL_JLBRPICR_XMLP_PKG SQL Statements

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

Line: 11

      SELECT
        SUBSTR(NAME
              ,1
              ,30),
        CURRENCY_CODE
      INTO L_NAME,CURR
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;

Line: 33

      DELETE FROM JL_BR_AP_INT_COLLECTION_TMP
       WHERE FILE_CONTROL = P_FILE_CONTROL;