The following lines contain the word 'select', 'insert', 'update' or 'delete':
arp_trx_select_control.build_where_clause(
p_choice, p_open_invoice, p_cust_trx_type_id,
p_cust_trx_class,
p_installment_number, p_dates_low, p_dates_high,
p_customer_id, p_customer_class_code, p_trx_number_low,
p_trx_number_high, p_batch_id, p_customer_trx_id,
p_adj_number_low, p_adj_number_high,
p_adj_dates_low, p_adj_dates_high,
where1, where2, table1, table2 );
select option_lu.meaning
--into print_option
into print_option_t
from ar_lookups option_lu
where option_lu.lookup_type(+) = 'INVOICE_PRINTING'
and option_lu.lookup_code(+) = upper(p_choice);
select name
--into type_id
into type_id_t
from ra_cust_trx_types
where cust_trx_type_id = p_customer_trx_id;
select substrb(party.party_name,1,50)
--into customer_id
into customer_id_t
from hz_cust_accounts cust,
hz_parties party
where cust.cust_account_id = p_customer_id
and cust.party_id = party.party_id;
select bat.name
--into batch_id
into batch_id_t
from ra_batches bat
where bat.batch_id = p_batch_id;
select open_lu.meaning
--into open_invoices
into open_invoices_t
from ar_lookups open_lu
where open_lu.lookup_type = 'YES/NO'
and open_lu.lookup_code = p_open_invoice;
SELECT sob.name Company_Name,
sob.currency_code Functional_Currency
--INTO company_name, functional_currency
INTO company_name, functional_currency_t
FROM gl_sets_of_books sob, ar_system_parameters ar
WHERE sob.set_of_books_id = ar.set_of_books_id;
SELECT cp.user_concurrent_program_name
INTO l_report_name
FROM FND_CONCURRENT_PROGRAMS_VL cp,
FND_CONCURRENT_REQUESTS cr
WHERE cr.request_id = P_CONC_REQUEST_ID
AND cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id;