APPS.HR_PERSON_ABSENCE_API dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1963: per_absence_attendance_types abt

1959:
1960: cursor c_linked_to_element is
1961: select abt.input_value_id
1962: from per_absence_attendances aba,
1963: per_absence_attendance_types abt
1964: where aba.absence_attendance_id = p_absence_attendance_id
1965: and aba.absence_attendance_type_id = abt.absence_attendance_type_id;
1966:
1967:

Line 2015: ,per_absence_attendance_types abt

2011: ,pee.effective_start_date
2012: ,pee.effective_end_date
2013: from per_absence_attendances abs
2014: ,per_all_assignments_f asg
2015: ,per_absence_attendance_types abt
2016: ,pay_input_values_f piv
2017: ,pay_element_types_f pet
2018: ,pay_element_links_f pel
2019: ,pay_element_entries_f pee

Line 2063: from per_absence_attendance_types abt,

2059: (p_absence_attendance_type_id in number) return varchar2 is
2060:
2061: cursor c_get_processing_type is
2062: select upper(pet.processing_type)
2063: from per_absence_attendance_types abt,
2064: pay_input_values_f piv,
2065: pay_element_types_f pet
2066: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2067: and abt.input_value_id = piv.input_value_id

Line 2115: per_absence_attendance_types abt,

2111: abt.input_value_id,
2112: pet.element_type_id,
2113: pet.processing_type
2114: from per_absence_attendances aba,
2115: per_absence_attendance_types abt,
2116: pay_input_values_f piv,
2117: pay_element_types_f pet
2118: where aba.absence_attendance_id = p_absence_attendance_id
2119: and aba.absence_attendance_type_id = abt.absence_attendance_type_id

Line 2127: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;

2123:
2124: l_proc varchar2(72) := g_package||'get_element_details';
2125: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2126: l_absence_days per_absence_attendances.absence_days%TYPE;
2127: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2128: l_processing_type pay_element_types_f.processing_type%TYPE;
2129: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2130:
2131:

Line 2129: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;

2125: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2126: l_absence_days per_absence_attendances.absence_days%TYPE;
2127: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2128: l_processing_type pay_element_types_f.processing_type%TYPE;
2129: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2130:
2131:
2132: begin
2133: