The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
DISTRIBUTION_SOURCE_BOOK
INTO P_CORP_BOOK
FROM
FA_BOOK_CONTROLS_MRC_V
WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
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;
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;
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;
SELECT
DISTRIBUTION_SOURCE_BOOK
INTO P_CORP_BOOK
FROM
FA_BOOK_CONTROLS
WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
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;
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;
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;
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;
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;
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;