APPS.IEX_CURRENCY_PVT SQL Statements

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

Line: 19

    SELECT  precision,
            minimum_accountable_unit
    FROM    fnd_currencies
    WHERE   currency_code = cp_currency_code;

Line: 343

        SELECT PRECISION,
               MINIMUM_ACCOUNTABLE_UNIT,
               CURRENCY_CODE
        FROM   FND_CURRENCIES
        WHERE  CURRENCY_CODE = cc;

Line: 1198

    SELECT  gll.currency_code,
            gll.ledger_id
    INTO    g_functional_currency,
            g_set_of_books_id
    FROM    ar_system_parameters    sp,
            gl_ledgers_public_v     gll
    WHERE   gll.ledger_id = sp.set_of_books_id;

Line: 1357

  SELECT  count(distinct gll.currency_code)
  INTO    cnt_currency
  FROM    ar_system_parameters    sp,
          gl_ledgers_public_v     gll
  WHERE   gll.ledger_id = sp.set_of_books_id;