APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_PREF_HIERARCHIES

Line 2079: p_edit_allowed_preference hxc_pref_hierarchies.attribute1%TYPE

2075: ,
2076: p_timecard_status VARCHAR2
2077: /*ADVICE(1576): Mode of parameter is not specified with IN parameter [521] */
2078: ,
2079: p_edit_allowed_preference hxc_pref_hierarchies.attribute1%TYPE
2080: /*ADVICE(1579): Mode of parameter is not specified with IN parameter [521] */
2081: ,
2082: p_edit_allowed IN OUT NOCOPY VARCHAR2
2083: ) IS

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);