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.HR_PERSON_ABSENCE_API dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 348: from per_absence_attendance_types

344:
345: l_hours_or_days varchar2(2);
346: cursor csr_get_abstype is
347: select HOURS_OR_DAYS, INPUT_VALUE_ID
348: from per_absence_attendance_types
349: where absence_attendance_type_id= p_absence_attendance_type_id;
350: l_chk_datestart date;
351: l_chk_dateend date;
352: l_elm_entry_id number;

Line 1204: from per_absence_attendance_types

1200: l_hours_or_days varchar2(2);
1201:
1202: cursor csr_get_abstype is
1203: select HOURS_OR_DAYS,INPUT_VALUE_ID
1204: from per_absence_attendance_types
1205: where absence_attendance_type_id= (select absence_attendance_type_id
1206: from per_absence_attendances where ABSENCE_ATTENDANCE_ID = p_absence_attendance_id);
1207:
1208:

Line 2551: per_absence_attendance_types abt

2547:
2548: cursor c_linked_to_element is
2549: select abt.input_value_id
2550: from per_absence_attendances aba,
2551: per_absence_attendance_types abt
2552: where aba.absence_attendance_id = p_absence_attendance_id
2553: and aba.absence_attendance_type_id = abt.absence_attendance_type_id;
2554:
2555:

Line 2603: ,per_absence_attendance_types abt

2599: ,pee.effective_start_date
2600: ,pee.effective_end_date
2601: from per_absence_attendances abs
2602: ,per_all_assignments_f asg
2603: ,per_absence_attendance_types abt
2604: ,pay_input_values_f piv
2605: ,pay_element_types_f pet
2606: ,pay_element_links_f pel
2607: ,pay_element_entries_f pee

Line 2651: from per_absence_attendance_types abt,

2647: (p_absence_attendance_type_id in number) return varchar2 is
2648:
2649: cursor c_get_processing_type is
2650: select upper(pet.processing_type)
2651: from per_absence_attendance_types abt,
2652: pay_input_values_f piv,
2653: pay_element_types_f pet
2654: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2655: and abt.input_value_id = piv.input_value_id

Line 2703: per_absence_attendance_types abt,

2699: abt.input_value_id,
2700: pet.element_type_id,
2701: pet.processing_type
2702: from per_absence_attendances aba,
2703: per_absence_attendance_types abt,
2704: pay_input_values_f piv,
2705: pay_element_types_f pet
2706: where aba.absence_attendance_id = p_absence_attendance_id
2707: and aba.absence_attendance_type_id = abt.absence_attendance_type_id

Line 2715: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;

2711:
2712: l_proc varchar2(72) := g_package||'get_element_details';
2713: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2714: l_absence_days per_absence_attendances.absence_days%TYPE;
2715: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2716: l_processing_type pay_element_types_f.processing_type%TYPE;
2717: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2718:
2719:

Line 2717: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;

2713: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2714: l_absence_days per_absence_attendances.absence_days%TYPE;
2715: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2716: l_processing_type pay_element_types_f.processing_type%TYPE;
2717: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2718:
2719:
2720: begin
2721:

Line 3202: per_absence_attendance_types abt,

3198: abt.hours_or_days,
3199: decode (hrtsteps.INFORMATION9,'CONFIRMED','Y','N') CONFIRMED_FLAG
3200: from hr_api_transactions hat,
3201: HR_API_TRANSACTION_STEPS hrtsteps,
3202: per_absence_attendance_types abt,
3203: pay_input_values_f piv,
3204: pay_element_types_f pet
3205: where
3206: hat.SELECTED_PERSON_ID = p_person_id

Line 3239: per_absence_attendance_types abt,

3235: nvl(aba.ABSENCE_DAYS,aba.ABSENCE_HOURS) DURATION,
3236: decode (aba.date_start,'','N','Y') CONFIRMED_FLAG
3237:
3238: from per_absence_attendances aba,
3239: per_absence_attendance_types abt,
3240: pay_input_values_f piv,
3241: pay_element_types_f pet
3242: where aba.person_id = p_person_id
3243: AND abt.absence_attendance_type_id= aba.absence_attendance_type_id