APPS.HXT_BATCH_VAL dependencies on HR_GENERAL

Line 1652: AND hshwx.effective_end_date = hr_general.end_of_time;

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)
1655: is
1656: select 'Y'