APPS.PA_PAXPEJOB_XMLP_PKG SQL Statements

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

Line: 6

  select name
  into l_name
  from gl_sets_of_books
  where set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID');

Line: 24

   select meaning into Sort_By_Name from pa_lookups
     where lookup_code = P_SORT_BY
       and lookup_type = 'JOB SORT BY';