APPS.PSB_PSBRPSBI_XMLP_PKG SQL Statements

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

Line: 18

        SELECT
          NAME
        INTO CP_STANDARD_BUDGET_ITEMS
        FROM
          PSB_STANDARD_BUDGET_ITEMS
        WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;

Line: 24

        SELECT
          SET_OF_BOOKS_ID
        INTO SOB_ID
        FROM
          PSB_STANDARD_BUDGET_ITEM_LINES
        WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;

Line: 30

        SELECT
          NAME
        INTO CP_SET_OF_BOOKS
        FROM
          GL_SETS_OF_BOOKS
        WHERE SET_OF_BOOKS_ID = SOB_ID;

Line: 39

      SELECT
        NAME
      INTO CP_SET_OF_BOOKS
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID1;

Line: 50

        SELECT
          NAME
        INTO CP_STANDARD_BUDGET_ITEMS
        FROM
          PSB_STANDARD_BUDGET_ITEMS
        WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;