APPS.PA_PAXRWLCO_XMLP_PKG SQL Statements

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

Line: 7

  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: 41

    select substr(name,1,60) into Org_Name from
           hr_organization_units
    where organization_id = START_ORG_ID;

Line: 47

   select meaning into Sort_By_Name from pa_lookups
   where lookup_code = SORT_BY
      and lookup_type ='LABOR RATE SORT BY';

Line: 69

select
 decode(start_org_id,null,      start_organization_id,start_org_id)
 into
     c_start_organization_id
 from
  pa_implementations;

Line: 76

insert into
pa_org_reporting_sessions
(start_organization_id,session_id)
values
(c_start_organization_id,userenv('SESSIONID'));