The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
MAX(CASE gp.period_name WHEN period_from_param THEN gp.start_date END)
,MAX(CASE gp.period_name WHEN period_to_param THEN gp.end_date END)
INTO
gd_start_date
,gd_end_date
FROM
gl_periods gp
,gl_ledgers gll
WHERE
gll.ledger_id=ledger_id_param
AND gp.period_set_name =gll.period_set_name
AND gp.period_name IN (period_from_param,period_to_param);
SELECT MAX(gjh.je_header_id)
INTO ln_reval_header_id
FROM
gl_je_headers gjh
,gl_je_lines gjl
WHERE
gjh.status = 'P'
AND gjh.actual_flag = 'A'
AND gjh.ledger_id = ledger_id_param
AND gjh.je_source = 'Revaluation'
AND gjl.je_header_id = gjh.je_header_id
AND gjl.code_combination_id = p_code_combination_id
AND gjh.currency_code=p_currency
AND gjh.period_name=period_to_param;
SELECT currency_conversion_rate
INTO ln_reval_conversion_rate
FROM gl_je_headers
WHERE je_header_id=ln_reval_header_id;
SELECT name
INTO lc_access_set_name
FROM gl_access_sets
WHERE access_set_id=access_set_id_param;
SELECT name
INTO lc_ledger_name
FROM gl_ledgers
WHERE ledger_id=ledger_id_param;