The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT parent_request_id
INTO l_stage_request_id
FROM fnd_concurrent_requests
WHERE request_id = l_conc_request_id;
SELECT parent_request_id
INTO l_set_request_id
FROM fnd_concurrent_requests
WHERE request_id = l_stage_request_id;
select to_char(gps.start_date,'DD/MM/YYYY')||' 00:00:00',
to_char(gps2.end_date,'DD/MM/YYYY')||' 23:59:59',
sob.currency_code
into l_period_start_date,
l_period_end_date,
l_sob_currency_code
from gl_period_statuses gps,
gl_period_statuses gps2,
--- gl_sets_of_books sob,
gl_ledgers_public_v sob,
fnd_application fa
where fa.application_short_name = argument1
and fa.application_id = gps.application_id
and fa.application_id = gps2.application_id
and gps.set_of_books_id = to_number(argument2)
--and gps.ledger_id = to_number(argument2)
and gps.set_of_books_id = sob.ledger_id
--and gps.ledger_id = sob.ledger_id
and gps.period_name = argument3
and gps.adjustment_period_flag <> 'Y'
and gps2.set_of_books_id = to_number(argument2)
and gps2.set_of_books_id = sob.ledger_id
and gps2.ledger_id = to_number(argument2)
and gps2.ledger_id = sob.ledger_id
and gps2.period_name = argument4
and gps2.adjustment_period_flag <> 'Y';