APPS.PER_PERRPCTM_XMLP_PKG SQL Statements

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

Line: 7

        SELECT
          BUSINESS_GROUP_ID
        FROM
          PER_ORG_STRUCTURE_VERSIONS
        WHERE ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID;

Line: 13

        SELECT
          BUSINESS_GROUP_ID
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 75

        P_ORG_MATCHING := '  where p.organization_id in ( select organization_id_child from per_org_structure_elements where org_structure_version_id = TO_CHAR(P_ORG_STRUCTURE_VERSION_ID)  union '||
				'select distinct organization_id_parent from per_org_structure_elements  where org_structure_version_id = ' || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ')';

Line: 79

        SELECT
          MEANING
        INTO
          V_LEAV_REASON1
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON1;

Line: 91

        SELECT
          MEANING
        INTO
          V_LEAV_REASON2
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON2;

Line: 103

        SELECT
          MEANING
        INTO
          V_LEAV_REASON3
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON3;

Line: 115

        SELECT
          MEANING
        INTO
          V_LEAV_REASON4
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON4;

Line: 127

        SELECT
          MEANING
        INTO
          V_LEAV_REASON5
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON5;

Line: 139

        SELECT
          MEANING
        INTO
          V_LEAV_REASON6
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON6;