APPS.PSP_PSPENCDU_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        TASK_NUMBER
      INTO V_TASK_NUMBER
      FROM
        PA_TASKS_EXPEND_V
      WHERE PROJECT_ID = CF_TASK_NAMEFORMULA.PROJECT_ID
        AND TASK_ID = CF_TASK_NAMEFORMULA.TASK_ID;

Line: 31

      SELECT
        DISTINCT
        AWARD_NUMBER
      INTO V_AWARD_NUMBER
      FROM
        GMS_AWARDS_BASIC_V
      WHERE AWARD_ID = CF_AWARD_NUMBERFORMULA.AWARD_ID;

Line: 54

      SELECT
        PROJECT_NUMBER
      INTO V_PROJECT_NUMBER
      FROM
        GMS_PROJECTS_EXPEND_V
      WHERE PROJECT_ID = CF_PROJECT_NUMBERFORMULA.PROJECT_ID;

Line: 76

      SELECT
        NAME
      INTO V_ORG_NAME
      FROM
        PA_ORGANIZATIONS_EXPEND_V
      WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID
        AND ACTIVE_FLAG = 'Y';

Line: 117

    SELECT
      PAF1.EMPLOYEE_NUMBER
    INTO V_EMPLOYEE_NUMBER
    FROM
      PER_ALL_PEOPLE_F PAF1
    WHERE PERSON_ID = CF_EMPLOYEE_NUMBERFORMULA.PERSON_ID
      AND EFFECTIVE_START_DATE = (
      SELECT
        MIN(EFFECTIVE_START_DATE)
      FROM
        PER_ALL_PEOPLE_F PAF2
      WHERE PAF1.PERSON_ID = PAF2.PERSON_ID
        AND PAF2.CURRENT_EMPLOYEE_FLAG = 'Y' );

Line: 212

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

        P_ORGANIZATIONS := ' and b.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: 247

        P_PAYROLL_ID := ' and a.payroll_id IN (select criteria_value1 from psp_report_template_details
                                where template_id = ' || P_PAY_TEMPLATE_ID || '
                                and   criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
                                and   criteria_lookup_code = ''PAY'' ' || ' ) ';