APPS.PSB_PSBRPBRT_XMLP_PKG SQL Statements

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

Line: 55

    SELECT
      B.SET_OF_BOOKS_ID
    INTO VSET_OF_BOOKS_ID
    FROM
      PSB_BUDGET_GROUPS A,
      PSB_BUDGET_GROUPS B
    WHERE A.BUDGET_GROUP_ID = P_BUDGET_GROUP_ID
      AND NVL(A.ROOT_BUDGET_GROUP_ID
       ,A.BUDGET_GROUP_ID) = B.BUDGET_GROUP_ID;

Line: 64

    SELECT
      START_DATE
    INTO INPUT_PERIOD_START_DATE
    FROM
      GL_PERIOD_STATUSES
    WHERE APPLICATION_ID = 101
      AND SET_OF_BOOKS_ID = VSET_OF_BOOKS_ID
      AND PERIOD_NAME = P_START_PERIOD;

Line: 73

    SELECT
      END_DATE
    INTO INPUT_PERIOD_END_DATE
    FROM
      GL_PERIOD_STATUSES
    WHERE APPLICATION_ID = 101
      AND SET_OF_BOOKS_ID = VSET_OF_BOOKS_ID
      AND PERIOD_NAME = P_END_PERIOD;

Line: 82

    SELECT
      SHORT_NAME
    INTO P_BUDGET_GROUP_NAME
    FROM
      PSB_BUDGET_GROUPS
    WHERE BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;

Line: 99

    SELECT
      CHART_OF_ACCOUNTS_ID
    INTO L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_CODE_COMBINATIONS_KFV
    WHERE CODE_COMBINATION_ID = CODE_COMBINATION_ID_1;