APPS.JL_JLARFEFR_XMLP_PKG SQL Statements

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

Line: 16

      SELECT
        DISTRIBUTION_SOURCE_BOOK
      INTO P_CORP_BOOK
      FROM
        FA_BOOK_CONTROLS_MRC_V
      WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 22

      SELECT
        PERIOD_NAME
      INTO C_PERIOD_FROM
      FROM
        FA_DEPRN_PERIODS_MRC_V
      WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_FROM
        AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 29

      SELECT
        PERIOD_NAME
      INTO C_PERIOD_TO
      FROM
        FA_DEPRN_PERIODS_MRC_V
      WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_TO
        AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 41

        SELECT
          'Y'
        INTO L_FLAG
        FROM
          FA_DEPRN_PERIODS_MRC_V
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND PERIOD_COUNTER = P_PERIOD_COUNTER_TO
          AND PERIOD_CLOSE_DATE is not null;

Line: 71

      SELECT
        DISTRIBUTION_SOURCE_BOOK
      INTO P_CORP_BOOK
      FROM
        FA_BOOK_CONTROLS
      WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 77

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

Line: 84

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

Line: 96

        SELECT
          'Y'
        INTO L_FLAG
        FROM
          FA_DEPRN_PERIODS
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND PERIOD_COUNTER = P_PERIOD_COUNTER_TO
          AND PERIOD_CLOSE_DATE is not null;

Line: 150

        SELECT
          FCURR.CURRENCY_CODE,
          FCURR.PRECISION,
          FCURR.MINIMUM_ACCOUNTABLE_UNIT,
          FCURR.DESCRIPTION,
          GSBKS.NAME
        INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
        FROM
          FA_BOOK_CONTROLS_MRC_V BKCTRL,
          FND_CURRENCIES_VL FCURR,
          GL_SETS_OF_BOOKS GSBKS
        WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
          AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line: 173

        SELECT
          FCURR.CURRENCY_CODE,
          FCURR.PRECISION,
          FCURR.MINIMUM_ACCOUNTABLE_UNIT,
          FCURR.DESCRIPTION,
          GSBKS.NAME
        INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
        FROM
          FA_BOOK_CONTROLS BKCTRL,
          FND_CURRENCIES_VL FCURR,
          GL_SETS_OF_BOOKS GSBKS
        WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
          AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line: 243

        SELECT
          MRC_SOB_TYPE_CODE,
          CURRENCY_CODE
        INTO P_MRCSOBTYPE,LP_CURRENCY_CODE
        FROM
          GL_SETS_OF_BOOKS
        WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;