APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_RECURRING_PERIODS

Line 1539: FROM hxc_recurring_periods hrp

1535: /*ADVICE(1306): This definition hides another one [556] */
1536: NUMBER
1537: ) IS
1538: SELECT hrp.period_type, hrp.duration_in_days, hrp.start_date
1539: FROM hxc_recurring_periods hrp
1540: WHERE hrp.recurring_period_id = p_recurring_period_id;
1541:
1542: /*
1543: CURSOR c_emp_hireinfo (

Line 1666: l_period_type hxc_recurring_periods.period_type%TYPE;

1662: l_person_effective_end_date DATE;
1663: l_touch_period_in_tc BOOLEAN;
1664:
1665: --l_dividend NUMBER;
1666: l_period_type hxc_recurring_periods.period_type%TYPE;
1667: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
1668: l_emp_max_date_in_past DATE;
1669: l_emp_max_date_in_futur DATE;
1670: l_start_date DATE;

Line 1667: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;

1663: l_touch_period_in_tc BOOLEAN;
1664:
1665: --l_dividend NUMBER;
1666: l_period_type hxc_recurring_periods.period_type%TYPE;
1667: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
1668: l_emp_max_date_in_past DATE;
1669: l_emp_max_date_in_futur DATE;
1670: l_start_date DATE;
1671: l_end_date DATE;

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

2931: /*start of fix 5083261*/
2932: CURSOR c_pref_cursor IS
2933: select recurring_period_id rec_period,rownum periodname_index from (
2934: SELECT distinct c.recurring_period_id,c.name
2935: FROM hxc_pref_hierarchies a, hxc_resource_rules b, hxc_recurring_periods c
2936: WHERE a.attribute_category = 'TC_W_TCRD_PERIOD'
2937: and a.attribute1 = c.recurring_period_id
2938: AND a.top_level_parent_id = b.pref_hierarchy_id
2939: AND p_business_group_id = NVL (a.business_group_id, p_business_group_id) order by c.name);