APPS.HXC_RPT_TC_AUDIT_TRAIL dependencies on HR_GENERAL

Line 837: AND day_date_to <> hr_general.end_of_time

833: FROM hxc_rpt_tc_details_all det
834: WHERE resource_id = p_resource_id
835: AND tc_start_time = p_start_time
836: AND tc_stop_time = p_stop_time
837: AND day_date_to <> hr_general.end_of_time
838: AND creation_date = date_to
839: AND transaction_id IS NOT NULL
840: AND status <> 'WORKING'
841: AND NOT EXISTS ( SELECT 1

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

1256: -- this time entry belongs to a timecard previously recorded as
1257: -- Deleted )
1258: l_delete_done := FALSE;
1259: IF ( l_del_bb_id_tab.COUNT > 0
1260: AND l_tc_details(i).date_to <> hr_general.end_of_time )
1261: THEN
1262: FOR x IN l_del_bb_id_tab.FIRST..l_del_bb_id_tab.LAST
1263: LOOP
1264: IF ( l_del_bb_id_tab(x) = l_tc_details(i).tc_bb_id

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

1311: END IF; -- IF temp1 <> temp2
1312: END IF; -- IF l_tc_details(i-1).detail_bb_id = l_tc_details(i-1).detail_bb_id
1313: END IF; -- IF new record
1314:
1315: IF l_tc_details(i).date_to <> hr_general.end_of_time
1316: THEN
1317: IF l_tc_details.EXISTS(i+1)
1318: THEN
1319: IF l_tc_details(i).detail_bb_id = l_tc_details(i+1).detail_bb_id