APPS.PSB_PSBRPVPR_XMLP_PKG SQL Statements

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

Line: 20

      SELECT
        NAME
      INTO CP_WORKSHEET_NAME
      FROM
        PSB_WORKSHEETS
      WHERE WORKSHEET_ID = P_WORKSHEET_ID;

Line: 26

      SELECT
        NAME
      INTO CP_YEAR_NAME
      FROM
        PSB_BUDGET_PERIODS
      WHERE BUDGET_PERIOD_ID = P_BUDGET_YEAR_ID;

Line: 54

                                         ,P_SELECT_DATE => NULL);

Line: 56

      SELECT
        DATA_EXTRACT_NAME
      INTO CP_EXTRACT_NAME
      FROM
        PSB_DATA_EXTRACTS
      WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;

Line: 90

    SELECT
      TOPBG.CURRENCY_CODE
    INTO CP_CURRENCY_CODE
    FROM
      PSB_BUDGET_GROUPS_V TOPBG,
      PSB_BUDGET_GROUPS_V REGBG
    WHERE REGBG.BUDGET_GROUP_ID = BUDGET_GROUP_ID_1
      AND DECODE(REGBG.ROOT_BUDGET_GROUP_ID
          ,NULL
          ,REGBG.BUDGET_GROUP_ID
          ,REGBG.ROOT_BUDGET_GROUP_ID) = TOPBG.BUDGET_GROUP_ID;