APPS.HXC_SEEDDATA_PKG dependencies on HXC_APPROVAL_STYLES

Line 61: FROM hxc_approval_styles has

57:
58:
59: l_approval_styles VARCHAR2 (1000)
60: := 'SELECT has.NAME VALUE, has.approval_style_id id
61: FROM hxc_approval_styles has
62: ';
63:
64: l_data_approval_rule VARCHAR2(1000)
65: := ' SELECT dar.NAME Value, dru.data_app_rule_usage_id id

Line 148: ELSIF (p_object_type = 'HXC_APPROVAL_STYLES') THEN

144: ELSIF (p_object_type = 'HXC_RETRIEVAL_RULES') THEN
145: l_query := l_retrieval_rules;
146: ELSIF (p_object_type = 'HXC_DEPOSIT_PROCESSES') THEN
147: l_query := l_deposit_processes;
148: ELSIF (p_object_type = 'HXC_APPROVAL_STYLES') THEN
149: l_query := l_approval_styles;
150: ELSIF (p_object_type = 'HXC_DATA_APPROVAL_RULES') THEN
151: l_query := l_data_approval_rule;
152: ELSIF (p_object_type = 'HXC_RECURRING_PERIODS') THEN

Line 222: select legislation_code from hxc_approval_styles

218: select legislation_code from hxc_pref_hierarchies
219: where pref_hierarchy_id = p_object_id;
220:
221: cursor c_approval_styles is
222: select legislation_code from hxc_approval_styles
223: where approval_style_id = p_object_id;
224:
225: cursor c_time_entry_rules is
226: select legislation_code from hxc_time_entry_rules

Line 233: IF (p_object_type = 'HXC_APPROVAL_STYLES') THEN

229: l_legislation_code varchar2(30);
230:
231: BEGIN
232:
233: IF (p_object_type = 'HXC_APPROVAL_STYLES') THEN
234: open c_alias_definitions;
235: fetch c_alias_definitions into l_legislation_code;
236: close c_alias_definitions;
237: ELSIF (p_object_type = 'HXC_TIME_ENTRY_RULES') THEN