APPS.HXC_SEEDDATA_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 66: FROM hxc_time_entry_rules dar, hxc_data_app_rule_usages dru

62: ';
63:
64: l_data_approval_rule VARCHAR2(1000)
65: := ' SELECT dar.NAME Value, dru.data_app_rule_usage_id id
66: FROM hxc_time_entry_rules dar, hxc_data_app_rule_usages dru
67: WHERE dru.time_entry_rule_id = dar.time_entry_rule_id
68: ';
69:
70: l_recurring_periods VARCHAR2(1000)

Line 120: FROM hxc_time_entry_rules

116:
117:
118: l_time_entry_rules VARCHAR2(1000)
119: := 'SELECT NAME VALUE, time_entry_rule_id id
120: FROM hxc_time_entry_rules
121: ';
122:
123:
124: l_query varchar2(1000);

Line 168: ELSIF (p_object_type = 'HXC_TIME_ENTRY_RULES') THEN

164: ELSIF (p_object_type = 'HXC_LOCKER_TYPES') THEN
165: l_query := l_locker_types;
166: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN
167: l_query := l_pref_hierarchies;
168: ELSIF (p_object_type = 'HXC_TIME_ENTRY_RULES') THEN
169: l_query := l_time_entry_rules;
170: END IF;
171:
172: return l_query;

Line 226: select legislation_code from hxc_time_entry_rules

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
227: where time_entry_rule_id = p_object_id;
228:
229: l_legislation_code varchar2(30);
230:

Line 237: ELSIF (p_object_type = 'HXC_TIME_ENTRY_RULES') THEN

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
238: open c_pref_hierarchies;
239: fetch c_pref_hierarchies into l_legislation_code;
240: close c_pref_hierarchies;
241: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN