APPS.PSP_PSPLSODL_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      DISTINCT
      NAME
    INTO V_ORGANIZATION_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = ORGANIZATION_ID_v;

Line: 38

    SELECT
      DISTINCT
      PROJECT_NUMBER
    INTO V_PROJECT_NAME
    FROM
      GMS_PROJECTS_EXPEND_V
    WHERE PROJECT_ID = PROJECT_ID_V;

Line: 58

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

Line: 80

    SELECT
      DISTINCT
      TASK_NUMBER
    INTO V_TASK_NAME
    FROM
      PA_TASKS_EXPEND_V
    WHERE PROJECT_ID = PROJECT_ID_V
      AND TASK_ID = TASK_ID_V;

Line: 102

      SELECT
        DISTINCT
        AWARD_NUMBER
      INTO V_AWARD_NAME
      FROM
        GMS_AWARDS_ALL
      WHERE AWARD_ID = AWARD_ID_V;

Line: 111

        SELECT
          DEFAULT_DIST_AWARD_NUMBER
        INTO V_AWARD_NAME
        FROM
          GMS_IMPLEMENTATIONS
        WHERE DEFAULT_DIST_AWARD_ID = AWARD_ID_V
          AND AWARD_DISTRIBUTION_OPTION = 'Y';

Line: 129

    SELECT
      DISTINCT
      ASSIGNMENT_NUMBER
    INTO V_ASSIGNMENT_NUMBER
    FROM
      PER_ASSIGNMENTS_F
    WHERE ASSIGNMENT_ID = ASSIGNMENT_ID_V
      AND ASSIGNMENT_TYPE = 'E'
      AND PERSON_ID = PERSON_ID_V;

Line: 152

      SELECT
        DISTINCT
        FULL_NAME
      INTO V_EMPLOYEE_NAME
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = PERSON_ID_V
        AND ( V_TIME_PERIOD_END Between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE );

Line: 162

      SELECT
        DISTINCT
        FULL_NAME
      INTO V_EMPLOYEE_NAME
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = PERSON_ID_V;

Line: 184

    SELECT
      DISTINCT
      ELEMENT_NAME
    INTO V_EARNINGS_ELEMENT
    FROM
      PAY_ELEMENT_TYPES_F
    WHERE ELEMENT_TYPE_ID = ELEMENT_TYPE_ID_V;

Line: 218

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

Line: 228

      SELECT
        DISTINCT
        EMPLOYEE_NUMBER
      INTO V_EMPLOYEE_NUMBER
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = PERSON_ID_V;

Line: 296

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

Line: 319

    RET_VAL := PSP_ORG_DLS_PKG.INSERT_RECORDS_TO_TABLE(P_ORG_TEMPLATE_ID
                                                      ,P_BEGIN_DATE
                                                      ,P_END_DATE
                                                      ,P_SET_OF_BOOKS_ID
                                                      ,P_BUSINESS_GROUP_ID);