APPS.PA_PAXINGEN_XMLP_PKG SQL Statements

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

Line: 81

      select start_organization_id into p_start_organization_id
      from  pa_implementations;

Line: 88

          /*srw.message(2,'select start_organization_id in before_report' || sqlerrm);*/null;

Line: 97

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

Line: 115

   select substr(full_name, 1, 40) into member_name from
   per_people_f where
   person_id = project_member
      and   sysdate between effective_start_date
      and     nvl(effective_end_date,sysdate + 1)
      and (Current_NPW_Flag='Y' OR Current_Employee_Flag='Y')
      and Decode(Current_NPW_Flag,'Y',NPW_Number,employee_number) IS NOT NULL ;

Line: 135

   select substr(meaning,1,40) into role_type
   from pa_project_role_types where
   project_role_type = PA_PAXINGEN_XMLP_PKG.project_role_type;

Line: 153

  select
    substr(meaning,1,30) into inv_status
  from
    pa_lookups
  where
    lookup_type = 'INVOICE STATUS'
    and lookup_code = invoice_status;

Line: 174

   select
      TO_CHAR(project_closed_after, 'DD-Mon-RRRR') INTO pca_date
   from
      dual ;

Line: 191

   select
      project_status_name into prj_status
   from
      pa_proj_statuses_v
   where
      project_status_code = project_status;

Line: 211

   select segment1,name
   into p_number,p_name
   from pa_projects
   where project_id = PA_PAXINGEN_XMLP_PKG.project_id;

Line: 229

   select substr(meaning,1,30) into disp_details
   from fnd_lookups
   where
   lookup_type = 'YES_NO'
   and lookup_code = display_details;

Line: 248

   select substr(meaning,1,30) into disp_unbilled
   from fnd_lookups
   where
    lookup_type = 'YES_NO'
   and lookup_code = display_unbilled_items;

Line: 273

	select min(p.segment1) into from_project_number
	from pa_projects_all p, pa_project_types_all pt
	where p.project_type = pt.project_type
	and pt.project_type_class_code = 'CONTRACT';

Line: 288

	select max(p.segment1) into to_project_number
	from pa_projects_all p, pa_project_types_all pt
	where p.project_type = pt.project_type
	and pt.project_type_class_code = 'CONTRACT';

Line: 332

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

      select
          decode(p_start_organization_id,null,
          start_organization_id,p_start_organization_id)
          into  C_start_organization_id
      from  pa_implementations;

Line: 383

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

Line: 401

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

Line: 535

  select meaning
  into   l_reason
  from   fnd_lookup_values_vl
  where  lookup_type='CREDIT_MEMO_REASON'
  and    enabled_flag='Y'
  and    lookup_code=credit_memo_reason_code
  and    invoice_date between start_date_active and nvl(end_date_active,invoice_date);