eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TD_UTIL dependencies on HXT_SUM_HOURS_WORKED_F

Line 1287: FROM hxt_sum_hours_worked_f hrwp

1283:
1284: CURSOR changed_cur(session_date DATE)
1285: IS
1286: SELECT 'C'
1287: FROM hxt_sum_hours_worked_f hrwp
1288: WHERE hrwp.id = a_hrw_id
1289: AND session_date BETWEEN hrwp.effective_start_date
1290: AND hrwp.effective_end_date
1291: AND ( creation_date <> last_update_date

Line 1293: FROM hxt_sum_hours_worked_f hrw

1289: AND session_date BETWEEN hrwp.effective_start_date
1290: AND hrwp.effective_end_date
1291: AND ( creation_date <> last_update_date
1292: OR EXISTS ( SELECT '1'
1293: FROM hxt_sum_hours_worked_f hrw
1294: WHERE hrw.id = a_hrw_id
1295: AND hrw.effective_start_date <>
1296: hrwp.effective_start_date)
1297: );

Line 1638: FROM hxt_sum_hours_worked_f

1634: */
1635: CURSOR edit24_cur
1636: IS
1637: SELECT SUM (hours)
1638: FROM hxt_sum_hours_worked_f
1639: WHERE tim_id = p_tim_id -- AND GROUP_ID <> NVL(p_hrw_group_id, 0)
1640: AND date_worked = p_date_worked
1641: AND g_td_session_date BETWEEN effective_start_date
1642: AND effective_end_date;