APPS.PA_PAXAUMTC_XMLP_PKG SQL Statements

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

Line: 61

    select substr(full_name,1,40)
    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))
          or (effective_start_date > sysdate))
    and   (employee_number IS NOT NULL or npw_number IS NOT NULL);

Line: 73

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

Line: 81

  select substr(full_name,1,30)
  into person_name
  from per_people_f
  where person_id = supervisor
  and   ((sysdate between effective_start_date
		    and nvl(effective_end_date,sysdate + 1))
        or (effective_start_date > sysdate))
  and   (employee_number IS NOT NULL or npw_number IS NOT NULL);

Line: 91

 select '' into person_name from dual;

Line: 115

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

    where_stmt := where_stmt||' union select to_date('||''''||l_dummy_date||''''|| ','||''''||l_dt_format||''''|| ') from dual';

Line: 160

	 where_stmt := where_stmt || ' minus select distinct to_date(expenditure_ending_date,'||''''||l_dt_format||''''||') from pa_expenditures where expenditure_ending_date between :date_lo and :date_hi  and expenditure_class_code in (' || ''''
                        || 'PT' || '''' || ',' || '''' || 'OT' || '''' || ') order by 1' ;