APPS.HXT_BATCH_VAL dependencies on HXT_TIMECARDS_X

Line 276: FROM per_time_periods ptp, hxt_timecards_x htx

272:
273: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)
274: IS
275: SELECT ptp.end_date
276: FROM per_time_periods ptp, hxt_timecards_x htx
277: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
278:
279: l_tc_end_dt per_time_periods.end_date%TYPE;
280: BEGIN

Line 1893: hxt_timecards_x tim

1889: CURSOR c_no_mid_period_change (p_person_id in number)
1890: is
1891: select 'Y'
1892: from per_all_assignments_f p1,
1893: hxt_timecards_x tim
1894: where tim.effective_start_date between p1.effective_start_date and p1.effective_end_date
1895: and tim.effective_end_date between p1.effective_start_date and p1.effective_end_date
1896: and p1.person_id = p_person_id
1897: and p1.primary_flag = 'Y'

Line 2083: FROM hxt_timecards_x tim

2079: tim.last_update_date , tim.last_update_login,
2080: tim.payroll_id , tim.status,
2081: tim.effective_start_date , tim.effective_end_date,
2082: tim.object_version_number, tim.rowid
2083: FROM hxt_timecards_x tim
2084: WHERE tim.batch_id = p_batch_id;
2085: BEGIN
2086: g_debug :=hr_utility.debug_enabled;
2087: if g_debug then