APPS.JL_JLMXFIMP_XMLP_PKG SQL Statements

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

Line: 16

      SELECT
        COMPANY_NAME,
        CATEGORY_FLEX_STRUCTURE
      INTO C_ORGANIZATION_NAME,CAT_FLEX_STRUCT
      FROM
        FA_SYSTEM_CONTROLS;

Line: 28

        SELECT
          FCURR.CURRENCY_CODE,
          FCURR.PRECISION,
          FCURR.MINIMUM_ACCOUNTABLE_UNIT,
          FCURR.DESCRIPTION
        INTO BASE_CURR,PREC,MIN_AU,DESCR
        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: 50

        SELECT
          FCURR.CURRENCY_CODE,
          FCURR.PRECISION,
          FCURR.MINIMUM_ACCOUNTABLE_UNIT,
          FCURR.DESCRIPTION
        INTO BASE_CURR,PREC,MIN_AU,DESCR
        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: 94

    SELECT
      FPI.PRICE_INDEX_ID
    INTO X
    FROM
      FA_PRICE_INDEXES FPI,
      FA_CATEGORY_BOOK_DEFAULTS FCBD
    WHERE FCBD.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
      AND FCBD.CATEGORY_ID = ASSET_CATEGORY
      AND ACQDATE >= FCBD.START_DPIS
      AND ACQDATE <= NVL(FCBD.END_DPIS
       ,ACQDATE)
      AND FCBD.PRICE_INDEX_NAME = FPI.PRICE_INDEX_NAME;

Line: 112

      SELECT
        DESCRIPTION
      INTO CATEGORY_DESC
      FROM
        FA_CATEGORIES
      WHERE CATEGORY_ID = ASSET_CATEGORY;

Line: 142

    SELECT
      PRICE_INDEX_VALUE
    INTO X
    FROM
      FA_PRICE_INDEX_VALUES
    WHERE PRICE_INDEX_ID = C_PRICE_INDEX
      AND JUNE_PERIOD_DATE BETWEEN FROM_DATE
      AND TO_DATE;

Line: 154

      SELECT
        PRICE_INDEX_NAME
      INTO INDEX_NAME
      FROM
        FA_PRICE_INDEXES
      WHERE PRICE_INDEX_ID = C_PRICE_INDEX;

Line: 239

              SELECT
                PERIOD_NUM
              INTO L_RETIREMENT_MONTH
              FROM
                FA_DEPRN_PERIODS_MRC_V
              WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
                AND PERIOD_COUNTER = PERIOD_COUNTER_FULLY_RESERVED;

Line: 249

              SELECT
                PERIOD_NUM
              INTO L_RETIREMENT_MONTH
              FROM
                FA_DEPRN_PERIODS
              WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
                AND PERIOD_COUNTER = PERIOD_COUNTER_FULLY_RESERVED;

Line: 302

        SELECT
          MIN(PERIOD_COUNTER),
          MAX(PERIOD_COUNTER)
        INTO V_MIN_PERIOD_COUNTER,V_MAX_PERIOD_COUNTER
        FROM
          FA_DEPRN_PERIODS_MRC_V
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND FISCAL_YEAR = P_CURR_FY;

Line: 318

        SELECT
          CT.CALENDAR_TYPE,
          CT.NUMBER_PER_FISCAL_YEAR,
          CEIL(CT.NUMBER_PER_FISCAL_YEAR / 2)
        INTO V_CALENDAR_TYPE,V_PERIODS_PER_FY,V_MIDDLE_YEAR
        FROM
          FA_BOOK_CONTROLS_MRC_V BK,
          FA_CALENDAR_TYPES CT
        WHERE BK.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND CT.CALENDAR_TYPE = BK.DEPRN_CALENDAR;

Line: 337

        SELECT
          MIN(PERIOD_COUNTER),
          MAX(PERIOD_COUNTER)
        INTO V_MIN_PERIOD_COUNTER,V_MAX_PERIOD_COUNTER
        FROM
          FA_DEPRN_PERIODS
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND FISCAL_YEAR = P_CURR_FY;

Line: 353

        SELECT
          CT.CALENDAR_TYPE,
          CT.NUMBER_PER_FISCAL_YEAR,
          CEIL(CT.NUMBER_PER_FISCAL_YEAR / 2)
        INTO V_CALENDAR_TYPE,V_PERIODS_PER_FY,V_MIDDLE_YEAR
        FROM
          FA_BOOK_CONTROLS BK,
          FA_CALENDAR_TYPES CT
        WHERE BK.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND CT.CALENDAR_TYPE = BK.DEPRN_CALENDAR;

