APPS.PER_PERSAIQE_XMLP_PKG SQL Statements

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

Line: 24

      SELECT
        ORG_INFORMATION9
      FROM
        HR_ORGANIZATION_INFORMATION
      WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
        AND ORG_INFORMATION9 is not null
        AND ORG_INFORMATION_CONTEXT = 'Business Group Information';

Line: 45

      SELECT
        CURRENCY_CODE
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;

Line: 80

    SELECT
      NAME
    INTO
      L_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 96

    SELECT
      MEANING
    INTO
      L_UNIT
    FROM
      HR_LOOKUPS
    WHERE LOOKUP_TYPE = 'QUALIFYING_UNITS'
      AND LOOKUP_CODE = P_EXP_UNITS;

Line: 124

          SELECT
            DISTINCT
            POSE.ORGANIZATION_ID_PARENT
          INTO
            L_PARENT_ID
          FROM
            PER_ORG_STRUCTURE_ELEMENTS POSE
          WHERE POSE.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
            AND POSE.ORGANIZATION_ID_PARENT not in (
            SELECT
              POSE1.ORGANIZATION_ID_CHILD
            FROM
              PER_ORG_STRUCTURE_ELEMENTS POSE1
            WHERE POSE1.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID );

Line: 144

        L_ORG_CONDITION := ' and org.organization_id in ' || '(select to_char(pose.organization_id_child) '
	|| 'from per_org_structure_elements pose ' || 'connect by pose.organization_id_parent = '
	|| 'prior pose.organization_id_child ' || 'and pose.org_structure_version_id = ' || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' start with pose.organization_id_parent = ' || TO_CHAR(NVL(P_ORG_ID
                                      ,L_PARENT_ID)) || ' and pose.org_structure_version_id = ' ||
				      TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' union select ' || '''' ||
				      TO_CHAR(NVL(P_ORG_ID
                                      ,L_PARENT_ID)) || '''' || ' from sys.dual) ';

Line: 165

    SELECT
      VERSION_NUMBER
    INTO
      L_NUMBER
    FROM
      PER_ORG_STRUCTURE_VERSIONS
    WHERE ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID;

Line: 181

    SELECT
      NAME
    INTO
      L_NAME
    FROM
      PER_ORGANIZATION_STRUCTURES
    WHERE ORGANIZATION_STRUCTURE_ID = P_ORG_STRUCTURE_ID;