APPS.GL_CA_UTILITY_PKG SQL Statements

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

Line: 73

    SELECT n_sob_list(i).r_sob_id,
           n_sob_list(i).r_sob_name,
           n_sob_list(i).r_sob_curr
    INTO p_sob_list(i).r_sob_id,
         p_sob_list(i).r_sob_name,
         p_sob_list(i).r_sob_curr
    FROM dual;

Line: 153

    SELECT l_conversion_date,
           l_conversion_type,
           l_conversion_rate,
           l_numerator_rate,
           l_denominator_rate,
           l_result_code
      INTO p_sob_list(l_counter).conversion_date,
           p_sob_list(l_counter).conversion_type,
           p_sob_list(l_counter).conversion_rate,
           p_sob_list(l_counter).numerator_rate,
           p_sob_list(l_counter).denominator_rate,
           p_sob_list(l_counter).result_code
      FROM DUAL;