Line: 373

        SELECT
          FY.START_DATE,
          FY.END_DATE,
          CP.START_DATE,
          CP.END_DATE
        INTO V_START_DATE_FISCAL_YEAR,V_END_DATE_FISCAL_YEAR,V_START_DATE,V_END_DATE
        FROM
          FA_BOOK_CONTROLS_MRC_V BC,
          FA_FISCAL_YEAR FY,
          FA_CALENDAR_PERIODS CP
        WHERE FY.FISCAL_YEAR = P_CURR_FY
          AND BC.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND BC.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
          AND CP.CALENDAR_TYPE = V_CALENDAR_TYPE
          AND CP.START_DATE >= FY.START_DATE
          AND CP.END_DATE <= FY.END_DATE
          AND CP.PERIOD_NUM = V_MIDDLE_YEAR;

Line: 399

        SELECT
          FY.START_DATE,
          FY.END_DATE,
          CP.START_DATE,
          CP.END_DATE
        INTO V_START_DATE_FISCAL_YEAR,V_END_DATE_FISCAL_YEAR,V_START_DATE,V_END_DATE
        FROM
          FA_BOOK_CONTROLS BC,
          FA_FISCAL_YEAR FY,
          FA_CALENDAR_PERIODS CP
        WHERE FY.FISCAL_YEAR = P_CURR_FY
          AND BC.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
          AND BC.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
          AND CP.CALENDAR_TYPE = V_CALENDAR_TYPE
          AND CP.START_DATE >= FY.START_DATE
          AND CP.END_DATE <= FY.END_DATE
          AND CP.PERIOD_NUM = V_MIDDLE_YEAR;

Line: 425

      SELECT
        A.REQUEST_ID
      INTO L_SET_REQUEST_ID
      FROM
        FND_CONCURRENT_REQUESTS A
      WHERE A.PARENT_REQUEST_ID = (
        SELECT
          B.REQUEST_ID
        FROM
          FND_CONCURRENT_REQUESTS B
        WHERE B.PARENT_REQUEST_ID = (
          SELECT
            C.PARENT_REQUEST_ID
          FROM
            FND_CONCURRENT_REQUESTS C
          WHERE C.ROWID <> B.ROWID
            AND C.REQUEST_ID = (
            SELECT
              D.PARENT_REQUEST_ID
            FROM
              FND_CONCURRENT_REQUESTS D
            WHERE D.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID ) ) );

Line: 492

    SELECT
      PRICE_INDEX_VALUE
    INTO X
    FROM
      FA_PRICE_INDEX_VALUES
    WHERE PRICE_INDEX_ID = C_PRICE_INDEX
      AND ACQDATE BETWEEN FROM_DATE
      AND TO_DATE;

Line: 504

      SELECT
        PRICE_INDEX_NAME
      INTO INDEX_NAME
      FROM
        FA_PRICE_INDEXES
      WHERE PRICE_INDEX_ID = C_PRICE_INDEX;

Line: 534

        SELECT
          DATE_RETIRED
        INTO L_FA_RETIREMENT
        FROM
          FA_RETIREMENTS_MRC_V
        WHERE RETIREMENT_ID = RETIREMENT_ID_1;

Line: 541

        SELECT
          DATE_RETIRED
        INTO L_FA_RETIREMENT
        FROM
          FA_RETIREMENTS
        WHERE RETIREMENT_ID = RETIREMENT_ID_1;

Line: 557

    SELECT
      MEANING
    INTO T_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_INCLUDE_DPIS;

Line: 573

    SELECT
      MEANING
    INTO T_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_INCLUDE_RET;

Line: 589

    SELECT
      MEANING
    INTO T_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'JLMX_FA_FULLY_DEPRN_ASSET_OPT'
      AND LOOKUP_CODE = P_FULLY_DEPRN_ASSETS
      AND sysdate between NVL(START_DATE_ACTIVE
       ,SYSDATE - 1)
      AND NVL(END_DATE_ACTIVE
       ,SYSDATE + 1)
      AND ENABLED_FLAG = 'Y';

Line: 610

    SELECT
      MEANING
    INTO T_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_INCLUDE_ZERO_NBV_ASSETS;

Line: 628

        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;

Line: 885

    MODE="SELECT"
    DISPLAY="ALL"');*/