APPS.PER_PERRPRTM_XMLP_PKG SQL Statements

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

Line: 9

        SELECT
          DECODE(VIEW_ALL_ORGANIZATIONS_FLAG
                ,'Y'
                ,1
                ,0)
        FROM
          PER_SECURITY_PROFILES
        WHERE SECURITY_PROFILE_ID = L_PFID;

Line: 18

        SELECT
          BUSINESS_GROUP_ID
        FROM
          PER_ORG_STRUCTURE_VERSIONS
        WHERE ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID;

Line: 24

        SELECT
          BUSINESS_GROUP_ID
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 90

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

          P_ORG_MATCHING := '  where p.organization_id in ( select HOI.organization_id ' || 'from hr_organization_units hou ,  hr_organization_information hoi ' || 'where hou.business_group_id= ' || P_BUSINESS_GROUP_ID ||
	  ' and hou.organization_id=hoi.organization_id  and hoi.ORG_INFORMATION1 = ''HR_ORG'' ) ';

Line: 105

          P_ORG_MATCHING := '  where p.organization_id in ( select organization_id ' || 'FROM PER_ORGANIZATION_LIST WHERE SECURITY_PROFILE_ID =' || L_PROFILE_ID || ')';

Line: 109

        SELECT
          SUBSTR(MEANING
                ,1
                ,30),
          MEANING
        INTO V_LEAV_REASON1,V_LEAV_RDESC1
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON1;

Line: 123

        SELECT
          SUBSTR(MEANING
                ,1
                ,30),
          MEANING
        INTO V_LEAV_REASON2,V_LEAV_RDESC2
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON2;

Line: 137

        SELECT
          SUBSTR(MEANING
                ,1
                ,30),
          MEANING
        INTO V_LEAV_REASON3,V_LEAV_RDESC3
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON3;

Line: 151

        SELECT
          SUBSTR(MEANING
                ,1
                ,30),
          MEANING
        INTO V_LEAV_REASON4,V_LEAV_RDESC4
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON4;

Line: 165

        SELECT
          SUBSTR(MEANING
                ,1
                ,30),
          MEANING
        INTO V_LEAV_REASON5,V_LEAV_RDESC5
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON5;

Line: 179

        SELECT
          SUBSTR(MEANING
                ,1
                ,30),
          MEANING
        INTO V_LEAV_REASON6,V_LEAV_RDESC6
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
          AND LOOKUP_CODE = P_LEAV_REASON6;