The following lines contain the word 'select', 'insert', 'update' or 'delete':
select type_tl.name,
type.uom,
decode (type.lookup_type,
null, decode (type.hot_default_flag,
'N', entry.screen_entry_value,
'Y', nvl (entry.screen_entry_value, nvl (link.default_value, type.default_value))),
hr_general.decode_lookup (type.lookup_type,
decode (type.hot_default_flag,
'N', entry.screen_entry_value,
'Y', nvl (entry.screen_entry_value,
nvl (link.default_value,
type.default_value))))) SCREEN_ENTRY_VALUE
from pay_input_values_f_tl TYPE_TL,
pay_input_values_f TYPE,
pay_element_entry_values_f ENTRY,
pay_link_input_values_f LINK
where link.element_link_id = p_element_link_id
and entry.element_entry_id = p_element_entry_id
and link.input_value_id = entry.input_value_id + 0
and type.input_value_id = entry.input_value_id
and type_tl.input_value_id = type.input_value_id
and userenv('LANG') = type_tl.language
and p_effective_date = entry.effective_start_date
and entry.effective_start_date between link.effective_start_date
and link.effective_end_date
and entry.effective_start_date between type.effective_start_date
and type.effective_end_date
order by type.display_sequence, type_tl.name;
select cost_allocation_structure
from per_business_groups_perf
where business_group_id + 0 = p_business_group_id;