APPS.HXT_UTIL dependencies on HXT_SUM_HOURS_WORKED_F

Line 1785: FROM hxt_sum_hours_worked_f

1781:
1782: /*
1783: CURSOR get_asg_id ( p_tim_id NUMBER, p_calculation_date DATE ) IS
1784: SELECT DISTINCT (assignment_id)
1785: FROM hxt_sum_hours_worked_f
1786: WHERE tim_id = p_tim_id
1787: AND DATE_WORKED=p_calculation_date
1788: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
1789: */

Line 1793: FROM hxt_sum_hours_worked_f

1789: */
1790:
1791: CURSOR get_asg_id ( p_tim_id NUMBER, p_calculation_date DATE ) IS
1792: SELECT assignment_id
1793: FROM hxt_sum_hours_worked_f
1794: WHERE tim_id = p_tim_id
1795: AND DATE_WORKED<=p_calculation_date
1796: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
1797: ORDER BY date_worked DESC;

Line 1814: FROM hxt_sum_hours_worked_f hrw,

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

Line 1827: FROM hxt_sum_hours_worked_f hrw,

1823: */
1824:
1825: SELECT /*+ ORDERED */
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