The following lines contain the word 'select', 'insert', 'update' or 'delete':
MODE="SELECT"
DISPLAY="ALL"');*/
P_veh_select_column1 := 'TPD.TRANSLATOR_CODE';
P_veh_select_column2 := 'RAAD.ECE_TP_LOCATION_CODE';
SELECT sob.name
INTO L_Company_Name
FROM gl_sets_of_books sob,
ar_system_parameters ar
WHERE sob.set_of_books_id = ar.set_of_books_id;
SELECT set_of_books_id
INTO l_sob_id
FROM ar_system_parameters;
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;
select meaning
into w_meaning
from fnd_lookups
where lookup_type = p_lookup_type
and lookup_code = p_lookup_code ;