DBA Data[Home] [Help]

APPS.HXT_HXT007A_XMLP_PKG dependencies on HXT_TIMECARDS_F

Line 60: hxt_timecards_f tim

56: SELECT SUM(det.hours)
57: FROM pay_element_types_f elt,
58: hxt_pay_element_types_f_ddf_v eltv,
59: hxt_det_hours_worked_f det,
60: hxt_timecards_f tim
61: WHERE det.element_type_id = elt.element_type_id
62: AND det.date_worked BETWEEN elt.effective_start_date AND elt.effective_end_date
63: AND elt.element_type_id = eltv.element_type_id
64: AND det.date_worked BETWEEN eltv.effective_start_date AND eltv.effective_end_date