53: function cf_detail_hoursformula(P_BATCH_ID in number) return number is
54:
55: CURSOR details_hours_cur IS
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
54:
55: CURSOR details_hours_cur IS
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