APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_ALIAS_VALUES

Line 3847: FROM hxc_alias_values

3843: -- multiple alternate names ie. First one when Alt Name Ids are
3844: -- sorted.
3845: CURSOR get_an_id(p_element_id IN NUMBER)
3846: IS SELECT attribute2
3847: FROM hxc_alias_values
3848: WHERE alias_definition_id = g_alias_id
3849: AND attribute1 = p_element_id
3850: AND attribute2 IS NOT NULL
3851: ORDER BY attribute2 ASC;