APPS.PA_PAXRWDOH_XMLP_PKG SQL Statements

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

Line: 7

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

    select substr(name,1,60) into Org_Name from        hr_organization_units
    where organization_id = START_ORG_ID;

Line: 43

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

Line: 52

	select meaning into p_select_column
	  From pa_lookups
	 where lookup_code = 'PA_REPORTING_ORG' and lookup_type='ALL_HIERARCHY_CLASS';

Line: 61

   P_select_column1 := 'pi.org_structure_version_id';

Line: 65

	select start_organization_id into start_org_id from pa_implementations;

Line: 69

	select meaning into p_select_column
	  From pa_lookups
	 where lookup_code = 'PA_EXPENDITURE_ORG' and lookup_type='ALL_HIERARCHY_CLASS';

Line: 78

P_select_column1 := 'pi.exp_org_structure_version_id';

Line: 82

	select exp_start_org_id into start_org_id from pa_implementations;

Line: 87

	select meaning into p_select_column
	  From pa_lookups
	 where lookup_code = 'PA_PROJECT_ORG' and lookup_type='ALL_HIERARCHY_CLASS';

Line: 97

   P_select_column1 := 'pi.proj_org_structure_version_id';

Line: 101

	select proj_start_org_id into start_org_id from pa_implementations;

Line: 112

   P_select_column1 := 'p.organization_id_parent';

Line: 115

select meaning  into p_select_column
	  From pa_lookups
	 where lookup_code = 'PA_BURDENING_ORG' and lookup_type='ALL_HIERARCHY_CLASS';

Line: 122

select distinct organization_id_parent into start_org_id
from per_org_structure_elements a
     ,pa_implementations b
     ,hr_organization_information c
where organization_id_parent not in
( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d
   where d.org_structure_version_id = to_number(c.org_information2)
)
and a.org_structure_version_id = to_number(c.org_information2)
and b.business_group_id = c.organization_id
and c.org_information_context = 'Project Burdening Hierarchy' ;