APPS.PA_PAXPEAST_XMLP_PKG SQL Statements

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

Line: 6

/*  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;*/

Line: 10

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

Line: 32

   select substrb(name,1,60) into Org_Name from
          hr_organization_units
   where
       organization_id = ORGANIZATION_ID_T;

Line: 39

    select name into Job_Name from per_jobs
    where
       job_id = JOB_ID_T;

Line: 45

  select meaning into Sort_By_Meaning from
          pa_lookups
   where  lookup_code = SORT_BY and
          lookup_type = 'ASSIGNMENT SORT BY';