DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

Line 20: FROM hxt_pay_element_types_f_ddf_v eltv

16: IS
17: BEGIN
18: SELECT eltv.hxt_earning_category
19: INTO o_earning_cat
20: FROM hxt_pay_element_types_f_ddf_v eltv
21: WHERE eltv.element_type_id = i_element_type_id;
22: EXCEPTION
23: WHEN no_data_found THEN
24: o_earning_cat := NULL;

Line 156: hxt_pay_element_types_f_ddf_v eltv

152: SELECT MAX('Y') --5574629
153: INTO l_exists
154: FROM pay_element_links_f ell,
155: per_all_assignments_f asm,
156: hxt_pay_element_types_f_ddf_v eltv
157: WHERE asm.assignment_id = p_asg_id
158: AND p_date_worked BETWEEN asm.effective_start_date
159: AND asm.effective_end_date
160: AND ell.element_type_id = p_element_type_id