APPS.HXT_UTIL dependencies on HXT_SUM_HOURS_WORKED_F

Line 1724: FROM hxt_sum_hours_worked_f

1720: AND vap.e_link_effective_end_date;
1721:
1722: CURSOR get_asg_id ( p_tim_id NUMBER, p_calculation_date DATE ) IS
1723: SELECT DISTINCT (assignment_id)
1724: FROM hxt_sum_hours_worked_f
1725: WHERE tim_id = p_tim_id
1726: AND DATE_WORKED=p_calculation_date
1727: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
1728:

Line 1744: FROM hxt_sum_hours_worked_f hrw,

1740: -- We may make the same changes to the below cursor for retro total too.
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

Line 1757: FROM hxt_sum_hours_worked_f hrw,

1753: */
1754:
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