APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HR_GENERAL

Line 405: AND detail.date_to = hr_general.end_of_time

401: AND latest.time_building_block_id = detail.time_building_block_id
402: AND latest.object_version_number = detail.object_version_number
403: AND detail.time_building_block_id = htau.time_building_block_id
404: AND detail.object_version_number = htau.time_building_block_ovn
405: AND detail.date_to = hr_general.end_of_time
406: AND htau.time_attribute_id = hta.time_attribute_id
407: AND hta.attribute_category like 'ELEMENT - %'
408: AND to_number(SUBSTR(hta.attribute_category, 11)) = hate.element_type_id
409: AND NOT EXISTS (

Line 474: AND detail.date_to <> hr_general.end_of_time

470: AND ht.TYPE = 'RETRIEVAL'
471: AND ht.status = 'SUCCESS')
472: AND DAY.time_building_block_id = detail.parent_building_block_id
473: AND DAY.object_version_number = detail.parent_building_block_ovn
474: AND detail.date_to <> hr_general.end_of_time
475: AND absco.absence_attendance_id = absatt.absence_attendance_id ) ;
476:
477:
478: IF g_debug THEN

Line 1075: IF l_latest_date_to_tab(l_ix) <> hr_general.end_of_time THEN

1071: ELSE
1072: l_h_ix := l_h_ix + 1;
1073: l_delete_id_tab(l_h_ix) := l_temp_id_tab(l_ix);
1074:
1075: IF l_latest_date_to_tab(l_ix) <> hr_general.end_of_time THEN
1076: l_delete_ovn_tab(l_h_ix) := l_latest_ovn_tab(l_ix);
1077: ELSE
1078: l_delete_ovn_tab(l_h_ix) := l_temp_ovn_tab(l_ix);
1079: END IF;