The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
COMPANY_NAME,
CATEGORY_FLEX_STRUCTURE
INTO C_ORGANIZATION_NAME,CAT_FLEX_STRUCT
FROM
FA_SYSTEM_CONTROLS;
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;
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;
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;
SELECT
DESCRIPTION
INTO CATEGORY_DESC
FROM
FA_CATEGORIES
WHERE CATEGORY_ID = ASSET_CATEGORY;
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;
SELECT
PRICE_INDEX_NAME
INTO INDEX_NAME
FROM
FA_PRICE_INDEXES
WHERE PRICE_INDEX_ID = C_PRICE_INDEX;
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;
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;
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;
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;
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;
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;
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;
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;
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 ) ) );
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;
SELECT
PRICE_INDEX_NAME
INTO INDEX_NAME
FROM
FA_PRICE_INDEXES
WHERE PRICE_INDEX_ID = C_PRICE_INDEX;
SELECT
DATE_RETIRED
INTO L_FA_RETIREMENT
FROM
FA_RETIREMENTS_MRC_V
WHERE RETIREMENT_ID = RETIREMENT_ID_1;
SELECT
DATE_RETIRED
INTO L_FA_RETIREMENT
FROM
FA_RETIREMENTS
WHERE RETIREMENT_ID = RETIREMENT_ID_1;
SELECT
MEANING
INTO T_MEANING
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = P_INCLUDE_DPIS;
SELECT
MEANING
INTO T_MEANING
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = P_INCLUDE_RET;
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';
SELECT
MEANING
INTO T_MEANING
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = P_INCLUDE_ZERO_NBV_ASSETS;
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;
MODE="SELECT"
DISPLAY="ALL"');*/