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
122: ,hr_soft_coding_keyflex hsc
123: ,hr_organization_information hoi
124: WHERE paa.person_id = papf.person_id
125: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id
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
154: ,reimb_days date_table
155: );
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
154: ,reimb_days date_table
155: );
156: TYPE user_table IS TABLE OF csr_user_table_details%ROWTYPE INDEX BY BINARY_INTEGER;
179: -- -- -- -- -- -- -- -- Private Functions and Procedures -- -- -- -- -- -- -- +
180: --#PROC1
181: PROCEDURE process_absence_details(p_abs_id IN NUMBER
182: ,p_start_date IN DATE
183: ,p_employee_number IN per_all_people_f.employee_number%TYPE
184: ,p_employee_name IN per_all_people_f.full_name%TYPE
185: ,p_sickness_days IN date_table
186: ) IS
187:
180: --#PROC1
181: PROCEDURE process_absence_details(p_abs_id IN NUMBER
182: ,p_start_date IN DATE
183: ,p_employee_number IN per_all_people_f.employee_number%TYPE
184: ,p_employee_name IN per_all_people_f.full_name%TYPE
185: ,p_sickness_days IN date_table
186: ) IS
187:
188: