APPS.PSB_PSBRPFLX_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        BUDGET_YEAR_TYPE_ID,
        SEQUENCE_NUMBER
      FROM
        PSB_BUDGET_YEAR_TYPES
      WHERE YEAR_CATEGORY_TYPE = 'PP'
      ORDER BY
        SEQUENCE_NUMBER ASC;

Line: 17

      SELECT
        NAME,
        BUDGET_YEAR_TYPE_ID
      FROM
        PSB_BUDGET_YEAR_TYPES
      WHERE YEAR_CATEGORY_TYPE = 'CY';

Line: 31

      SELECT
        NAME,
        FLEX_MAPPING_SET_ID
      INTO CP_PARAM_WS_NAME,CP_FLEX_MAPPING_SET_ID
      FROM
        PSB_WORKSHEETS
      WHERE WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID;

Line: 43

    SELECT
      count(*)
    INTO L_PP_CAL_COUNT
    FROM
      PSB_BUDGET_PERIODS
    WHERE BUDGET_CALENDAR_ID = 1
      AND BUDGET_PERIOD_TYPE = 'Y';

Line: 50

    SELECT
      LEAST(L_PP_CAL_COUNT
           ,GREATEST(NVL(BG.NUM_PROPOSED_YEARS
                       ,0)
                   ,NVL(WS.NUM_PROPOSED_YEARS
                      ,0)))
    INTO L_NUM_PROPOSED_YEARS
    FROM
      PSB_BUDGET_GROUPS BG,
      PSB_WORKSHEETS WS
    WHERE BG.BUDGET_GROUP_ID = WS.BUDGET_GROUP_ID
      AND WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID;