The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
FROM hxc_pref_hierarchies;
SELECT pd.pref_definition_id
FROM hxc_pref_definitions pd
, fnd_descr_flex_contexts_vl df
WHERE df.application_id = 809
AND df.descriptive_flexfield_name = 'OTC PREFERENCES'
AND df.descriptive_flex_context_name = p_pref_def_name
AND df.descriptive_flex_context_code = pd.code;
SELECT TO_CHAR(approval_style_id)
FROM hxc_approval_styles
WHERE name = p_attribute;
SELECT TO_CHAR(alias_definition_id)
FROM hxc_alias_definitions
WHERE alias_definition_name = p_attribute;
SELECT TO_CHAR(rp.recurring_period_id)
FROM hxc_recurring_periods rp
WHERE rp.name = p_attribute;
SELECT TO_CHAR(aps.application_set_id)
FROM hxc_application_sets_v aps
WHERE aps.application_set_name = p_attribute;
SELECT TO_CHAR(rrg.retrieval_rule_group_id)
FROM hxc_retrieval_rule_groups_v rrg
WHERE rrg.retrieval_rule_group_name = p_attribute;
SELECT TO_CHAR(aps.approval_period_set_id)
FROM hxc_approval_period_sets aps
WHERE aps.name = p_attribute;
SELECT layout_id
FROM hxc_layouts
WHERE layout_name = p_attribute;
SELECT egc.attribute1
FROM hxc_entity_group_comps egc
WHERE egc.attribute2 = p_attribute
AND EXISTS ( SELECT 'x'
FROM hxc_entity_groups eg
WHERE eg.entity_group_id = egc.entity_group_id
AND eg.entity_type = 'HXC_SS_TC_DATE_FORMATS' );
SELECT time_entry_rule_group_id
FROM hxc_time_entry_rule_groups_v
WHERE time_entry_rule_group_name = p_attribute1;
hxc_pref_hierarchies_api.update_pref_hierarchies (
p_effective_date => sysdate
, p_name => p_name
, p_business_group_id => null
, p_legislation_code => p_legislation_code
, p_pref_hierarchy_id => l_pref_hierarchy_id
, p_parent_pref_hierarchy_id => l_parent_pref_hierarchy_id
, p_type => p_type
, p_edit_allowed => p_edit_allowed
, p_displayed => p_displayed
, p_pref_definition_id => l_pref_definition_id
, p_attribute_category => p_attribute_category
, p_attribute1 => l_attribute1
, p_attribute2 => l_attribute2
, p_attribute3 => l_attribute3
, p_attribute4 => l_attribute4
, p_attribute5 => l_attribute5
, p_attribute6 => l_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_attribute16 => p_attribute16
, p_attribute17 => p_attribute17
, p_attribute18 => p_attribute18
, p_attribute19 => p_attribute19
, p_attribute20 => p_attribute20
, p_attribute21 => p_attribute21
, p_attribute22 => p_attribute22
, p_attribute23 => p_attribute23
, p_attribute24 => p_attribute24
, p_attribute25 => p_attribute25
, p_attribute26 => p_attribute26
, p_attribute27 => p_attribute27
, p_attribute28 => p_attribute28
, p_attribute29 => p_attribute29
, p_attribute30 => p_attribute30
, p_object_version_number => l_ovn );
SELECT df.descriptive_flex_context_name
FROM fnd_descr_flex_contexts_vl df
, hxc_pref_definitions pd
WHERE pd.pref_definition_id = p_pref_definition_id
AND df.application_id =809
AND df.descriptive_flexfield_name = 'OTC PREFERENCES'
AND df.descriptive_flex_context_code = pd.code;
SELECT name
FROM hxc_approval_styles
WHERE approval_style_id = TO_NUMBER(p_attribute);
SELECT application_set_name
FROM hxc_application_sets_v
WHERE application_set_id = TO_NUMBER(p_attribute);
SELECT retrieval_rule_group_name
FROM hxc_retrieval_rule_groups_v
WHERE retrieval_rule_group_id = TO_NUMBER(p_attribute);
SELECT alias_definition_name
FROM hxc_alias_definitions
WHERE alias_definition_id = TO_NUMBER(p_attribute);
SELECT rp.name
FROM hxc_recurring_periods rp
WHERE recurring_period_id = TO_NUMBER(p_attribute);
SELECT aps.name
FROM hxc_approval_period_sets aps
WHERE approval_period_set_id = TO_NUMBER(p_attribute);
SELECT layout_name
FROM hxc_layouts
WHERE layout_id = TO_NUMBER(p_attribute);
SELECT egc.attribute2
FROM hxc_entity_group_comps egc
WHERE egc.attribute1 = p_attribute
AND EXISTS ( SELECT 'x'
FROM hxc_entity_groups eg
WHERE eg.entity_group_id = egc.entity_group_id
AND eg.entity_type = 'HXC_SS_TC_DATE_FORMATS' );
SELECT time_entry_rule_group_name
FROM hxc_time_entry_rule_groups_v
WHERE time_entry_rule_group_id = TO_NUMBER(p_attribute);
SELECT name
, level
, rownum cnt
from hxc_pref_hierarchies
start with name = p_top_node
connect by prior pref_hierarchy_id = parent_pref_hierarchy_id;