APPS.HXC_SEEDDATA_PKG dependencies on HXC_ALIAS_DEFINITIONS

Line 12: := 'select alias_definition_name VALUE,alias_definition_id ID from hxc_alias_definitions

8: l_layouts VARCHAR2(1000)
9: := 'select Layout_Name Value, Layout_ID ID from hxc_layouts ';
10:
11: l_alias_definitions VARCHAR2(1000)
12: := 'select alias_definition_name VALUE,alias_definition_id ID from hxc_alias_definitions
13: ';
14:
15: l_alias_types VARCHAR2(1000)
16: := 'select ALIAS_TYPE||''-''||REFERENCE_OBJECT Value,ALIAS_TYPE_ID ID from hxc_alias_types

Line 130: ELSIF (p_object_type = 'HXC_ALIAS_DEFINITIONS') THEN

126: BEGIN
127:
128: IF (p_object_type = 'HXC_LAYOUTS') THEN
129: l_query := l_layouts;
130: ELSIF (p_object_type = 'HXC_ALIAS_DEFINITIONS') THEN
131: l_query := l_alias_definitions;
132: ELSIF (p_object_type = 'HXC_ALIAS_TYPES') THEN
133: l_query := l_alias_types;
134: ELSIF (p_object_type = 'HXC_TIME_SOURCES') THEN

Line 214: select legislation_code from hxc_alias_definitions

210: RETURN varchar2 IS
211:
212:
213: cursor c_alias_definitions is
214: select legislation_code from hxc_alias_definitions
215: where alias_definition_id = p_object_id;
216:
217: cursor c_pref_hierarchies is
218: select legislation_code from hxc_pref_hierarchies

Line 245: ELSIF (p_object_type = 'HXC_ALIAS_DEFINITIONS') THEN

241: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN
242: open c_approval_styles;
243: fetch c_approval_styles into l_legislation_code;
244: close c_approval_styles;
245: ELSIF (p_object_type = 'HXC_ALIAS_DEFINITIONS') THEN
246: open c_time_entry_rules;
247: fetch c_time_entry_rules into l_legislation_code;
248: close c_time_entry_rules;
249: ELSE