8:
9: --store termination related information
10: TYPE rt_termination IS RECORD (
11: actual_termination_date
12: per_periods_of_service.actual_termination_date%TYPE,
13: notified_termination_date
14: per_periods_of_service.notified_termination_date%TYPE,
15: leaving_reason
16: per_periods_of_service.leaving_reason%TYPE,
10: TYPE rt_termination IS RECORD (
11: actual_termination_date
12: per_periods_of_service.actual_termination_date%TYPE,
13: notified_termination_date
14: per_periods_of_service.notified_termination_date%TYPE,
15: leaving_reason
16: per_periods_of_service.leaving_reason%TYPE,
17: comments
18: per_periods_of_service.comments%TYPE,
12: per_periods_of_service.actual_termination_date%TYPE,
13: notified_termination_date
14: per_periods_of_service.notified_termination_date%TYPE,
15: leaving_reason
16: per_periods_of_service.leaving_reason%TYPE,
17: comments
18: per_periods_of_service.comments%TYPE,
19: period_of_service_id
20: per_periods_of_service.period_of_service_id%TYPE,
14: per_periods_of_service.notified_termination_date%TYPE,
15: leaving_reason
16: per_periods_of_service.leaving_reason%TYPE,
17: comments
18: per_periods_of_service.comments%TYPE,
19: period_of_service_id
20: per_periods_of_service.period_of_service_id%TYPE,
21: object_version_number
22: per_periods_of_service.object_version_number%TYPE,
16: per_periods_of_service.leaving_reason%TYPE,
17: comments
18: per_periods_of_service.comments%TYPE,
19: period_of_service_id
20: per_periods_of_service.period_of_service_id%TYPE,
21: object_version_number
22: per_periods_of_service.object_version_number%TYPE,
23: person_type_id
24: per_person_types.person_type_id%TYPE,
18: per_periods_of_service.comments%TYPE,
19: period_of_service_id
20: per_periods_of_service.period_of_service_id%TYPE,
21: object_version_number
22: per_periods_of_service.object_version_number%TYPE,
23: person_type_id
24: per_person_types.person_type_id%TYPE,
25: assignment_status_type_id
26: per_assignment_status_types.assignment_status_type_id%TYPE,
28: per_all_people_f.rehire_recommendation%TYPE,
29: rehire_reason
30: per_all_people_f.rehire_reason%TYPE,
31: last_standard_process_date
32: per_periods_of_service.last_standard_process_date%type,
33: projected_termination_date
34: per_periods_of_service.projected_termination_date%type,
35: final_process_date
36: per_periods_of_service.final_process_date%type
30: per_all_people_f.rehire_reason%TYPE,
31: last_standard_process_date
32: per_periods_of_service.last_standard_process_date%type,
33: projected_termination_date
34: per_periods_of_service.projected_termination_date%type,
35: final_process_date
36: per_periods_of_service.final_process_date%type
37: );
38:
32: per_periods_of_service.last_standard_process_date%type,
33: projected_termination_date
34: per_periods_of_service.projected_termination_date%type,
35: final_process_date
36: per_periods_of_service.final_process_date%type
37: );
38:
39: -- for DFF
40: TYPE t_flex_table IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;