APPS.HXT_TIME_SUMMARY dependencies on HXC_RECURRING_PERIODS

Line 196: l_period_start_date hxc_recurring_periods.start_date%TYPE;

192: shift_adjusted_time_in DATE;
193: shift_adjusted_time_out DATE;
194:
195: otl_recurring_period VARCHAR2(120);
196: l_period_start_date hxc_recurring_periods.start_date%TYPE;
197: l_period_start DATE;
198: l_period_end DATE;
199: l_period_type hxc_recurring_periods.period_type%TYPE;
200:

Line 199: l_period_type hxc_recurring_periods.period_type%TYPE;

195: otl_recurring_period VARCHAR2(120);
196: l_period_start_date hxc_recurring_periods.start_date%TYPE;
197: l_period_start DATE;
198: l_period_end DATE;
199: l_period_type hxc_recurring_periods.period_type%TYPE;
200:
201: /* Bug: 4489952 changes starts here */
202:
203: -- procedure to insert the non-explosion timecard entries directly

Line 526: FROM hxc_recurring_periods

522: hr_utility.set_location('hxt_time_summary.generate_details',50);
523: end if;
524: SELECT start_date,period_type
525: INTO l_period_start_date,l_period_type
526: FROM hxc_recurring_periods
527: WHERE recurring_period_id = otl_recurring_period;
528:
529: if g_debug then
530: hr_utility.trace('l_period_start_date :'