APPS.HXT_BATCH_VAL dependencies on HXT_SUM_HOURS_WORKED_X

Line 435: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,

431: END person_validation;
432:
433: PROCEDURE excess_pto (
434: p_batch_id IN NUMBER,
435: p_calculation_date IN hxt_sum_hours_worked_x.date_worked%TYPE,
436: p_person_id IN hxt_timecards.for_person_id%TYPE,
437: p_period_id IN hxt_timecards.time_period_id%TYPE,
438: p_tim_id IN hxt_timecards.id%TYPE
439: )

Line 1087: FROM hxt_sum_hours_worked_x hshwx

1083: p_hours_type hxt_det_hours_worked_f.hours%TYPE
1084: )
1085: IS
1086: SELECT SUM (hshwx.hours)
1087: FROM hxt_sum_hours_worked_x hshwx
1088: WHERE hshwx.tim_id = p_tim_id
1089: AND hshwx.date_worked = p_day
1090: AND ( (p_hours_type IS NULL)
1091: OR ( (p_hours_type IS NOT NULL)

Line 1650: FROM hxt_sum_hours_worked_x hshwx

1646: CURSOR csr_days (p_tim_id hxt_timecards.id%TYPE)
1647: IS
1648: SELECT DISTINCT hshwx.date_worked, hshwx.element_type_id,
1649: hshwx.assignment_id
1650: FROM hxt_sum_hours_worked_x hshwx
1651: WHERE tim_id = p_tim_id
1652: AND hshwx.effective_end_date = hr_general.end_of_time;
1653:
1654: CURSOR c_no_mid_period_change (p_person_id in number)