1: PACKAGE per_qh_maintain_update AS
2: /* $Header: peqhmnti.pkh 120.4 2006/01/03 03:42:56 rvarshne noship $ */
3: PROCEDURE insert_maintain_data
4: (p_effective_date IN DATE
5: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
6: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
7: ,p_legislation_code IN VARCHAR2
8: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
9: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
2: /* $Header: peqhmnti.pkh 120.4 2006/01/03 03:42:56 rvarshne noship $ */
3: PROCEDURE insert_maintain_data
4: (p_effective_date IN DATE
5: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
6: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
7: ,p_legislation_code IN VARCHAR2
8: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
9: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
10: ,p_per_validation_start_date OUT NOCOPY DATE
4: (p_effective_date IN DATE
5: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
6: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
7: ,p_legislation_code IN VARCHAR2
8: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
9: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
10: ,p_per_validation_start_date OUT NOCOPY DATE
11: ,p_per_validation_end_date OUT NOCOPY DATE
12: ,p_person_type IN per_person_types.user_person_type%TYPE
5: ,p_person_id OUT NOCOPY per_all_people_f.person_id%TYPE
6: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
7: ,p_legislation_code IN VARCHAR2
8: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
9: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
10: ,p_per_validation_start_date OUT NOCOPY DATE
11: ,p_per_validation_end_date OUT NOCOPY DATE
12: ,p_person_type IN per_person_types.user_person_type%TYPE
13: ,p_system_person_type IN per_person_types.system_person_type%TYPE
10: ,p_per_validation_start_date OUT NOCOPY DATE
11: ,p_per_validation_end_date OUT NOCOPY DATE
12: ,p_person_type IN per_person_types.user_person_type%TYPE
13: ,p_system_person_type IN per_person_types.system_person_type%TYPE
14: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
15: ,p_last_name IN per_all_people_f.last_name%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
11: ,p_per_validation_end_date OUT NOCOPY DATE
12: ,p_person_type IN per_person_types.user_person_type%TYPE
13: ,p_system_person_type IN per_person_types.system_person_type%TYPE
14: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
15: ,p_last_name IN per_all_people_f.last_name%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
12: ,p_person_type IN per_person_types.user_person_type%TYPE
13: ,p_system_person_type IN per_person_types.system_person_type%TYPE
14: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
15: ,p_last_name IN per_all_people_f.last_name%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
13: ,p_system_person_type IN per_person_types.system_person_type%TYPE
14: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
15: ,p_last_name IN per_all_people_f.last_name%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
14: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
15: ,p_last_name IN per_all_people_f.last_name%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
15: ,p_last_name IN per_all_people_f.last_name%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
16: ,p_start_date IN per_all_people_f.start_date%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
17: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
18: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
19: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
20: ,p_blood_type IN per_all_people_f.blood_type%TYPE
21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
43: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
44: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
45: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
46: --
47: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
48: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
44: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
45: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
46: --
47: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
48: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
45: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
46: --
47: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
48: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
46: --
47: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
48: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
47: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
48: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
48: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
49: ,p_email_address IN per_all_people_f.email_address%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
50: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
51: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
52: ,p_first_name IN per_all_people_f.first_name%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
53: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
54: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
55: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
56: ,p_honors IN per_all_people_f.honors%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
57: ,p_internal_location IN per_all_people_f.internal_location%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
58: ,p_known_as IN per_all_people_f.known_as%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
59: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
60: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
61: ,p_mailstop IN per_all_people_f.mailstop%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
62: ,p_marital_status IN per_all_people_f.marital_status%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
63: ,p_middle_names IN per_all_people_f.middle_names%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
64: ,p_nationality IN per_all_people_f.nationality%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
65: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
66: ,p_office_number IN per_all_people_f.office_number%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
67: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
68: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
69: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
70: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
71: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
72: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
73: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
74: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
75: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
76: ,p_sex IN per_all_people_f.sex%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
77: ,p_student_status IN per_all_people_f.student_status%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
78: ,p_suffix IN per_all_people_f.suffix%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
79: ,p_title IN per_all_people_f.title%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
80: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
81: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
82: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
83: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
84: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
85: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
86: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
87: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
88: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
89: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
90: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
91: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
92: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
93: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
94: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
95: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
96: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
97: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
98: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
99: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
100: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
101: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
102: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
103: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
104: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
105: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
106: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
107: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
108: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
109: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
110: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
111: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
112: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
113: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
114: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
115: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
116: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
117: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
118: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
119: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
120: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
121: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
122: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
123: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
124: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
125: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
126: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
127: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
128: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
129: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
130: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
131: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
132: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
133: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
134: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
135: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
136: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
137: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
138: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
139: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
140: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
141: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
142: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
143: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
144: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
145: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
146: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
147: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
148: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
149: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
150: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
151: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
152: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
153: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
154: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
162: ,p_asg_validation_start_date OUT NOCOPY DATE
725: PROCEDURE update_maintain_data
726: (p_effective_date IN DATE
727: ,p_datetrack_update_mode IN VARCHAR2
728: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
729: ,p_person_id IN per_all_people_f.person_id%TYPE
730: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
731: ,p_legislation_code IN VARCHAR2
732: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
733: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
726: (p_effective_date IN DATE
727: ,p_datetrack_update_mode IN VARCHAR2
728: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
729: ,p_person_id IN per_all_people_f.person_id%TYPE
730: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
731: ,p_legislation_code IN VARCHAR2
732: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
733: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
734: ,p_per_validation_start_date OUT NOCOPY DATE
728: ,p_person_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
729: ,p_person_id IN per_all_people_f.person_id%TYPE
730: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
731: ,p_legislation_code IN VARCHAR2
732: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
733: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
734: ,p_per_validation_start_date OUT NOCOPY DATE
735: ,p_per_validation_end_date OUT NOCOPY DATE
736: ,p_person_type IN per_person_types.user_person_type%TYPE
729: ,p_person_id IN per_all_people_f.person_id%TYPE
730: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
731: ,p_legislation_code IN VARCHAR2
732: ,p_per_effective_start_date IN OUT NOCOPY per_all_people_f.effective_start_date%TYPE
733: ,p_per_effective_end_date IN OUT NOCOPY per_all_people_f.effective_end_date%TYPE
734: ,p_per_validation_start_date OUT NOCOPY DATE
735: ,p_per_validation_end_date OUT NOCOPY DATE
736: ,p_person_type IN per_person_types.user_person_type%TYPE
737: ,p_system_person_type IN per_person_types.system_person_type%TYPE
734: ,p_per_validation_start_date OUT NOCOPY DATE
735: ,p_per_validation_end_date OUT NOCOPY DATE
736: ,p_person_type IN per_person_types.user_person_type%TYPE
737: ,p_system_person_type IN per_person_types.system_person_type%TYPE
738: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
739: ,p_last_name IN per_all_people_f.last_name%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
735: ,p_per_validation_end_date OUT NOCOPY DATE
736: ,p_person_type IN per_person_types.user_person_type%TYPE
737: ,p_system_person_type IN per_person_types.system_person_type%TYPE
738: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
739: ,p_last_name IN per_all_people_f.last_name%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
736: ,p_person_type IN per_person_types.user_person_type%TYPE
737: ,p_system_person_type IN per_person_types.system_person_type%TYPE
738: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
739: ,p_last_name IN per_all_people_f.last_name%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
737: ,p_system_person_type IN per_person_types.system_person_type%TYPE
738: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
739: ,p_last_name IN per_all_people_f.last_name%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
738: ,p_person_type_id IN per_all_people_f.person_type_id%TYPE
739: ,p_last_name IN per_all_people_f.last_name%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
739: ,p_last_name IN per_all_people_f.last_name%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
740: ,p_start_date IN per_all_people_f.start_date%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
741: ,p_applicant_number IN per_all_people_f.applicant_number%TYPE
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
742: ,p_background_check_status IN per_all_people_f.background_check_status%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
743: ,p_background_date_check IN per_all_people_f.background_date_check%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
744: ,p_blood_type IN per_all_people_f.blood_type%TYPE
745: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
746: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
747: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
766: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
767: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
768: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
769: --
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
770: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
771: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
772: ,p_email_address IN per_all_people_f.email_address%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
773: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
774: ,p_expense_check_send_to_addres IN per_all_people_f.expense_check_send_to_address%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
775: ,p_first_name IN per_all_people_f.first_name%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
776: ,p_per_fte_capacity IN per_all_people_f.fte_capacity%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
777: ,p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
778: ,p_hold_applicant_date_until IN per_all_people_f.hold_applicant_date_until%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
779: ,p_honors IN per_all_people_f.honors%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
780: ,p_internal_location IN per_all_people_f.internal_location%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
781: ,p_known_as IN per_all_people_f.known_as%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
782: ,p_last_medical_test_by IN per_all_people_f.last_medical_test_by%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
783: ,p_last_medical_test_date IN per_all_people_f.last_medical_test_date%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
784: ,p_mailstop IN per_all_people_f.mailstop%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
785: ,p_marital_status IN per_all_people_f.marital_status%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
786: ,p_middle_names IN per_all_people_f.middle_names%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
787: ,p_nationality IN per_all_people_f.nationality%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
788: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
789: ,p_office_number IN per_all_people_f.office_number%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
790: ,p_on_military_service IN per_all_people_f.on_military_service%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
791: ,p_pre_name_adjunct IN per_all_people_f.pre_name_adjunct%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
792: ,p_previous_last_name IN per_all_people_f.previous_last_name%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
793: ,p_rehire_recommendation IN per_all_people_f.rehire_recommendation%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
794: ,p_rehire_reason IN per_all_people_f.rehire_reason%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
795: ,p_resume_exists IN per_all_people_f.resume_exists%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
796: ,p_resume_last_updated IN per_all_people_f.resume_last_updated%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
797: ,p_registered_disabled_flag IN per_all_people_f.registered_disabled_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
798: ,p_second_passport_exists IN per_all_people_f.second_passport_exists%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
799: ,p_sex IN per_all_people_f.sex%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
800: ,p_student_status IN per_all_people_f.student_status%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
801: ,p_suffix IN per_all_people_f.suffix%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
802: ,p_title IN per_all_people_f.title%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
803: ,p_work_schedule IN per_all_people_f.work_schedule%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
804: ,p_coord_ben_med_pln_no IN per_all_people_f.coord_ben_med_pln_no%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
805: ,p_coord_ben_no_cvg_flag IN per_all_people_f.coord_ben_no_cvg_flag%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
806: ,p_dpdnt_adoption_date IN per_all_people_f.dpdnt_adoption_date%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
807: ,p_dpdnt_vlntry_svce_flag IN per_all_people_f.dpdnt_vlntry_svce_flag%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
808: ,p_receipt_of_death_cert_date IN per_all_people_f.receipt_of_death_cert_date%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
809: ,p_uses_tobacco_flag IN per_all_people_f.uses_tobacco_flag%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
810: ,p_benefit_group_id IN per_all_people_f.benefit_group_id%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
811: ,p_attribute_category IN per_all_people_f.attribute_category%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
812: ,p_attribute1 IN per_all_people_f.attribute1%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
813: ,p_attribute2 IN per_all_people_f.attribute2%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
814: ,p_attribute3 IN per_all_people_f.attribute3%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
815: ,p_attribute4 IN per_all_people_f.attribute4%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
816: ,p_attribute5 IN per_all_people_f.attribute5%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
817: ,p_attribute6 IN per_all_people_f.attribute6%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
818: ,p_attribute7 IN per_all_people_f.attribute7%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
819: ,p_attribute8 IN per_all_people_f.attribute8%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
820: ,p_attribute9 IN per_all_people_f.attribute9%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
821: ,p_attribute10 IN per_all_people_f.attribute10%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
822: ,p_attribute11 IN per_all_people_f.attribute11%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
823: ,p_attribute12 IN per_all_people_f.attribute12%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
824: ,p_attribute13 IN per_all_people_f.attribute13%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
825: ,p_attribute14 IN per_all_people_f.attribute14%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
826: ,p_attribute15 IN per_all_people_f.attribute15%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
827: ,p_attribute16 IN per_all_people_f.attribute16%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
828: ,p_attribute17 IN per_all_people_f.attribute17%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
829: ,p_attribute18 IN per_all_people_f.attribute18%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
830: ,p_attribute19 IN per_all_people_f.attribute19%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
831: ,p_attribute20 IN per_all_people_f.attribute20%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
832: ,p_attribute21 IN per_all_people_f.attribute21%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
833: ,p_attribute22 IN per_all_people_f.attribute22%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
834: ,p_attribute23 IN per_all_people_f.attribute23%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
835: ,p_attribute24 IN per_all_people_f.attribute24%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
836: ,p_attribute25 IN per_all_people_f.attribute25%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
837: ,p_attribute26 IN per_all_people_f.attribute26%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
838: ,p_attribute27 IN per_all_people_f.attribute27%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
839: ,p_attribute28 IN per_all_people_f.attribute28%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
840: ,p_attribute29 IN per_all_people_f.attribute29%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
841: ,p_attribute30 IN per_all_people_f.attribute30%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
842: ,p_per_information_category IN per_all_people_f.per_information_category%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
843: ,p_per_information1 IN per_all_people_f.attribute1%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
844: ,p_per_information2 IN per_all_people_f.attribute2%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
845: ,p_per_information3 IN per_all_people_f.attribute3%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
846: ,p_per_information4 IN per_all_people_f.attribute4%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
847: ,p_per_information5 IN per_all_people_f.attribute5%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
848: ,p_per_information6 IN per_all_people_f.attribute6%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
849: ,p_per_information7 IN per_all_people_f.attribute7%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
850: ,p_per_information8 IN per_all_people_f.attribute8%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
851: ,p_per_information9 IN per_all_people_f.attribute9%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
852: ,p_per_information10 IN per_all_people_f.attribute10%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
853: ,p_per_information11 IN per_all_people_f.attribute11%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
854: ,p_per_information12 IN per_all_people_f.attribute12%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
855: ,p_per_information13 IN per_all_people_f.attribute13%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
856: ,p_per_information14 IN per_all_people_f.attribute14%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
857: ,p_per_information15 IN per_all_people_f.attribute15%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
858: ,p_per_information16 IN per_all_people_f.attribute16%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
859: ,p_per_information17 IN per_all_people_f.attribute17%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
860: ,p_per_information18 IN per_all_people_f.attribute18%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
861: ,p_per_information19 IN per_all_people_f.attribute19%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
862: ,p_per_information20 IN per_all_people_f.attribute20%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
863: ,p_per_information21 IN per_all_people_f.attribute21%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
864: ,p_per_information22 IN per_all_people_f.attribute22%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
865: ,p_per_information23 IN per_all_people_f.attribute23%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
866: ,p_per_information24 IN per_all_people_f.attribute24%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
867: ,p_per_information25 IN per_all_people_f.attribute25%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
868: ,p_per_information26 IN per_all_people_f.attribute26%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
869: ,p_per_information27 IN per_all_people_f.attribute27%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
870: ,p_per_information28 IN per_all_people_f.attribute28%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
871: ,p_per_information29 IN per_all_people_f.attribute29%TYPE
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
872: ,p_per_information30 IN per_all_people_f.attribute30%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
880: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
873: ,p_date_of_death IN per_all_people_f.date_of_death%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
880: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
881: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
874: ,p_original_date_of_hire IN per_all_people_f.original_date_of_hire%TYPE
875: ,p_town_of_birth IN per_all_people_f.town_of_birth%TYPE
876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
880: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
881: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
882: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
1446: PROCEDURE lock_maintain_data
1447: (p_effective_date DATE
1448: ,p_datetrack_update_mode VARCHAR2
1449: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1450: ,p_person_id per_all_people_f.person_id%TYPE
1451: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1452: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1453: ,p_per_validation_start_date OUT NOCOPY DATE
1454: ,p_per_validation_end_date OUT NOCOPY DATE
1447: (p_effective_date DATE
1448: ,p_datetrack_update_mode VARCHAR2
1449: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1450: ,p_person_id per_all_people_f.person_id%TYPE
1451: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1452: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1453: ,p_per_validation_start_date OUT NOCOPY DATE
1454: ,p_per_validation_end_date OUT NOCOPY DATE
1455: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1448: ,p_datetrack_update_mode VARCHAR2
1449: ,p_person_update_allowed VARCHAR2 DEFAULT 'TRUE'
1450: ,p_person_id per_all_people_f.person_id%TYPE
1451: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1452: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1453: ,p_per_validation_start_date OUT NOCOPY DATE
1454: ,p_per_validation_end_date OUT NOCOPY DATE
1455: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1456: --CWK
1451: ,p_per_effective_start_date per_all_people_f.effective_start_date%TYPE
1452: ,p_per_effective_end_date per_all_people_f.effective_end_date%TYPE
1453: ,p_per_validation_start_date OUT NOCOPY DATE
1454: ,p_per_validation_end_date OUT NOCOPY DATE
1455: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
1456: --CWK
1457: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
1458: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
1459: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE