DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_NET_CALCULATION_RULES_V

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 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