eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_UTIL dependencies on PAY_NET_CALCULATION_RULES

Line 1745: pay_net_calculation_rules_v ncr

1741:
1742: /*
1743: SELECT sum(hrw.hours*(-1)*(ncr.add_or_subtract))
1744: FROM hxt_sum_hours_worked_f hrw,
1745: pay_net_calculation_rules_v ncr
1746: WHERE hrw.tim_id = p_tim_id
1747: and SYSDATE between hrw.effective_start_date
1748: and hrw.effective_end_date
1749: AND hrw.assignment_id = p_assignment_id

Line 1760: pay_net_calculation_rules ncr

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
1764: AND hrw.assignment_id = p_assignment_id

Line 1803: pay_net_calculation_rules_v ncr

1799: p_bus_group_id NUMBER,
1800: p_batch_id number) is
1801: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1802: FROM hxt_det_hours_worked_f det,
1803: pay_net_calculation_rules_v ncr
1804: WHERE det.tim_id = p_tim_id
1805: AND det.assignment_id = p_assignment_id
1806: AND ncr.business_group_id = p_bus_group_id
1807: AND ncr.accrual_plan_id = p_accrual_plan_id

Line 1817: pay_net_calculation_rules_v ncr

1813: p_accrual_plan_id NUMBER,
1814: p_bus_group_id NUMBER) is
1815: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1816: FROM hxt_det_hours_worked_f det,
1817: pay_net_calculation_rules_v ncr
1818: WHERE det.tim_id = p_tim_id
1819: AND det.assignment_id = p_assignment_id
1820: AND ncr.business_group_id = p_bus_group_id
1821: AND ncr.accrual_plan_id = p_accrual_plan_id