The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gl.name
INTO l_name
FROM gl_sets_of_books gl,pa_implementations pi
WHERE gl.set_of_books_id = pi.set_of_books_id;
select meaning
from pa_lookups
where lookup_type = type
and lookup_code = code;
SELECT meaning INTO tmp_over_flag
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code = overtime_flag ;
SELECT meaning INTO tmp_labortogl
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code = Iflabortogl ;
SELECT meaning INTO tmp_ifrevtogl
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code = ifrevenuetogl ;
SELECT meaning INTO tmp_ifusgtogl
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code = ifusagetogl ;
SELECT meaning INTO tmp_ceninvcoll
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code =
centralized_invoicing_flag ;
SELECT meaning INTO tmp_ifretnacc
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code = ifretnacc ;
SELECT meaning INTO tmp_over_flag
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = DECODE(mrc_for_fund,'U','Y', mrc_for_fund);
SELECT meaning INTO tmp_over_flag
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = DECODE(reval_mrc_fund,'U','Y', reval_mrc_fund);
SELECT meaning INTO tmp_over_flag
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = DECODE(mrc_for_finplan,'U','Y', mrc_for_finplan) ;
SELECT meaning INTO tmp_over_flag
FROM fnd_lookups
WHERE lookup_type = 'YES_NO' AND lookup_code = ingainloss ;
SELECT user_conversion_type INTO tmp_exchrate
FROM pa_conversion_types_v
WHERE conversion_type = exch_rate_type;
SELECT meaning INTO tmp_over_flag
FROM pa_lookups
WHERE lookup_type = 'PA_CUST_ACC_REL_CODE'
AND lookup_code = cust_acc_rel_code;
SELECT meaning
INTO temp
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = credit_memo_reason_flag;