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.PER_ABSENCE_RECORD dependencies on PER_ABSENCE_ATTENDANCES_V

Line 6: CURSOR cur_absence(p_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,

2: /* $Header: peabsqry.pkb 120.0.12010000.4 2009/01/22 09:44:27 srgnanas noship $ */
3: PROCEDURE get_absence_details( p_query_options IN absence_input_rectype,
4: p_absences OUT NOCOPY absence_tabletype)
5: IS
6: CURSOR cur_absence(p_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
7: p_start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
8: p_end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
9: p_absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE) IS
10: SELECT a.absence_attendance_id,

Line 7: p_start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,

3: PROCEDURE get_absence_details( p_query_options IN absence_input_rectype,
4: p_absences OUT NOCOPY absence_tabletype)
5: IS
6: CURSOR cur_absence(p_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
7: p_start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
8: p_end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
9: p_absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE) IS
10: SELECT a.absence_attendance_id,
11: a.business_group_id,

Line 8: p_end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,

4: p_absences OUT NOCOPY absence_tabletype)
5: IS
6: CURSOR cur_absence(p_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
7: p_start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
8: p_end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
9: p_absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE) IS
10: SELECT a.absence_attendance_id,
11: a.business_group_id,
12: a.absence_attendance_type_id,

Line 9: p_absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE) IS

5: IS
6: CURSOR cur_absence(p_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
7: p_start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
8: p_end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
9: p_absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE) IS
10: SELECT a.absence_attendance_id,
11: a.business_group_id,
12: a.absence_attendance_type_id,
13: a.abs_attendance_reason_id,

Line 123: FROM PER_ABSENCE_ATTENDANCES_V a

119: a.confirmed_until,
120: a.source,
121: a.advance_pay,
122: a.absence_case_id
123: FROM PER_ABSENCE_ATTENDANCES_V a
124: WHERE nvl(p_person_id, a.person_id) = a.person_id
125: AND a.person_id BETWEEN nvl(p_start_person_id, a.person_id)
126: AND nvl(p_end_person_id, a.person_id)
127: AND nvl(p_absence_attendance_id, a.absence_attendance_id) = a.absence_attendance_id;