APPS.PSP_PSPLSEMP_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        NAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = ORGANIZATION_ID_V;

Line: 27

      SELECT
        FULL_NAME
      FROM
        PER_PEOPLE_F PPF1
      WHERE PPF1.PERSON_ID = PERSON_ID_V
        AND PPF1.CURRENT_EMPLOYEE_FLAG = 'Y'
        AND ( TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE
      OR TRUNC(SYSDATE) < (
        SELECT
          MIN(PPF2.EFFECTIVE_START_DATE)
        FROM
          PER_PEOPLE_F PPF2
        WHERE PPF2.PERSON_ID = PPF1.PERSON_ID
          AND PPF2.CURRENT_EMPLOYEE_FLAG = 'Y' ) );

Line: 71

      SELECT
        SEGMENT1
      FROM
        PA_PROJECTS_ALL
      WHERE PROJECT_ID = PROJECT_ID_V;

Line: 93

      SELECT
        TASK_NUMBER
      FROM
        PA_TASKS_EXPEND_V 		-- Bug : 16391366  (20/03/2013)
      WHERE TASK_ID = TASK_ID_V;

Line: 115

      SELECT
        AWARD_NUMBER
      FROM
        GMS_AWARDS_ALL
      WHERE AWARD_ID = AWARD_ID_V;

Line: 129

          SELECT
            DEFAULT_DIST_AWARD_NUMBER
          INTO L_AWARD_NUMBER
          FROM
            GMS_IMPLEMENTATIONS
          WHERE DEFAULT_DIST_AWARD_ID = AWARD_ID_V
            AND AWARD_DISTRIBUTION_OPTION = 'Y';

Line: 151

      SELECT
        NAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;

Line: 174

      SELECT
        ASSIGNMENT_NUMBER
      FROM
        PER_ASSIGNMENTS_F PAF
      WHERE PAF.ASSIGNMENT_ID = TYPE
        AND PAF.ASSIGNMENT_TYPE = 'E'
        AND ROWNUM = 1;

Line: 182

      SELECT
        ELEMENT_GROUP_NAME
      FROM
        PSP_ELEMENT_GROUPS PEG
      WHERE PEG.ELEMENT_GROUP_ID = TYPE
        AND ROWNUM = 1;

Line: 189

      SELECT
        ELEMENT_NAME
      FROM
        PAY_ELEMENT_TYPES_F PET
      WHERE PET.ELEMENT_TYPE_ID = TYPE
        AND ROWNUM = 1;

Line: 232

      SELECT
        COUNT(1)
      FROM
        PSP_REPORT_TEMPLATE_DETAILS
      WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
        AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
        AND CRITERIA_LOOKUP_CODE = 'ORG';

Line: 240

      SELECT
        CRITERIA_VALUE1
      FROM
        PSP_REPORT_TEMPLATE_DETAILS
      WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
        AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
        AND CRITERIA_LOOKUP_CODE = 'ORG';

Line: 295

      SELECT
        COUNT(1)
      FROM
        PSP_REPORT_TEMPLATE_DETAILS
      WHERE TEMPLATE_ID = L_TEMPLATE_ID
        AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
        AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;

Line: 312

        P_ORGANIZATION_ID := '  hou.organization_id  IN (select criteria_value1 from psp_report_template_details
                                    where template_id = ' || P_ORG_TEMPLATE_ID || '
                                    and   criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
                                    and   criteria_lookup_code = ''ORG'' ' || ' ) ';