APPS.PSP_PSPLDAWD_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 = P_TEMPLATE_ID
        AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
        AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;

Line: 23

        P_AWARD_ID := ' and a.award_id  IN (select criteria_value1 from psp_report_template_details
                               where template_id = ' || P_AWD_TEMPLATE_ID || '
                               and   criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
                               and   criteria_lookup_code = ''AWD'' ' || ' ) ';

Line: 58

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

Line: 112

    SELECT
      AWARD_NUMBER
    INTO V_AWARD_NAME
    FROM
      GMS_AWARDS_ALL
    WHERE AWARD_ID = CF_AWARD_NAMEFORMULA.AWARD_ID;

Line: 128

    SELECT
      FULL_NAME
    INTO V_PERSON_NAME
    FROM
      PER_ALL_PEOPLE_F
    WHERE PERSON_ID = CF_EMPLOYEE_NAMEFORMULA.PERSON_ID
      AND ( P_END_DATE Between EFFECTIVE_START_DATE
      AND EFFECTIVE_END_DATE );

Line: 149

    SELECT
      ASSIGNMENT_NUMBER
    INTO V_ASSIGNMENT_NUMBER
    FROM
      PER_ASSIGNMENTS_F
    WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
      AND PERSON_ID = CF_ASSIGNMENT_NUMBERFORMULA.PERSON_ID
      AND ( P_END_DATE BETWEEN EFFECTIVE_START_DATE
      AND EFFECTIVE_END_DATE )
      AND PERIOD_OF_SERVICE_ID IS NOT NULL;

Line: 169

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

Line: 187

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

Line: 238

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

Line: 245

      SELECT
        NAME
      INTO L_EXP_ORG
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID
        AND ROWNUM = 1;

Line: 256

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

      SELECT
        SEGMENT1
      INTO L_PROJECT_NUMBER
      FROM
        PA_PROJECTS_ALL
      WHERE PROJECT_ID = cf_charging_instructionsformul.PROJECT_ID;