APPS.HXT_UTIL dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V
Line 474: FROM hxt_pay_element_types_f_ddf_v eltv
470: BEGIN
471: BEGIN
472: SELECT eltv.hxt_earning_category
473: INTO l_earning_cat 474: FROM hxt_pay_element_types_f_ddf_v eltv 475: WHERE eltv.element_type_id = p_element_type_id
476: AND p_date_worked BETWEEN eltv.effective_start_date
477: AND eltv.effective_end_date;
478: EXCEPTION