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_ABS_RETRIEVAL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 454: per_absence_attendances absatt

450: NULL --link_time_building_block_id
451: FROM hxc_abs_co_details absco,
452: hxc_time_building_blocks detail,
453: hxc_time_building_blocks DAY,
454: per_absence_attendances absatt
455: WHERE absco.resource_id = g_resource_id
456: AND TRUNC (absco.start_time) = TRUNC (g_tc_start)
457: AND TRUNC (absco.stop_time) = TRUNC (g_tc_stop)
458: AND absco.absence_attendance_id IS NOT NULL

Line 1727: FROM per_absence_attendances absatt,

1723: absatt.time_start,
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:

Line 1750: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;

1746:
1747: TYPE t_co_details IS TABLE OF co_details_cur%ROWTYPE;
1748: l_co_details t_co_details;
1749:
1750: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
1751: l_date_start per_absence_attendances.date_start%TYPE;
1752: l_date_end per_absence_attendances.date_end%TYPE;
1753: l_time_start per_absence_attendances.time_start%TYPE;
1754: l_time_end per_absence_attendances.time_end%TYPE;

Line 1751: l_date_start per_absence_attendances.date_start%TYPE;

1747: TYPE t_co_details IS TABLE OF co_details_cur%ROWTYPE;
1748: l_co_details t_co_details;
1749:
1750: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
1751: l_date_start per_absence_attendances.date_start%TYPE;
1752: l_date_end per_absence_attendances.date_end%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;

Line 1752: l_date_end per_absence_attendances.date_end%TYPE;

1748: l_co_details t_co_details;
1749:
1750: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
1751: l_date_start per_absence_attendances.date_start%TYPE;
1752: l_date_end per_absence_attendances.date_end%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;

Line 1753: l_time_start per_absence_attendances.time_start%TYPE;

1749:
1750: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
1751: l_date_start per_absence_attendances.date_start%TYPE;
1752: l_date_end per_absence_attendances.date_end%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;

Line 1754: l_time_end per_absence_attendances.time_end%TYPE;

1750: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE;
1751: l_date_start per_absence_attendances.date_start%TYPE;
1752: l_date_end per_absence_attendances.date_end%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;

Line 1755: l_person_id per_absence_attendances.person_id%TYPE;

1751: l_date_start per_absence_attendances.date_start%TYPE;
1752: l_date_end per_absence_attendances.date_end%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;

Line 1756: l_program_application_id per_absence_attendances.program_application_id%TYPE;

1752: l_date_end per_absence_attendances.date_end%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;

Line 1785: -- get absences information from per_absence_attendances table

1781: IF g_debug THEN
1782: hr_utility.TRACE ( 'ABS:Process DELETE for Absence attendance id = ' || p_absence_attendance_id );
1783: END IF;
1784:
1785: -- get absences information from per_absence_attendances table
1786: OPEN get_absences_details_cur;
1787:
1788: FETCH get_absences_details_cur
1789: INTO l_absence_attendance_type_id,