APPS.HXT_UTIL dependencies on HXT_TIMECARDS_F

Line 727: hxt_timecards_f htf

723: --
724: cursor csr_period_end IS
725: select ptp.end_date
726: from per_time_periods ptp,
727: hxt_timecards_f htf
728: where htf.batch_id = p_batch_id
729: and htf.time_period_id = ptp.time_period_id;
730: --
731: cursor csr_retro_end IS

Line 735: hxt_timecards_f htf

731: cursor csr_retro_end IS
732: select ptp.end_date
733: from per_time_periods ptp,
734: hxt_det_hours_worked_f hdh,
735: hxt_timecards_f htf
736: where hdh.retro_batch_id = p_batch_id
737: and hdh.tim_id = htf.id
738: and htf.time_period_id = ptp.time_period_id;
739: --

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

1789:
1790: cursor chk_original_batch_status is
1791: select null from pay_batch_headers pbh
1792: where pbh.batch_status='T'
1793: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f
1794: where id=p_tim_id);
1795:
1796: cursor get_retro_total( p_tim_id NUMBER,
1797: p_assignment_id NUMBER,

Line 2258: FROM hxt_timecards_f HTF

2254: FROM pay_batch_headers pbh
2255: WHERE pbh.batch_status <> 'T'
2256: AND pbh.batch_id = p_batch_id
2257: AND EXISTS ((SELECT HTF.batch_id
2258: FROM hxt_timecards_f HTF
2259: WHERE HTF.batch_id = pbh.batch_id)
2260: UNION
2261: (SELECT hdhw.retro_batch_id
2262: FROM hxt_det_hours_worked_f hdhw

Line 2377: FROM hxt_timecards_f

2373: IS
2374: CURSOR csr_chk_tc_exists_hxt
2375: IS
2376: SELECT 'Y'
2377: FROM hxt_timecards_f
2378: WHERE for_person_id = p_person_id;
2379:
2380:
2381: CURSOR csr_chk_tc_exists_ss