DBA Data[Home] [Help]

APPS.JL_JLBRRIVB_XMLP_PKG SQL Statements

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

Line: 19

      SELECT
        FCURR.CURRENCY_CODE,
        FCURR.PRECISION,
        GSBKS.NAME
      INTO BASE_CURR,PREC,ORG_NAME
      FROM
        AR_SYSTEM_PARAMETERS ASP,
        FND_CURRENCIES_VL FCURR,
        GL_SETS_OF_BOOKS GSBKS
      WHERE ASP.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
        AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;