APPS.HXT_BATCH_VAL dependencies on HXT_TIMECARDS_X

Line 270: FROM per_time_periods ptp, hxt_timecards_x htx

266:
267: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)
268: IS
269: SELECT ptp.end_date
270: FROM per_time_periods ptp, hxt_timecards_x htx
271: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
272:
273: l_tc_end_dt per_time_periods.end_date%TYPE;
274: BEGIN

Line 1658: hxt_timecards_x tim

1654: CURSOR c_no_mid_period_change (p_person_id in number)
1655: is
1656: select 'Y'
1657: from per_all_assignments_f p1,
1658: hxt_timecards_x tim
1659: where tim.effective_start_date between p1.effective_start_date and p1.effective_end_date
1660: and tim.effective_end_date between p1.effective_start_date and p1.effective_end_date
1661: and p1.person_id = p_person_id
1662: and p1.primary_flag = 'Y'

Line 1848: FROM hxt_timecards_x tim

1844: tim.last_update_date , tim.last_update_login,
1845: tim.payroll_id , tim.status,
1846: tim.effective_start_date , tim.effective_end_date,
1847: tim.object_version_number, tim.rowid
1848: FROM hxt_timecards_x tim
1849: WHERE tim.batch_id = p_batch_id;
1850: BEGIN
1851: g_debug :=hr_utility.debug_enabled;
1852: if g_debug then