The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
BASE_CURRENCY_CODE
INTO BCURR
FROM
GMF_FISCAL_POLICIES
WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
SELECT
BASE_CURRENCY_CODE
INTO L_BASE_CURRENCY_CODE
FROM
GMF_FISCAL_POLICIES
WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
SELECT
PERIOD_ID
INTO L_PERIOD_ID
FROM
GMF_PERIOD_STATUSES
WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
AND CALENDAR_CODE = P_CALENDAR
AND PERIOD_CODE = P_PERIOD_CODE
AND COST_TYPE_ID = P_COST_TYPE_ID;
SELECT
COST_MTHD_CODE
INTO L_COST_MTHD_CODE
FROM
CM_MTHD_MST
WHERE COST_TYPE_ID = P_COST_TYPE_ID;
SELECT
LEGAL_ENTITY_NAME
INTO L_LEGAL_ENTITY_NAME
FROM
GMF_LEGAL_ENTITIES
WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;