APPS.PSP_PSPENCSC_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      NAME
    INTO V_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = (
      SELECT
        ORGANIZATION_ID
      FROM
        PSP_ORGANIZATION_ACCOUNTS
      WHERE ORGANIZATION_ACCOUNT_ID = SUSPENSE_ORG_ACCOUNT_ID );

Line: 33

      SELECT
        TASK_NUMBER
      INTO V_TASK_NUMBER
      FROM
        PA_TASKS_EXPEND_V
      WHERE PROJECT_ID = PROJECT_ID1
        AND TASK_ID = TASK_ID1;

Line: 56

      SELECT
        DISTINCT
        AWARD_NUMBER
      INTO V_AWARD_NUMBER
      FROM
        GMS_AWARDS_BASIC_V
      WHERE AWARD_ID = AWARD_ID1;

Line: 79

      SELECT
        PROJECT_NUMBER
      INTO V_PROJECT_NUMBER
      FROM
        GMS_PROJECTS_EXPEND_V
      WHERE PROJECT_ID = PROJECT_ID1;

Line: 101

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

Line: 142

    SELECT
      PAF1.EMPLOYEE_NUMBER
    INTO V_EMPLOYEE_NUMBER
    FROM
      PER_ALL_PEOPLE_F PAF1
    WHERE PERSON_ID = PERSON_ID1
      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: 237

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

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

        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'' ' || ' ) ';