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_RPT_TC_AUDIT_TRAIL dependencies on HR_GENERAL

Line 846: AND day_date_to <> hr_general.end_of_time

842: FROM hxc_rpt_tc_details_all det
843: WHERE resource_id = p_resource_id
844: AND tc_start_time = p_start_time
845: AND tc_stop_time = p_stop_time
846: AND day_date_to <> hr_general.end_of_time
847: AND creation_date = date_to
848: AND transaction_id IS NOT NULL
849: AND status <> 'WORKING'
850: AND NOT EXISTS ( SELECT 1

Line 1269: AND l_tc_details(i).date_to <> hr_general.end_of_time )

1265: -- this time entry belongs to a timecard previously recorded as
1266: -- Deleted )
1267: l_delete_done := FALSE;
1268: IF ( l_del_bb_id_tab.COUNT > 0
1269: AND l_tc_details(i).date_to <> hr_general.end_of_time )
1270: THEN
1271: FOR x IN l_del_bb_id_tab.FIRST..l_del_bb_id_tab.LAST
1272: LOOP
1273: IF ( l_del_bb_id_tab(x) = l_tc_details(i).tc_bb_id

Line 1324: IF l_tc_details(i).date_to <> hr_general.end_of_time

1320: END IF; -- IF temp1 <> temp2
1321: END IF; -- IF l_tc_details(i-1).detail_bb_id = l_tc_details(i-1).detail_bb_id
1322: END IF; -- IF new record
1323:
1324: IF l_tc_details(i).date_to <> hr_general.end_of_time
1325: THEN
1326: IF l_tc_details.EXISTS(i+1)
1327: THEN
1328: IF l_tc_details(i).detail_bb_id = l_tc_details(i+1).detail_bb_id