DBA Data[Home] [Help]

APPS.JL_JLBRPCDN_XMLP_PKG SQL Statements

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

Line: 11

        SELECT
          SET_OF_BOOKS_ID
        INTO P_SET_OF_BOOKS_ID
        FROM
          AP_SYSTEM_PARAMETERS;
Line: 20

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