APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_RESOURCE_RULES

Line 2953: FROM hxc_pref_hierarchies a, hxc_resource_rules b, hxc_recurring_periods c

2949: /*start of fix 5083261*/
2950: CURSOR c_pref_cursor IS
2951: select recurring_period_id rec_period,rownum periodname_index from (
2952: SELECT distinct c.recurring_period_id,c.name
2953: FROM hxc_pref_hierarchies a, hxc_resource_rules b, hxc_recurring_periods c
2954: WHERE a.attribute_category = 'TC_W_TCRD_PERIOD'
2955: and a.attribute1 = c.recurring_period_id
2956: AND a.top_level_parent_id = b.pref_hierarchy_id
2957: AND p_business_group_id = NVL (a.business_group_id, p_business_group_id) order by c.name);