The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
INTO L_AVG_ORG_COUNT
FROM MTL_PARAMETERS
WHERE ORGANIZATION_ID = P_ORG_ID
AND PRIMARY_COST_METHOD IN ( 2 , 5 , 6 );
SELECT
OOD.ORGANIZATION_NAME,
SOB.CURRENCY_CODE,
FC.PRECISION,
MCS.CATEGORY_SET_NAME,
LOOKUP1.MEANING,
STYPE1.TRANSACTION_SOURCE_TYPE_NAME,
STYPE2.TRANSACTION_SOURCE_TYPE_NAME,
STYPE3.TRANSACTION_SOURCE_TYPE_NAME,
STYPE4.TRANSACTION_SOURCE_TYPE_NAME
INTO PV_ORGANIZATION_NAME,PV_CURRENCY_CODE,PV_STD_PREC,PV_CATEGORY_SET_NAME,PV_SORT_OPTION,PV_STYPE1,PV_STYPE2,PV_STYPE3,PV_STYPE4
FROM
ORG_ORGANIZATION_DEFINITIONS OOD,
GL_SETS_OF_BOOKS SOB,
FND_CURRENCIES FC,
MTL_CATEGORY_SETS MCS,
MFG_LOOKUPS LOOKUP1,
MTL_TXN_SOURCE_TYPES STYPE1,
MTL_TXN_SOURCE_TYPES STYPE2,
MTL_TXN_SOURCE_TYPES STYPE3,
MTL_TXN_SOURCE_TYPES STYPE4
WHERE OOD.ORGANIZATION_ID = P_ORG_ID
AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND FC.CURRENCY_CODE = SOB.CURRENCY_CODE
AND MCS.CATEGORY_SET_ID = P_CAT_SET_ID
AND LOOKUP1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
AND LOOKUP1.LOOKUP_CODE = P_SORT_OPTION
AND STYPE1.TRANSACTION_SOURCE_TYPE_ID = P_STYPE1
AND STYPE2.TRANSACTION_SOURCE_TYPE_ID = P_STYPE2
AND STYPE3.TRANSACTION_SOURCE_TYPE_ID = P_STYPE3
AND STYPE4.TRANSACTION_SOURCE_TYPE_ID = P_STYPE4;