APPS.HXT_TIME_SUMMARY dependencies on HXC_RECURRING_PERIODS

Line 1327: l_period_start_date hxc_recurring_periods.start_date%TYPE;

1323: shift_adjusted_time_in DATE;
1324: shift_adjusted_time_out DATE;
1325:
1326: otl_recurring_period VARCHAR2(120);
1327: l_period_start_date hxc_recurring_periods.start_date%TYPE;
1328: l_period_start DATE;
1329: l_period_end DATE;
1330: l_period_type hxc_recurring_periods.period_type%TYPE;
1331:

Line 1330: l_period_type hxc_recurring_periods.period_type%TYPE;

1326: otl_recurring_period VARCHAR2(120);
1327: l_period_start_date hxc_recurring_periods.start_date%TYPE;
1328: l_period_start DATE;
1329: l_period_end DATE;
1330: l_period_type hxc_recurring_periods.period_type%TYPE;
1331:
1332:
1333: -- Bug 7359347
1334: -- Return code for valid_data function, to avoid multiple

Line 1728: FROM hxc_recurring_periods

1724: hr_utility.set_location('hxt_time_summary.generate_details',50);
1725: end if;
1726: SELECT start_date,period_type
1727: INTO l_period_start_date,l_period_type
1728: FROM hxc_recurring_periods
1729: WHERE recurring_period_id = otl_recurring_period;
1730:
1731: if g_debug then
1732: hr_utility.trace('l_period_start_date :'