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 1815: pay_net_calculation_rules_v ncr

1811:
1812: /*
1813: SELECT sum(hrw.hours*(-1)*(ncr.add_or_subtract))
1814: FROM hxt_sum_hours_worked_f hrw,
1815: pay_net_calculation_rules_v ncr
1816: WHERE hrw.tim_id = p_tim_id
1817: and SYSDATE between hrw.effective_start_date
1818: and hrw.effective_end_date
1819: AND hrw.assignment_id = p_assignment_id

Line 1830: pay_net_calculation_rules ncr

1826: SUM(hrw.hours*(-1)*(ncr.add_or_subtract))
1827: FROM hxt_sum_hours_worked_f hrw,
1828: pay_element_types_f pef,
1829: pay_input_values_f piv,
1830: pay_net_calculation_rules ncr
1831: WHERE hrw.tim_id = p_tim_id
1832: AND SYSDATE BETWEEN hrw.effective_start_date
1833: AND hrw.effective_end_date
1834: AND hrw.assignment_id = p_assignment_id

Line 1873: pay_net_calculation_rules_v ncr

1869: p_bus_group_id NUMBER,
1870: p_batch_id number) is
1871: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1872: FROM hxt_det_hours_worked_f det,
1873: pay_net_calculation_rules_v ncr
1874: WHERE det.tim_id = p_tim_id
1875: AND det.assignment_id = p_assignment_id
1876: AND ncr.business_group_id = p_bus_group_id
1877: AND ncr.accrual_plan_id = p_accrual_plan_id

Line 1887: pay_net_calculation_rules_v ncr

1883: p_accrual_plan_id NUMBER,
1884: p_bus_group_id NUMBER) is
1885: SELECT nvl(sum(det.hours*(-1)*(ncr.add_or_subtract)),0)
1886: FROM hxt_det_hours_worked_f det,
1887: pay_net_calculation_rules_v ncr
1888: WHERE det.tim_id = p_tim_id
1889: AND det.assignment_id = p_assignment_id
1890: AND ncr.business_group_id = p_bus_group_id
1891: AND ncr.accrual_plan_id = p_accrual_plan_id