APPS.ITG_SYNCEXCHINBOUND_PVT SQL Statements

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

Line: 15

            SELECT    1
            INTO      l_number
            FROM      DUAL
            WHERE EXISTS (SELECT t.conversion_type
                          from gl_daily_conversion_types_v t
                          where t.conversion_type <> 'User'
                          and t.conversion_type <> 'EMU FIXED'
                          and t.modify_privilege = 'Y'
                          and t.conversion_type = p_ratetype);

Line: 43

                SELECT currency_code
                INTO   l_currency_code
                FROM   gl_sets_of_books
                WHERE  set_of_books_id = p_sob_id;

Line: 92

        SELECT currency_code,
               precision,
               extended_precision,
               derive_type
        FROM   fnd_currencies
        WHERE  currency_code      =  p_ccode
        AND    enabled_flag       =  'Y'
        AND    currency_flag      =  'Y'
        AND    (start_date_active <= p_effective_date
                OR     start_date_active IS NULL)
        AND    (end_date_active   >= p_effective_date
                OR    end_date_active    IS NULL);

Line: 159

                                        select to_number(p_factor) into l_var from dual;

Line: 238

                /* insert data */
                g_action := 'Exchange-rate creation';

Line: 246

                     itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);

Line: 252

                INSERT INTO gl_daily_rates_interface(
                              from_currency, to_currency,
                              from_conversion_date, to_conversion_date,
                              user_conversion_type, conversion_rate, mode_flag
                 ) VALUES (
                              p_currency_from, p_currency_to,
                              p_effective_date, p_effective_date,
                              p_ratetype, l_quantity, 'I');

Line: 266

                              SELECT error_code
                              FROM   gl_daily_rates_interface
                              WHERE  from_currency        = p_currency_from
                              AND    to_currency          = p_currency_to
                              AND    from_conversion_date = p_effective_date
                              AND    to_conversion_date   = p_effective_date
                              AND    user_conversion_type = 'Corporate'
                              AND    mode_flag            = 'X';