The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pref_hierarchy_id
,type
,name
,business_group_id
,legislation_code
,parent_pref_hierarchy_id
,edit_allowed
,displayed
,pref_definition_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
,orig_pref_hierarchy_id
,orig_parent_hierarchy_id -- Added the columns
,top_level_parent_id -- Preformance Fix
,code
from hxc_pref_hierarchies
where pref_hierarchy_id = p_pref_hierarchy_id;
select
pref_hierarchy_id
,type
,name
,business_group_id
,legislation_code
,parent_pref_hierarchy_id
,edit_allowed
,displayed
,pref_definition_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
,orig_pref_hierarchy_id
,orig_parent_hierarchy_id
,top_level_parent_id --Performance Fix
,code
from hxc_pref_hierarchies
where pref_hierarchy_id = p_pref_hierarchy_id
for update nowait;