APPS.PA_PAXEMRAO_XMLP_PKG SQL Statements

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

Line: 56

select substr(name,1,40)
into   org_name
from   hr_organization_units
where  organization_id = start_org_id;

Line: 66

   select   substr(full_name,1,50)
   into     hold_employee_name
   from     per_people_f
   where    person_id = p_person_id
    and   sysdate between effective_start_date
					 and  nvl(effective_end_date,sysdate + 1)
    and   (employee_number IS NOT NULL OR npw_number IS NOT NULL );

Line: 77

    select substr(meaning,1,40) into yes_no from fnd_lookups
    where lookup_code = display_detail
    and   lookup_type =  'YES_NO';

Line: 107

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

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

Line: 134

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

Line: 246

 select meaning into message_name from pa_lookups
 where lookup_type = 'MESSAGE'
 and lookup_code = 'NO_DATA_FOUND';