APPS.HXT_UTIL dependencies on HXT_SUM_HOURS_WORKED

Line 280: from hxt_timecards tim, hxt_sum_hours_worked hrw

276: -- Total all hours for Absence Element for current pay period
277: --
278: CURSOR hr_amt(p_period_id NUMBER,p_assignement_id NUMBER,p_element_type_id NUMBER) IS
279: select sum(hours)
280: from hxt_timecards tim, hxt_sum_hours_worked hrw
281: where hrw.tim_id = tim.id
282: and tim.time_period_id = p_period_id
283: and hrw.assignment_id = p_assignement_id
284: and hrw.element_type_id = p_element_type_id;

Line 807: SELECT NVL(MAX(seqno),0) INTO returned_seqno FROM hxt_sum_hours_worked thw --C421

803: NUMBER IS
804: -- Returns the max sequence + 10 of summary records of a given day on a given timecard
805: returned_seqno NUMBER;
806: BEGIN
807: SELECT NVL(MAX(seqno),0) INTO returned_seqno FROM hxt_sum_hours_worked thw --C421
808: WHERE thw.tim_id = a_timecard_id
809: AND thw.date_worked = a_date_worked;
810: RETURN returned_seqno + 10;
811: END;

Line 1640: hxt_sum_hours_worked_x hrw

1636: p_assignment_id NUMBER,
1637: p_element_type_id NUMBER) IS
1638: select sum(hrw.hours)
1639: from
1640: hxt_sum_hours_worked_x hrw
1641: where
1642: hrw.tim_id = p_tim_id
1643: and hrw.assignment_id = p_assignment_id
1644: and hrw.element_type_id = p_element_type_id;

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