The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT meaning
INTO l_yes_no
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = P_FAILED_FUNDS;
function select_failed_f return character is
begin
if P_failed_funds = 'Y' then
return(',prl.requisition_header_id, gl1.description Description1'); else
select gsb.chart_of_accounts_id
into l_p_chart_of_accounts_id
from gl_sets_of_books gsb,
financials_system_parameters fsp
where gsb.set_of_books_id = fsp.set_of_books_id;
select psp.manual_req_num_type
into numbering_type
from po_system_parameters psp;