APPS.HXT_UTIL dependencies on HXT_TIMECARDS_F

Line 731: hxt_timecards_f htf

727: --
728: cursor csr_period_end IS
729: select ptp.end_date
730: from per_time_periods ptp,
731: hxt_timecards_f htf
732: where htf.batch_id = p_batch_id
733: and htf.time_period_id = ptp.time_period_id;
734: --
735: cursor csr_retro_end IS

Line 739: hxt_timecards_f htf

735: cursor csr_retro_end IS
736: select ptp.end_date
737: from per_time_periods ptp,
738: hxt_det_hours_worked_f hdh,
739: hxt_timecards_f htf
740: where hdh.retro_batch_id = p_batch_id
741: and hdh.tim_id = htf.id
742: and htf.time_period_id = ptp.time_period_id;
743: --

Line 1863: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f

1859:
1860: cursor chk_original_batch_status is
1861: select null from pay_batch_headers pbh
1862: where pbh.batch_status='T'
1863: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f
1864: where id=p_tim_id);
1865:
1866: cursor get_retro_total( p_tim_id NUMBER,
1867: p_assignment_id NUMBER,

Line 2340: FROM hxt_timecards_f HTF

2336: FROM pay_batch_headers pbh
2337: WHERE pbh.batch_status <> 'T'
2338: AND pbh.batch_id = p_batch_id
2339: AND EXISTS ((SELECT HTF.batch_id
2340: FROM hxt_timecards_f HTF
2341: WHERE HTF.batch_id = pbh.batch_id)
2342: UNION
2343: (SELECT hdhw.retro_batch_id
2344: FROM hxt_det_hours_worked_f hdhw

Line 2567: FROM hxt_timecards_f

2563: IS
2564: CURSOR csr_chk_tc_exists_hxt
2565: IS
2566: SELECT 'Y'
2567: FROM hxt_timecards_f
2568: WHERE for_person_id = p_person_id;
2569:
2570:
2571: CURSOR csr_chk_tc_exists_ss