DBA Data[Home] [Help]

APPS.GL_GLXRBUDA_XMLP_PKG SQL Statements

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

Line: 16

      SELECT
        NAME,
        CHART_OF_ACCOUNTS_ID
      INTO ACCESS_SET_NAME,STRUCT_NUM
      FROM
        GL_ACCESS_SETS
      WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;
Line: 39

      SELECT
        NAME
      INTO LEDGER_NAME
      FROM
        GL_LEDGERS
      WHERE LEDGER_ID = P_LEDGER_ID;
Line: 45

      SELECT
        BUDGET_NAME
      INTO BUDGET_NAME
      FROM
        GL_BUDGET_VERSIONS
      WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;