DBA Data[Home] [Help]

APPS.HXT_TC_UTIL dependencies on PAY_ELEMENT_TYPES_F

Line 15: ,pay_element_types_f elt

11:
12: CURSOR tot_hrs2 IS
13: select sum(thw.hours)
14: from hxt_sum_hours_worked thw
15: ,pay_element_types_f elt
16: ,hxt_pay_element_types_f_ddf_v eltv
17: where thw.tim_id = p_tim_id
18: and thw.element_type_id is not null
19: and thw.element_type_id = elt.element_type_id

Line 16: ,hxt_pay_element_types_f_ddf_v eltv

12: CURSOR tot_hrs2 IS
13: select sum(thw.hours)
14: from hxt_sum_hours_worked thw
15: ,pay_element_types_f elt
16: ,hxt_pay_element_types_f_ddf_v eltv
17: where thw.tim_id = p_tim_id
18: and thw.element_type_id is not null
19: and thw.element_type_id = elt.element_type_id
20: and elt.element_type_id = eltv.element_type_id