APPS.PSB_PSBRPCON_XMLP_PKG SQL Statements

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

Line: 18

        SELECT
          SHORT_NAME
        INTO CP_BGP
        FROM
          PSB_BUDGET_GROUPS
        WHERE BUDGET_GROUP_ID = P_BGP_ID;

Line: 26

      SELECT
        NAME
      INTO CP_SOB
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 37

        SELECT
          SHORT_NAME
        INTO CP_BGP
        FROM
          PSB_BUDGET_GROUPS
        WHERE BUDGET_GROUP_ID = P_BGP_ID;

Line: 50

      SELECT
        NAME
      INTO CP_SET
      FROM
        PSB_CONSTRAINT_SETS_V
      WHERE CONSTRAINT_SET_ID = P_SET_ID;

Line: 56

      SELECT
        SET_OF_BOOKS_ID,
        BUDGET_GROUP_ID
      INTO SOB_ID,BGP_ID
      FROM
        PSB_CONSTRAINT_SETS_V
      WHERE CONSTRAINT_SET_ID = P_SET_ID;

Line: 63

      SELECT
        SHORT_NAME
      INTO CP_BGP
      FROM
        PSB_BUDGET_GROUPS
      WHERE BUDGET_GROUP_ID = BGP_ID;

Line: 69

      SELECT
        NAME
      INTO CP_SOB
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = SOB_ID;