APPS.PSB_PSBRPERR_XMLP_PKG SQL Statements

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

Line: 21

      SELECT
        PROCESS_ID,
        SOURCE_PROCESS,
        SOURCE_PROCESS_MEANING,
        PROCESS_NAME
      INTO L_PROCESS_ID,P_SOURCE_PROCESS,L_SOURCE_PROCESS,L_PROCESS_NAME
      FROM
        PSB_ERROR_REQUESTS_V
      WHERE CONCURRENT_REQUEST_ID = P_CONC_ID;

Line: 35

        SELECT
          NAME,
          SHORT_NAME
        INTO CP_PROCESS_ID,CP_NAME
        FROM
          PSB_BUDGET_GROUPS
        WHERE BUDGET_GROUP_ID = L_PROCESS_ID;

Line: 45

      SELECT
        MAX(CONCURRENT_REQUEST_ID)
      INTO L_MAX_CONC_ID
      FROM
        PSB_ERROR_MESSAGES
      WHERE PROCESS_ID = P_PROCESS_ID
        AND SOURCE_PROCESS = P_SOURCE_PROCESS
      GROUP BY
        PROCESS_ID,
        SOURCE_PROCESS;

Line: 59

      SELECT
        DISTINCT
        SOURCE_PROCESS_MEANING,
        PROCESS_NAME
      INTO L_SOURCE_PROCESS,L_PROCESS_NAME
      FROM
        PSB_ERROR_REQUESTS_V
      WHERE PROCESS_ID = P_PROCESS_ID
        AND SOURCE_PROCESS = P_SOURCE_PROCESS;

Line: 72

        SELECT
          NAME,
          SHORT_NAME
        INTO CP_PROCESS_ID,CP_NAME
        FROM
          PSB_BUDGET_GROUPS
        WHERE BUDGET_GROUP_ID = P_PROCESS_ID;

Line: 83

        SELECT
          PROCESS_ID,
          PROCESS_NAME
        INTO L_PROCESS_ID,L_PROCESS_NAME
        FROM
          PSB_ERROR_REQUESTS_V
        WHERE CONCURRENT_REQUEST_ID = P_CONC_ID;

Line: 92

        SELECT
          - 1
        INTO L_MAX_CONC_ID
        FROM
          DUAL;

Line: 107

        SELECT
          NAME,
          SHORT_NAME
        INTO CP_PROCESS_ID,CP_NAME
        FROM
          PSB_BUDGET_GROUPS
        WHERE BUDGET_GROUP_ID = L_PROCESS_ID;