APPS.HXT_TD_UTIL dependencies on HXT_SUM_HOURS_WORKED

Line 505: FROM hxt_sum_hours_worked hrwp

501:
502: CURSOR changed_cur
503: IS
504: SELECT 'C'
505: FROM hxt_sum_hours_worked hrwp
506: WHERE hrwp.id = a_hrw_id
507: AND ( creation_date <> last_update_date
508: OR EXISTS ( SELECT '1'
509: FROM hxt_sum_hours_worked_f hrw

Line 509: FROM hxt_sum_hours_worked_f hrw

505: FROM hxt_sum_hours_worked hrwp
506: WHERE hrwp.id = a_hrw_id
507: AND ( creation_date <> last_update_date
508: OR EXISTS ( SELECT '1'
509: FROM hxt_sum_hours_worked_f hrw
510: WHERE hrw.id = a_hrw_id
511: AND hrw.effective_start_date <>
512: hrwp.effective_start_date)
513: );

Line 817: * Get the sum of the hours from hxt_sum_hours_worked based on *

813: /*****************************************************************
814: * FUNCTION Get_Sum_Hours_Worked -- ER183 SDM 09-03-98 *
815: * *
816: * Purpose *
817: * Get the sum of the hours from hxt_sum_hours_worked based on *
818: * parameters passed in. Return this value to the calling *
819: * module *
820: * *
821: * Returns *

Line 840: FROM hxt_sum_hours_worked

836: IS
837: CURSOR edit24_cur
838: IS
839: SELECT SUM (hours)
840: FROM hxt_sum_hours_worked
841: WHERE tim_id = p_tim_id -- AND GROUP_ID <> NVL(p_hrw_group_id, 0)
842: AND date_worked = p_date_worked;
843:
844: l_total_hours NUMBER;