APPS.HXT_UTIL dependencies on HXT_SUM_HOURS_WORKED

Line 276: from hxt_timecards tim, hxt_sum_hours_worked hrw

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

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

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

Line 1619: hxt_sum_hours_worked_x hrw

1615: p_assignment_id NUMBER,
1616: p_element_type_id NUMBER) IS
1617: select sum(hrw.hours)
1618: from
1619: hxt_sum_hours_worked_x hrw
1620: where
1621: hrw.tim_id = p_tim_id
1622: and hrw.assignment_id = p_assignment_id
1623: and hrw.element_type_id = p_element_type_id;

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