APPS.PA_PAXAASRP_XMLP_PKG SQL Statements

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

Line: 49

    select substr(function_name, 1, 40)
    into   hold_function_name
    from   pa_functions
    where  function_code = p_function_code;

Line: 70

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl,pa_implementations pi
  WHERE   gl.set_of_books_id = pi.set_of_books_id;