APPS.IGI_IGIIACAR_XMLP_PKG SQL Statements

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

Line: 24

  Select fa.accounting_flex_structure
  into t_account_flex_structure
  From fa_book_controls fa
  Where fa.book_type_code = p_book_type_code;

Line: 38

                 MODE="SELECT"
                 DISPLAY="ALL"
                 NUM=":STRUCT_NUM"
                 TABLEALIAS="GL_ITEM"');*/

Line: 61

      SELECT
        PERIOD_NAME
      INTO CP_PERIOD_FROM
      FROM
        FA_DEPRN_PERIODS
      WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_FROM
        AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 77

      SELECT
        PERIOD_NAME
      INTO CP_PERIOD_TO
      FROM
        FA_DEPRN_PERIODS
      WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_TO
        AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 92

    SELECT
      A.CURRENCY_CODE
    INTO CP_CURR_CODE
    FROM
      GL_SETS_OF_BOOKS A,
      FA_BOOK_CONTROLS B
    WHERE A.SET_OF_BOOKS_ID = B.SET_OF_BOOKS_ID
      AND B.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;