APPS.PA_PAXEXONE_XMLP_PKG SQL Statements

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

Line: 56

   select substr(name,1,30)
   into org_name from
   hr_organization_units
   where organization_id = incurred_org;

Line: 67

    select SUBSTR(full_name,1,80)
    into   hold_employee_name
    from   per_people_f
    where  person_id = employee_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: 93

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl
  WHERE   gl.set_of_books_id = p_ca_set_of_books_id;

Line: 247

select decode(mrc_sob_type_code,'R','R','P')
into p_mrcsobtype
from gl_sets_of_books
where set_of_books_id = p_ca_set_of_books_id;