72: g_prev_upd_adr_address_id per_addresses.address_id%type;
73: -- g_prev_upd_adr_last_update_login
74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
73: -- g_prev_upd_adr_last_update_login
74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
144: );
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
144: );
145: --
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
144: );
145: --
146: Type g_cont_rec_type is RECORD
257: ,update_mode varchar2(20)
258: );
259: ---
260: Type g_per_pay_rec_type is RECORD
261: (PERSON_ID per_all_people_f.person_id%type
262: ,BUSINESS_GROUP_ID per_pay_proposals.BUSINESS_GROUP_ID%type
263: ,PAY_PROPOSAL_ID per_pay_proposals.assignment_id%type
264: ,OBJECT_VERSION_NUMBER per_pay_proposals.OBJECT_VERSION_NUMBER%type
265: ,ASSIGNMENT_ID per_pay_proposals.ASSIGNMENT_ID%type
329: Type per_dis_rec_type is RECORD
330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type