7: * @rep:displayname PER_EMPLOYEE_ABSENCE
8: */
9: TYPE absence_rectype IS RECORD
10: (
11: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE,
12: business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
8: */
9: TYPE absence_rectype IS RECORD
10: (
11: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE,
12: business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
9: TYPE absence_rectype IS RECORD
10: (
11: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE,
12: business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
10: (
11: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE,
12: business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
11: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE,
12: business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
12: business_group_id PER_ABSENCE_ATTENDANCES_V.business_group_id%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
13: absence_attendance_type_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_type_id%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
14: abs_attendance_reason_id PER_ABSENCE_ATTENDANCES_V.abs_attendance_reason_id%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
15: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
16: authorising_person_id PER_ABSENCE_ATTENDANCES_V.authorising_person_id%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
17: replacement_person_id PER_ABSENCE_ATTENDANCES_V.replacement_person_id%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
18: period_of_incapacity_id PER_ABSENCE_ATTENDANCES_V.period_of_incapacity_id%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
19: absence_days PER_ABSENCE_ATTENDANCES_V.absence_days%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
20: absence_hours PER_ABSENCE_ATTENDANCES_V.absence_hours%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
21: comments PER_ABSENCE_ATTENDANCES_V.comments%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
22: date_end PER_ABSENCE_ATTENDANCES_V.date_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
23: date_notification PER_ABSENCE_ATTENDANCES_V.date_notification%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
24: date_projected_end PER_ABSENCE_ATTENDANCES_V.date_projected_end%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
25: date_projected_start PER_ABSENCE_ATTENDANCES_V.date_projected_start%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
26: date_start PER_ABSENCE_ATTENDANCES_V.date_start%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
27: occurrence PER_ABSENCE_ATTENDANCES_V.occurrence%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
28: ssp1_issued PER_ABSENCE_ATTENDANCES_V.ssp1_issued%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
29: time_end PER_ABSENCE_ATTENDANCES_V.time_end%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
30: time_projected_end PER_ABSENCE_ATTENDANCES_V.time_projected_end%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
31: time_projected_start PER_ABSENCE_ATTENDANCES_V.time_projected_start%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
32: time_start PER_ABSENCE_ATTENDANCES_V.time_start%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
33: request_id PER_ABSENCE_ATTENDANCES_V.request_id%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
34: program_application_id PER_ABSENCE_ATTENDANCES_V.program_application_id%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
35: program_id PER_ABSENCE_ATTENDANCES_V.program_id%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
36: program_update_date PER_ABSENCE_ATTENDANCES_V.program_update_date%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
37: attribute_category PER_ABSENCE_ATTENDANCES_V.attribute_category%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
38: attribute1 PER_ABSENCE_ATTENDANCES_V.attribute1%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
39: attribute2 PER_ABSENCE_ATTENDANCES_V.attribute2%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
40: attribute3 PER_ABSENCE_ATTENDANCES_V.attribute3%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
41: attribute4 PER_ABSENCE_ATTENDANCES_V.attribute4%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
42: attribute5 PER_ABSENCE_ATTENDANCES_V.attribute5%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
43: attribute6 PER_ABSENCE_ATTENDANCES_V.attribute6%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
44: attribute7 PER_ABSENCE_ATTENDANCES_V.attribute7%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
45: attribute8 PER_ABSENCE_ATTENDANCES_V.attribute8%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
46: attribute9 PER_ABSENCE_ATTENDANCES_V.attribute9%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
47: attribute10 PER_ABSENCE_ATTENDANCES_V.attribute10%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
48: attribute11 PER_ABSENCE_ATTENDANCES_V.attribute11%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
49: attribute12 PER_ABSENCE_ATTENDANCES_V.attribute12%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
50: attribute13 PER_ABSENCE_ATTENDANCES_V.attribute13%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
51: attribute14 PER_ABSENCE_ATTENDANCES_V.attribute14%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
52: attribute15 PER_ABSENCE_ATTENDANCES_V.attribute15%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
53: attribute16 PER_ABSENCE_ATTENDANCES_V.attribute16%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
54: attribute17 PER_ABSENCE_ATTENDANCES_V.attribute17%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
55: attribute18 PER_ABSENCE_ATTENDANCES_V.attribute18%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
56: attribute19 PER_ABSENCE_ATTENDANCES_V.attribute19%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
57: attribute20 PER_ABSENCE_ATTENDANCES_V.attribute20%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
58: last_update_date PER_ABSENCE_ATTENDANCES_V.last_update_date%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
59: last_updated_by PER_ABSENCE_ATTENDANCES_V.last_updated_by%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
60: last_update_login PER_ABSENCE_ATTENDANCES_V.last_update_login%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
61: created_by PER_ABSENCE_ATTENDANCES_V.created_by%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
62: creation_date PER_ABSENCE_ATTENDANCES_V.creation_date%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
63: object_version_number PER_ABSENCE_ATTENDANCES_V.object_version_number%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
64: c_type_desc PER_ABSENCE_ATTENDANCES_V.c_type_desc%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
65: element_type_id PER_ABSENCE_ATTENDANCES_V.element_type_id%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
66: absence_category PER_ABSENCE_ATTENDANCES_V.absence_category%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
67: category_meaning PER_ABSENCE_ATTENDANCES_V.category_meaning%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
68: hours_or_days PER_ABSENCE_ATTENDANCES_V.hours_or_days%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
69: value_column PER_ABSENCE_ATTENDANCES_V.value_column%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
70: increasing_or_decreasing PER_ABSENCE_ATTENDANCES_V.increasing_or_decreasing%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
71: value_uom PER_ABSENCE_ATTENDANCES_V.value_uom%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
72: c_abs_input_value_id PER_ABSENCE_ATTENDANCES_V.c_abs_input_value_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
73: abs_date_from PER_ABSENCE_ATTENDANCES_V.abs_date_from%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
74: abs_date_to PER_ABSENCE_ATTENDANCES_V.abs_date_to%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
75: c_auth_name PER_ABSENCE_ATTENDANCES_V.c_auth_name%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
76: c_auth_no PER_ABSENCE_ATTENDANCES_V.c_auth_no%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
77: c_rep_name PER_ABSENCE_ATTENDANCES_V.c_rep_name%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
78: c_rep_no PER_ABSENCE_ATTENDANCES_V.c_rep_no%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
79: c_reason_desc PER_ABSENCE_ATTENDANCES_V.c_reason_desc%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
80: linked_absence_id PER_ABSENCE_ATTENDANCES_V.linked_absence_id%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
81: sickness_start_date PER_ABSENCE_ATTENDANCES_V.sickness_start_date%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
82: sickness_end_date PER_ABSENCE_ATTENDANCES_V.sickness_end_date%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
83: accept_late_notification_flag PER_ABSENCE_ATTENDANCES_V.accept_late_notification_flag%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
84: reason_for_late_notification PER_ABSENCE_ATTENDANCES_V.reason_for_late_notification%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
85: pregnancy_related_illness PER_ABSENCE_ATTENDANCES_V.pregnancy_related_illness%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
86: maternity_id PER_ABSENCE_ATTENDANCES_V.maternity_id%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
87: smp_due_date PER_ABSENCE_ATTENDANCES_V.smp_due_date%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
88: abs_information_category PER_ABSENCE_ATTENDANCES_V.abs_information_category%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
89: abs_information1 PER_ABSENCE_ATTENDANCES_V.abs_information1%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
90: abs_information2 PER_ABSENCE_ATTENDANCES_V.abs_information2%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
91: abs_information3 PER_ABSENCE_ATTENDANCES_V.abs_information3%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
92: abs_information4 PER_ABSENCE_ATTENDANCES_V.abs_information4%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
93: abs_information5 PER_ABSENCE_ATTENDANCES_V.abs_information5%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
94: abs_information6 PER_ABSENCE_ATTENDANCES_V.abs_information6%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
95: abs_information7 PER_ABSENCE_ATTENDANCES_V.abs_information7%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
96: abs_information8 PER_ABSENCE_ATTENDANCES_V.abs_information8%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
97: abs_information9 PER_ABSENCE_ATTENDANCES_V.abs_information9%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
98: abs_information10 PER_ABSENCE_ATTENDANCES_V.abs_information10%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
99: abs_information11 PER_ABSENCE_ATTENDANCES_V.abs_information11%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
100: abs_information12 PER_ABSENCE_ATTENDANCES_V.abs_information12%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
101: abs_information13 PER_ABSENCE_ATTENDANCES_V.abs_information13%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
102: abs_information14 PER_ABSENCE_ATTENDANCES_V.abs_information14%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
103: abs_information15 PER_ABSENCE_ATTENDANCES_V.abs_information15%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
104: abs_information16 PER_ABSENCE_ATTENDANCES_V.abs_information16%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
105: abs_information17 PER_ABSENCE_ATTENDANCES_V.abs_information17%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
106: abs_information18 PER_ABSENCE_ATTENDANCES_V.abs_information18%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
107: abs_information19 PER_ABSENCE_ATTENDANCES_V.abs_information19%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
108: abs_information20 PER_ABSENCE_ATTENDANCES_V.abs_information20%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
109: abs_information21 PER_ABSENCE_ATTENDANCES_V.abs_information21%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
110: abs_information22 PER_ABSENCE_ATTENDANCES_V.abs_information22%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
111: abs_information23 PER_ABSENCE_ATTENDANCES_V.abs_information23%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
112: abs_information24 PER_ABSENCE_ATTENDANCES_V.abs_information24%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
113: abs_information25 PER_ABSENCE_ATTENDANCES_V.abs_information25%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
114: abs_information26 PER_ABSENCE_ATTENDANCES_V.abs_information26%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122: advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
115: abs_information27 PER_ABSENCE_ATTENDANCES_V.abs_information27%TYPE,
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122: advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
123: absence_case_id PER_ABSENCE_ATTENDANCES_V.absence_case_id%TYPE
116: abs_information28 PER_ABSENCE_ATTENDANCES_V.abs_information28%TYPE,
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122: advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
123: absence_case_id PER_ABSENCE_ATTENDANCES_V.absence_case_id%TYPE
124: );
117: abs_information29 PER_ABSENCE_ATTENDANCES_V.abs_information29%TYPE,
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122: advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
123: absence_case_id PER_ABSENCE_ATTENDANCES_V.absence_case_id%TYPE
124: );
125:
118: abs_information30 PER_ABSENCE_ATTENDANCES_V.abs_information30%TYPE,
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122: advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
123: absence_case_id PER_ABSENCE_ATTENDANCES_V.absence_case_id%TYPE
124: );
125:
126: TYPE absence_tabletype IS TABLE OF absence_rectype NOT NULL;
119: approval_status PER_ABSENCE_ATTENDANCES_V.approval_status%TYPE,
120: confirmed_until PER_ABSENCE_ATTENDANCES_V.confirmed_until%TYPE,
121: source PER_ABSENCE_ATTENDANCES_V.source%TYPE,
122: advance_pay PER_ABSENCE_ATTENDANCES_V.advance_pay%TYPE,
123: absence_case_id PER_ABSENCE_ATTENDANCES_V.absence_case_id%TYPE
124: );
125:
126: TYPE absence_tabletype IS TABLE OF absence_rectype NOT NULL;
127:
126: TYPE absence_tabletype IS TABLE OF absence_rectype NOT NULL;
127:
128: TYPE absence_input_rectype IS RECORD
129: (
130: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
131: start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
132: end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
133: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE DEFAULT NULL
134: );
127:
128: TYPE absence_input_rectype IS RECORD
129: (
130: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
131: start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
132: end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
133: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE DEFAULT NULL
134: );
135:
128: TYPE absence_input_rectype IS RECORD
129: (
130: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
131: start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
132: end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
133: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE DEFAULT NULL
134: );
135:
136: /*#
129: (
130: person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
131: start_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
132: end_person_id PER_ABSENCE_ATTENDANCES_V.person_id%TYPE DEFAULT NULL,
133: absence_attendance_id PER_ABSENCE_ATTENDANCES_V.absence_attendance_id%TYPE DEFAULT NULL
134: );
135:
136: /*#
137: * This is procedure for querying absence details.