DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_INPUT_VALUES_F

Line 1759: pay_input_values_f piv,

1755: SELECT /*+ ORDERED */
1756: SUM(hrw.hours*(-1)*(ncr.add_or_subtract))
1757: FROM hxt_sum_hours_worked_f hrw,
1758: pay_element_types_f pef,
1759: pay_input_values_f piv,
1760: pay_net_calculation_rules ncr
1761: WHERE hrw.tim_id = p_tim_id
1762: AND SYSDATE BETWEEN hrw.effective_start_date
1763: AND hrw.effective_end_date