APPS.HR_PERSON_ABSENCE_API dependencies on PER_ABSENCE_ATTENDANCES

Line 103: from per_absence_attendances

99: ,abs_information30
100: ,absence_case_id
101: ,batch_id
102: ,object_version_number
103: from per_absence_attendances
104: where absence_attendance_id = p_absence_attendance_id;
105: --
106: l_absence_rec per_abs_shd.g_rec_type;
107: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';

Line 989: from per_absence_attendances abs

985: select abs.person_id,
986: abs.absence_attendance_type_id,
987: abs.date_start,
988: abs.date_end
989: from per_absence_attendances abs
990: where abs.absence_attendance_id = p_absence_attendance_id;
991:
992:
993: l_proc varchar2(72) := g_package||'update_person_absence';

Line 1962: from per_absence_attendances aba,

1958: (p_absence_attendance_id in number) return boolean is
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:

Line 2013: from per_absence_attendances abs

2009: cursor c_get_absence_element is
2010: select distinct pee.element_entry_id
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

Line 2114: from per_absence_attendances aba,

2110: abt.increasing_or_decreasing_flag,
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

Line 2125: l_absence_hours per_absence_attendances.absence_hours%TYPE;

2121: and piv.element_type_id = pet.element_type_id;
2122:
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;

Line 2126: l_absence_days per_absence_attendances.absence_days%TYPE;

2122:
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: