The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT je_header_id,je_source,je_category,encumbrance_type_id,
budget_version_id,currency_conversion_type , je_batch_id
FROM gl_je_headers
WHERE je_header_id=lv_header_id ;
SELECT user_je_source_name
FROM gl_je_sources
WHERE je_source_name= lv_gl_je_source ;
SELECT user_je_category_name
FROM gl_je_categories
WHERE je_category_name= lv_gl_je_category ;
SELECT encumbrance_type
FROM gl_encumbrance_types
WHERE encumbrance_type_id= lv_encumb_type_id ;
SELECT budget_name
FROM gl_budget_versions
WHERE budget_version_id= lv_bud_ver_id ;
SELECT user_conversion_type
FROM gl_daily_conversion_types
WHERE conversion_type = lv_curr_conv_type ;
SELECT description
FROM gl_lookups
WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'MJE_BATCH_STATUS')
AND lookup_code=substr( lv_status , 1 , 1);
SELECT meaning
FROM gl_lookups
WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'JE_BATCH_BC_STATUS')
AND lookup_code= lv_status ;
select status,budgetary_control_status from gl_je_batches where
je_batch_id=lv_je_batch_id ;