APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_ABSENCE_TYPE_ELEMENTS

Line 398: hxc_absence_type_elements hate

394: FROM hxc_latest_details latest,
395: hxc_time_building_blocks detail,
396: hxc_time_attribute_usages htau,
397: hxc_time_attributes hta,
398: hxc_absence_type_elements hate
399: WHERE latest.resource_id = g_resource_id
400: AND TRUNC (latest.start_time) BETWEEN TRUNC (g_tc_start) AND TRUNC (g_tc_stop)
401: AND latest.time_building_block_id = detail.time_building_block_id
402: AND latest.object_version_number = detail.object_version_number

Line 1728: hxc_absence_type_elements hate

1724: absatt.time_end, absatt.person_id,
1725: absatt.program_application_id,
1726: hate.edit_flag
1727: FROM per_absence_attendances absatt,
1728: hxc_absence_type_elements hate
1729: WHERE absatt.absence_attendance_id = p_absence_attendance_id
1730: AND absatt.absence_attendance_type_id = hate.absence_attendance_type_id;
1731:
1732: CURSOR co_details_cur

Line 1757: l_edit_flag hxc_absence_type_elements.edit_flag%TYPE;

1753: l_time_start per_absence_attendances.time_start%TYPE;
1754: l_time_end per_absence_attendances.time_end%TYPE;
1755: l_person_id per_absence_attendances.person_id%TYPE;
1756: l_program_application_id per_absence_attendances.program_application_id%TYPE;
1757: l_edit_flag hxc_absence_type_elements.edit_flag%TYPE;
1758: l_absences_details t_absences_details;
1759: l_abs_index BINARY_INTEGER := 0;
1760: l_left NUMBER := 0;
1761: l_right NUMBER := 0;

Line 2690: FROM hxc_absence_type_elements

2686: hr_utility.trace('ABS:Inside function IS_VIEW_ONLY');
2687: END IF;
2688:
2689: SELECT edit_flag INTO l_edit_flag
2690: FROM hxc_absence_type_elements
2691: WHERE absence_attendance_type_id = p_absence_attendance_type_id;
2692:
2693: IF g_debug THEN
2694: hr_utility.trace('ABS:l_edit_flag = '||l_edit_flag);