The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.notes,
a.created_by_name,
a.entered_date, --modified with a.entered_date instead of a.creation_date for bug#4177915
a.note_type_meaning,
a.note_status_meaning,
a.source_object_id,
a.source_object_code,
b.select_id,
b.select_name,
b.select_details,
b.from_table,
b.where_clause,
tl.name,
a.notes_detail_size
FROM ast_notes_bali_vl a,
jtf_objects_b b,
jtf_objects_tl tl
WHERE (a.note_status <> 'P' or a.created_by = p_fnd_user_id)
and a.object_code like p_object_code
and a.object_id = p_object_id
and a.source_object_code = b.object_code
and b.object_code = tl.object_code
and tl.language = userenv('LANG')
order by a.entered_date desc; --modified with a.entered_date instead of a.creation_date for bug#4177915
SELECT a.notes,
a.created_by_name,
a.entered_date, --modified with a.entered_date instead of a.creation_date for bug#4177915
a.note_type_meaning,
a.note_status_meaning,
a.source_object_id,
a.source_object_code,
b.select_id,
b.select_name,
b.select_details,
b.from_table,
b.where_clause,
tl.name,
a.notes_detail_size
FROM ast_notes_bali_vl a,
jtf_objects_b b,
jtf_objects_tl tl
WHERE (a.note_status <> 'P' or a.created_by = p_fnd_user_id)
and a.object_code like p_object_code
and a.object_id = p_object_id
and a.source_object_code = b.object_code
and b.object_code = tl.object_code
and tl.language = userenv('LANG')
and trunc(a.creation_date) between trunc(p_from_date) and trunc(sysdate)
order by a.entered_date desc; --modified with a.entered_date instead of a.creation_date for bug#4177915