APPS.PA_HR_ORG_UTILS SQL Statements

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

Line: 28

        SELECT POSV1.org_structure_version_id
        INTO x_org_hierarchy_version_id
        FROM per_org_structure_versions POSV1
        WHERE POSV1.org_structure_version_id
	     = p_org_hierarchy_version_id;

Line: 37

      SELECT POSV1.org_structure_version_id
        INTO x_org_hierarchy_version_id
        FROM per_organization_structures POS,
	     per_org_structure_versions POSV1
        WHERE POS.name = p_org_hierarchy_name
	AND   POS.organization_structure_id =
	      POSV1.organization_structure_id;

Line: 75

	  SELECT organization_id
          FROM hr_organization_units
          WHERE name  = p_organization_name;

Line: 81

          SELECT organization_id
          INTO x_organization_id
          FROM hr_all_organization_units -- Bug 4358448 perf change
          WHERE organization_id = p_organization_id;

Line: 128

          SELECT organization_id
          INTO x_organization_id
          FROM hr_organization_units
          WHERE name  = p_organization_name;