APPS.PSP_PSPLDDFA_XMLP_PKG SQL Statements

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

Line: 16

        SELECT
          MIN(DISTRIBUTION_DATE)
        INTO D_PRE_GEN_PERIOD_START
        FROM
          PSP_PRE_GEN_DIST_LINES_HISTORY;

Line: 26

        SELECT
          MIN(DISTRIBUTION_DATE)
        INTO D_DIST_LINES_START
        FROM
          PSP_DISTRIBUTION_LINES_HISTORY;

Line: 55

        SELECT
          MAX(DISTRIBUTION_DATE)
        INTO D_PRE_GEN_PERIOD_END
        FROM
          PSP_PRE_GEN_DIST_LINES_HISTORY;

Line: 65

        SELECT
          MAX(DISTRIBUTION_DATE)
        INTO D_DIST_LINES_END
        FROM
          PSP_DISTRIBUTION_LINES_HISTORY;

Line: 95

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

Line: 117

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

Line: 135

        P_ORGANIZATION_ID := ' and 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: 180

    SELECT
      DISTINCT
      NAME
    INTO V_ORGANIZATION_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = CF_ORGANIZATION_NAMEFORMULA.ORGANIZATION_ID;

Line: 223

        SELECT
          NAME
        INTO L_PROJECT_NAME
        FROM
          PA_PROJECTS_ALL
        WHERE PROJECT_ID = CF_CHARGING_INSTRUCTIONSFORMUL.PROJECT_ID;

Line: 229

        SELECT
          TASK_NUMBER
        INTO L_TASK_NUMBER
        FROM
          PA_TASKS_EXPEND_V  -- Bug : 16391366  (20/03/2013)
        WHERE TASK_ID = CF_CHARGING_INSTRUCTIONSFORMUL.TASK_ID;

Line: 236

          SELECT
            AWARD_NUMBER
          INTO L_AWARD_NUMBER
          FROM
            GMS_AWARDS_ALL
          WHERE AWARD_ID = CF_CHARGING_INSTRUCTIONSFORMUL.AWARD_ID;

Line: 245

        SELECT
          NAME
        INTO L_ORG_NAME
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = CF_CHARGING_INSTRUCTIONSFORMUL.EXPENDITURE_ORGANIZATION_ID;

Line: 268

      SELECT
        DISTINCT
        FULL_NAME
      INTO V_PERSON_NAME
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = CF_PERSON_NAMEFORMULA.PERSON_ID
        AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE );

Line: 278

      SELECT
        DISTINCT
        FULL_NAME
      INTO V_PERSON_NAME
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = CF_PERSON_NAMEFORMULA.PERSON_ID;

Line: 297

      SELECT
        DISTINCT
        ASSIGNMENT_NUMBER
      INTO V_ASSIGNMENT_NUMBER
      FROM
        PER_ASSIGNMENTS_F
      WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
        AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE );

Line: 307

      SELECT
        DISTINCT
        ASSIGNMENT_NUMBER
      INTO V_ASSIGNMENT_NUMBER
      FROM
        PER_ASSIGNMENTS_F
      WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID;

Line: 330

      SELECT
        DISTINCT
        ELEMENT_NAME
      INTO V_ELEMENT_NAME
      FROM
        PAY_ELEMENT_TYPES_F
      WHERE ELEMENT_TYPE_ID = CF_ELEMENT_NAMEFORMULA.ELEMENT_TYPE_ID
        AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE );

Line: 340

      SELECT
        DISTINCT
        ELEMENT_NAME
      INTO V_ELEMENT_NAME
      FROM
        PAY_ELEMENT_TYPES_F
      WHERE ELEMENT_TYPE_ID = CF_ELEMENT_NAMEFORMULA.ELEMENT_TYPE_ID;

Line: 362

    SELECT
      DISTINCT
      PERIOD_NAME
    INTO V_PERIOD_NAME
    FROM
      PER_TIME_PERIODS
    WHERE TIME_PERIOD_ID = CF_PERIOD_NAMEFORMULA.TIME_PERIOD_ID;