APPS.HXT_HXT007A_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 57: FROM pay_element_types_f elt,

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

Line 58: hxt_pay_element_types_f_ddf_v eltv,

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