APPS.HXT_BATCH_VAL dependencies on HR_GENERAL

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

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)
1890: is
1891: select 'Y'