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.HXC_TPD_END dependencies on HXC_TIMECARD_SUMMARY

Line 110: FROM hxc_timecard_summary htb

106: cp_period_end IN DATE
107: )
108: IS
109: SELECT htb.start_time, htb.stop_time
110: FROM hxc_timecard_summary htb
111: WHERE htb.resource_id = cp_resource_id
112: AND cp_period_start <= htb.stop_time
113: AND cp_period_end >= htb.start_time;
114:

Line 125: FROM hxc_timecard_summary htb

121: SELECT 'x'
122: FROM DUAL
123: WHERE EXISTS (
124: SELECT 'x'
125: FROM hxc_timecard_summary htb
126: WHERE htb.resource_id = cp_resource_id
127: AND cp_period_start <= htb.stop_time
128: AND cp_period_end >= htb.start_time);
129: