The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
count(*)
INTO EAM_ORG_COUNT
FROM
MTL_PARAMETERS
WHERE ORGANIZATION_ID = P_ORG_ID
AND EAM_ENABLED_FLAG = 'Y';
SELECT
OAP1.PERIOD_START_DATE,
OAP2.SCHEDULE_CLOSE_DATE
INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
FROM
ORG_ACCT_PERIODS OAP1,
ORG_ACCT_PERIODS OAP2
WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
AND OAP2.ORGANIZATION_ID = P_ORG_ID
AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;
SELECT
OOD.ORGANIZATION_NAME,
SOB.CURRENCY_CODE
INTO P_ORG_NAME,L_CURRENCY
FROM
CST_ORGANIZATION_DEFINITIONS OOD,
GL_SETS_OF_BOOKS SOB
WHERE OOD.ORGANIZATION_ID = P_ORG_ID
AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID;
SELECT
NVL(MINIMUM_ACCOUNTABLE_UNIT
,POWER(10
,NVL(-PRECISION
,0)))
INTO P_ROUND_UNIT
FROM
FND_CURRENCIES
WHERE CURRENCY_CODE = P_CURRENCY_CODE;