The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nvl(max(lu.meaning), 'No Report Title in FND_LOOKUPS.MEANING for lookup_type JGZZ_JGSTRGRH_TITLE')
into
RP_REPORT_NAME
from
fnd_lookups lu
where
lu.lookup_type = 'JGZZ_JGSTRGRH_TITLE' and
lu.lookup_code = 'LEDGER';
SELECT
SC.COMPANY_NAME,
BC.SET_OF_BOOKS_ID,
SOB.NAME SOB_NAME,
SOB.Currency_Code,
CUR.Precision,
SC.ASSET_KEY_FLEX_STRUCTURE,
BC.Accounting_Flex_Structure
INTO
RP_COMPANY_NAME,
RP_SOB_ID,
RP_SOB_NAME,
RP_CURRENCY_CODE,
RP_PRECISION,
asset_key_flex_struct,
acct_flex_structure
FROM
FA_SYSTEM_CONTROLS SC,
FA_BOOK_CONTROLS BC,
GL_LEDGERS_PUBLIC_V SOB,
FND_CURRENCIES CUR
WHERE
BC.Book_Type_Code = nvl(P_BOOK_TYPE_CODE, bc.book_type_code)
AND SOB.Ledger_ID = BC.Set_Of_Books_ID
AND CUR.Currency_Code = SOB.Currency_Code
AND rownum = 1;