APPS.PSB_PSBRPWAC_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        NAME
      FROM
        PSB_BUDGET_PERIODS
      WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID1;

Line: 11

      SELECT
        NAME
      FROM
        PSB_BUDGET_PERIODS
      WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID2;

Line: 17

      SELECT
        NAME
      FROM
        PSB_BUDGET_PERIODS
      WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID3;

Line: 23

      SELECT
        NAME
      FROM
        PSB_BUDGET_PERIODS
      WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID4;

Line: 62

      SELECT
        NAME
      INTO CP_PARAM_SP_NAME
      FROM
        PSB_SERVICE_PACKAGES
      WHERE SERVICE_PACKAGE_ID = P_SERVICE_PACKAGE_ID;

Line: 71

      SELECT
        NAME,
        SEQUENCE_NUMBER
      INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
      FROM
        PSB_BUDGET_STAGES
      WHERE BUDGET_STAGE_ID = P_STAGE_ID;

Line: 79

      SELECT
        ST.NAME,
        ST.SEQUENCE_NUMBER
      INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
      FROM
        PSB_BUDGET_STAGES ST,
        PSB_WORKSHEETS WS
      WHERE WS.WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID
        AND ST.BUDGET_STAGE_SET_ID = WS.STAGE_SET_ID
        AND ST.SEQUENCE_NUMBER = WS.CURRENT_STAGE_SEQ;

Line: 96

      SELECT
        NAME,
        BUDGET_CALENDAR_ID
      INTO CP_PARAM_WS_NAME,L_CALENDAR_ID
      FROM
        PSB_WORKSHEETS
      WHERE WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID;

Line: 104

      /*SELECT
        BUDGET_YEAR_TYPE_ID
      INTO CP_CY_PERIOD_ID
      FROM
        PSB_BUDGET_PERIODS
      WHERE BUDGET_CALENDAR_ID = L_CALENDAR_ID
        AND BUDGET_PERIOD_TYPE = 'Y';*/

Line: 155

  FUNCTION SELECT_AMT_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_AMT;

Line: 158

  END SELECT_AMT_P;