APPS.HXT_UTIL dependencies on HXT_TIMECARDS

Line 280: from hxt_timecards tim, hxt_sum_hours_worked hrw

276: -- Total all hours for Absence Element for current pay period
277: --
278: CURSOR hr_amt(p_period_id NUMBER,p_assignement_id NUMBER,p_element_type_id NUMBER) IS
279: select sum(hours)
280: from hxt_timecards tim, hxt_sum_hours_worked hrw
281: where hrw.tim_id = tim.id
282: and tim.time_period_id = p_period_id
283: and hrw.assignment_id = p_assignement_id
284: and hrw.element_type_id = p_element_type_id;

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 950: from hxt_timecards

946: and pbh.batch_id = tbs.batch_id;
947:
948: cursor batch_param is
949: select payroll_id, time_period_id, for_person_id
950: from hxt_timecards
951: where id = p_tim_id;
952:
953: bp batch_param%ROWTYPE;
954: l_batch_ref VARCHAR2(30);

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 2080: FROM HXT_TIMECARDS_X

2076:
2077: CURSOR tim_dates is
2078: SELECT effective_start_date,
2079: effective_end_date
2080: FROM HXT_TIMECARDS_X
2081: WHERE id = p_tim_id;
2082:
2083:
2084: -- Local Variables

Line 2296: from hxt_timecards_x tim

2292:
2293: FUNCTION GetPersonID(p_TIM_ID NUMBER) RETURN NUMBER IS
2294: cursor person_cur(c_tim_id NUMBER) is
2295: select tim.for_person_id
2296: from hxt_timecards_x tim
2297: where tim.id = c_tim_id;
2298:
2299: l_person_id NUMBER := NULL;
2300:

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