APPS.PER_NO_SICKLEAVEMONITORING dependencies on PER_ABSENCE_ATTENDANCES

Line 117: FROM per_absence_attendances paa

113: ,paa.date_start start_date
114: ,NVL(paa.date_end,c_to_date) end_date
115: ,papf.employee_number employee_number
116: ,papf.full_name employee_name
117: FROM per_absence_attendances paa
118: ,per_absence_attendance_types paat
119: ,per_all_assignments_f paaf
120: ,per_assignment_status_types past
121: ,per_all_people_f papf

Line 148: start_date per_absence_attendances.date_start%TYPE

144: -- -- -- -- -- -- -- -- -- Private Variables , Types -- -- -- -- -- -- -- -- -+
145:
146: TYPE date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
147: TYPE AbsenceDetails IS RECORD (
148: start_date per_absence_attendances.date_start%TYPE
149: ,end_date per_absence_attendances.date_end%TYPE
150: ,enabled SMALLINT := NULL
151: ,employee_number per_all_people_f.employee_number%TYPE
152: ,employee_name per_all_people_f.full_name%TYPE

Line 149: ,end_date per_absence_attendances.date_end%TYPE

145:
146: TYPE date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER;
147: TYPE AbsenceDetails IS RECORD (
148: start_date per_absence_attendances.date_start%TYPE
149: ,end_date per_absence_attendances.date_end%TYPE
150: ,enabled SMALLINT := NULL
151: ,employee_number per_all_people_f.employee_number%TYPE
152: ,employee_name per_all_people_f.full_name%TYPE
153: ,sickness_days date_table

Line 196: FROM per_absence_attendances prev_abs

192: ,curr_abs.date_start - prev_abs.date_end duration
193: ,prev_abs.date_start start_date
194: ,curr_abs.date_start curr_start_date
195: ,curr_abs.date_end curr_end_date
196: FROM per_absence_attendances prev_abs
197: ,per_absence_attendances curr_abs
198: ,per_absence_attendance_types pat
199: WHERE prev_abs.absence_attendance_type_id = pat.absence_attendance_type_id
200: AND prev_abs.date_end < curr_abs.date_start

Line 197: ,per_absence_attendances curr_abs

193: ,prev_abs.date_start start_date
194: ,curr_abs.date_start curr_start_date
195: ,curr_abs.date_end curr_end_date
196: FROM per_absence_attendances prev_abs
197: ,per_absence_attendances curr_abs
198: ,per_absence_attendance_types pat
199: WHERE prev_abs.absence_attendance_type_id = pat.absence_attendance_type_id
200: AND prev_abs.date_end < curr_abs.date_start
201: AND pat.absence_category IN ('S','PTS')

Line 223: FROM per_absence_attendances abs

219: --#CSR6
220: CURSOR csr_unconnected_absence(c_abs_id IN NUMBER) IS
221: SELECT abs.date_start start_date
222: ,NVL(abs.date_end,l_action_to) end_date
223: FROM per_absence_attendances abs
224: WHERE abs.absence_attendance_id = c_abs_id;
225:
226: r_connected_absence csr_connected_absence%ROWTYPE;
227: r_unconnected_absence csr_unconnected_absence%ROWTYPE;