APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_RECURRING_PERIODS

Line 1557: FROM hxc_recurring_periods hrp

1553: /*ADVICE(1306): This definition hides another one [556] */
1554: NUMBER
1555: ) IS
1556: SELECT hrp.period_type, hrp.duration_in_days, hrp.start_date
1557: FROM hxc_recurring_periods hrp
1558: WHERE hrp.recurring_period_id = p_recurring_period_id;
1559:
1560: /*
1561: CURSOR c_emp_hireinfo (

Line 1684: l_period_type hxc_recurring_periods.period_type%TYPE;

1680: l_person_effective_end_date DATE;
1681: l_touch_period_in_tc BOOLEAN;
1682:
1683: --l_dividend NUMBER;
1684: l_period_type hxc_recurring_periods.period_type%TYPE;
1685: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
1686: l_emp_max_date_in_past DATE;
1687: l_emp_max_date_in_futur DATE;
1688: l_start_date DATE;

Line 1685: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;

1681: l_touch_period_in_tc BOOLEAN;
1682:
1683: --l_dividend NUMBER;
1684: l_period_type hxc_recurring_periods.period_type%TYPE;
1685: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
1686: l_emp_max_date_in_past DATE;
1687: l_emp_max_date_in_futur DATE;
1688: l_start_date DATE;
1689: l_end_date DATE;

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