APPS.PA_PAXPCEGS_XMLP_PKG SQL Statements

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

Line: 34

select
 Substr(name, 1, 60)  into
 c_org_name
from
 hr_organization_units
where
 organization_id =  p_start_organization_id;

Line: 51

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

select
nvl(p_start_organization_id,start_organization_id)
into
 c_start_organization_id
from
 pa_implementations;

Line: 70

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

Line: 82

   delete from pa_org_reporting_sessions
   where session_id = userenv( 'SESSIONID' );