APPS.HXT_BATCH_VAL dependencies on HXT_SUM_HOURS_WORKED_X

Line 469: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,

465: END person_validation;
466:
467: PROCEDURE excess_pto (
468: p_batch_id IN NUMBER,
469: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
470: p_person_id IN hxt_timecards.for_person_id%TYPE,
471: p_period_id IN hxt_timecards.time_period_id%TYPE,
472: p_tim_id IN hxt_timecards.id%TYPE
473: )

Line 1208: FROM hxt_sum_hours_worked_x hshwx

1204: p_hours_type hxt_det_hours_worked_f.hours%TYPE
1205: )
1206: IS
1207: SELECT SUM (hshwx.hours)
1208: FROM hxt_sum_hours_worked_x hshwx
1209: WHERE hshwx.tim_id = p_tim_id
1210: AND hshwx.date_worked = p_day
1211: AND ( (p_hours_type IS NULL)
1212: OR ( (p_hours_type IS NOT NULL)

Line 1885: FROM hxt_sum_hours_worked_x hshwx

1881: CURSOR csr_days (p_tim_id hxt_timecards.id%TYPE)
1882: IS
1883: SELECT DISTINCT hshwx.date_worked, hshwx.element_type_id,
1884: hshwx.assignment_id
1885: FROM hxt_sum_hours_worked_x hshwx
1886: WHERE tim_id = p_tim_id
1887: AND hshwx.effective_end_date = hr_general.end_of_time;
1888:
1889: CURSOR c_no_mid_period_change (p_person_id in number)