APPS.PSP_PSPLDORG_XMLP_PKG SQL Statements

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

Line: 5

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

        P_ORG_ID := '  paf.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'' ' || ' ) ';

Line: 46

      SELECT
        END_DATE
      INTO V_OGM_PERIOD_END
      FROM
        PA_PERIODS
      WHERE PERIOD_NAME = P_OGM_PERIOD;

Line: 52

      SELECT
        DISTINCT
        EMPLOYEE_NUMBER
      INTO V_EMPLOYEE_NUMBER
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = PERSON_ID1
        AND ( V_OGM_PERIOD_END Between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE );

Line: 62

      SELECT
        EMPLOYEE_NUMBER
      INTO V_EMPLOYEE_NUMBER
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = PERSON_ID1
        AND TRUNC(EFFECTIVE_DATE) BETWEEN EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE;

Line: 99

    SELECT
      NAME
    INTO V_INSTITUTION_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);