eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_API dependencies on PER_PEOPLE_EXTRA_INFO

Line 150: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

146: );
147: --
148: type per_sf52_type is record
149: (per_sf52_flag varchar2(1)
150: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
151: ,object_version_number per_people_extra_info.object_version_number%type
152: ,citizenship per_people_extra_info.pei_information3%type
153: ,veterans_preference per_people_extra_info.pei_information4%type
154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type

Line 151: ,object_version_number per_people_extra_info.object_version_number%type

147: --
148: type per_sf52_type is record
149: (per_sf52_flag varchar2(1)
150: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
151: ,object_version_number per_people_extra_info.object_version_number%type
152: ,citizenship per_people_extra_info.pei_information3%type
153: ,veterans_preference per_people_extra_info.pei_information4%type
154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
155: ,veterans_status per_people_extra_info.pei_information6%type);

Line 152: ,citizenship per_people_extra_info.pei_information3%type

148: type per_sf52_type is record
149: (per_sf52_flag varchar2(1)
150: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
151: ,object_version_number per_people_extra_info.object_version_number%type
152: ,citizenship per_people_extra_info.pei_information3%type
153: ,veterans_preference per_people_extra_info.pei_information4%type
154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
155: ,veterans_status per_people_extra_info.pei_information6%type);
156: --

Line 153: ,veterans_preference per_people_extra_info.pei_information4%type

149: (per_sf52_flag varchar2(1)
150: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
151: ,object_version_number per_people_extra_info.object_version_number%type
152: ,citizenship per_people_extra_info.pei_information3%type
153: ,veterans_preference per_people_extra_info.pei_information4%type
154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
155: ,veterans_status per_people_extra_info.pei_information6%type);
156: --
157: -- Bug#4486823 added retention_incentive_review_date

Line 154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type

150: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
151: ,object_version_number per_people_extra_info.object_version_number%type
152: ,citizenship per_people_extra_info.pei_information3%type
153: ,veterans_preference per_people_extra_info.pei_information4%type
154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
155: ,veterans_status per_people_extra_info.pei_information6%type);
156: --
157: -- Bug#4486823 added retention_incentive_review_date
158: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2

Line 155: ,veterans_status per_people_extra_info.pei_information6%type);

151: ,object_version_number per_people_extra_info.object_version_number%type
152: ,citizenship per_people_extra_info.pei_information3%type
153: ,veterans_preference per_people_extra_info.pei_information4%type
154: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
155: ,veterans_status per_people_extra_info.pei_information6%type);
156: --
157: -- Bug#4486823 added retention_incentive_review_date
158: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2
159: type per_group1_type is record

Line 161: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

157: -- Bug#4486823 added retention_incentive_review_date
158: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2
159: type per_group1_type is record
160: ( per_group1_flag varchar2(1)
161: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
162: ,object_version_number per_people_extra_info.object_version_number%type
163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type

Line 162: ,object_version_number per_people_extra_info.object_version_number%type

158: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2
159: type per_group1_type is record
160: ( per_group1_flag varchar2(1)
161: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
162: ,object_version_number per_people_extra_info.object_version_number%type
163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type

Line 163: ,appointment_type per_people_extra_info.pei_information3%type

159: type per_group1_type is record
160: ( per_group1_flag varchar2(1)
161: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
162: ,object_version_number per_people_extra_info.object_version_number%type
163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type

Line 164: ,type_of_employment per_people_extra_info.pei_information4%type

160: ( per_group1_flag varchar2(1)
161: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
162: ,object_version_number per_people_extra_info.object_version_number%type
163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type

Line 165: ,race_national_origin per_people_extra_info.pei_information5%type

161: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
162: ,object_version_number per_people_extra_info.object_version_number%type
163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type

Line 166: ,date_last_promotion per_people_extra_info.pei_information6%type

162: ,object_version_number per_people_extra_info.object_version_number%type
163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type

Line 167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type

163: ,appointment_type per_people_extra_info.pei_information3%type
164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type

Line 168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type

164: ,type_of_employment per_people_extra_info.pei_information4%type
165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type

Line 169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type

165: ,race_national_origin per_people_extra_info.pei_information5%type
166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type

Line 170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type

166: ,date_last_promotion per_people_extra_info.pei_information6%type
167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type

Line 171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type

167: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type

Line 172: ,country_world_citizenship per_people_extra_info.pei_information10%type

168: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type

Line 173: ,handicap_code per_people_extra_info.pei_information11%type

169: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type

Line 174: ,consent_id per_people_extra_info.pei_information12%type

170: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type

Line 175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type

171: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type
179: ,family_member_status per_people_extra_info.pei_information17%type

Line 176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type

172: ,country_world_citizenship per_people_extra_info.pei_information10%type
173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type
179: ,family_member_status per_people_extra_info.pei_information17%type
180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);

Line 177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type

173: ,handicap_code per_people_extra_info.pei_information11%type
174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type
179: ,family_member_status per_people_extra_info.pei_information17%type
180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
181: --

Line 178: ,family_member_emp_pref per_people_extra_info.pei_information16%type

174: ,consent_id per_people_extra_info.pei_information12%type
175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type
179: ,family_member_status per_people_extra_info.pei_information17%type
180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
181: --
182: type per_group2_type is record

Line 179: ,family_member_status per_people_extra_info.pei_information17%type

175: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type
179: ,family_member_status per_people_extra_info.pei_information17%type
180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
181: --
182: type per_group2_type is record
183: (per_group2_flag varchar2(1)

Line 180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);

176: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
177: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
178: ,family_member_emp_pref per_people_extra_info.pei_information16%type
179: ,family_member_status per_people_extra_info.pei_information17%type
180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
181: --
182: type per_group2_type is record
183: (per_group2_flag varchar2(1)
184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

180: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
181: --
182: type per_group2_type is record
183: (per_group2_flag varchar2(1)
184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
185: ,object_version_number per_people_extra_info.object_version_number%type
186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type

Line 185: ,object_version_number per_people_extra_info.object_version_number%type

181: --
182: type per_group2_type is record
183: (per_group2_flag varchar2(1)
184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
185: ,object_version_number per_people_extra_info.object_version_number%type
186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type

Line 186: ,obligated_position_number per_people_extra_info.pei_information3%type

182: type per_group2_type is record
183: (per_group2_flag varchar2(1)
184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
185: ,object_version_number per_people_extra_info.object_version_number%type
186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type

Line 187: ,obligated_position_type per_people_extra_info.pei_information4%type

183: (per_group2_flag varchar2(1)
184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
185: ,object_version_number per_people_extra_info.object_version_number%type
186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type

Line 188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type

184: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
185: ,object_version_number per_people_extra_info.object_version_number%type
186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type

Line 189: ,date_return_rights_expires per_people_extra_info.pei_information6%type

185: ,object_version_number per_people_extra_info.object_version_number%type
186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
193: ,draw_down_action_id per_people_extra_info.pei_information10%type);

Line 190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type

186: ,obligated_position_number per_people_extra_info.pei_information3%type
187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
193: ,draw_down_action_id per_people_extra_info.pei_information10%type);
194: --

Line 191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type

187: ,obligated_position_type per_people_extra_info.pei_information4%type
188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
193: ,draw_down_action_id per_people_extra_info.pei_information10%type);
194: --
195: -- 4352589 BEN_EIT Created new benefits EIT Type

Line 192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type

188: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
193: ,draw_down_action_id per_people_extra_info.pei_information10%type);
194: --
195: -- 4352589 BEN_EIT Created new benefits EIT Type
196: type per_benefit_info_type is record

Line 193: ,draw_down_action_id per_people_extra_info.pei_information10%type);

189: ,date_return_rights_expires per_people_extra_info.pei_information6%type
190: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
191: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
192: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
193: ,draw_down_action_id per_people_extra_info.pei_information10%type);
194: --
195: -- 4352589 BEN_EIT Created new benefits EIT Type
196: type per_benefit_info_type is record
197: ( per_benefit_info_flag varchar2(1)

Line 198: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

194: --
195: -- 4352589 BEN_EIT Created new benefits EIT Type
196: type per_benefit_info_type is record
197: ( per_benefit_info_flag varchar2(1)
198: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
199: ,object_version_number per_people_extra_info.object_version_number%type
200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type

Line 199: ,object_version_number per_people_extra_info.object_version_number%type

195: -- 4352589 BEN_EIT Created new benefits EIT Type
196: type per_benefit_info_type is record
197: ( per_benefit_info_flag varchar2(1)
198: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
199: ,object_version_number per_people_extra_info.object_version_number%type
200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type

Line 200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type

196: type per_benefit_info_type is record
197: ( per_benefit_info_flag varchar2(1)
198: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
199: ,object_version_number per_people_extra_info.object_version_number%type
200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type

Line 201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type

197: ( per_benefit_info_flag varchar2(1)
198: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
199: ,object_version_number per_people_extra_info.object_version_number%type
200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type

Line 202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type

198: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
199: ,object_version_number per_people_extra_info.object_version_number%type
200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type

Line 203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type

199: ,object_version_number per_people_extra_info.object_version_number%type
200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type

Line 204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type

200: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type

Line 205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type

201: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type

Line 206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type

202: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type

Line 207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type

203: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type

Line 208: ,FERS_Election_Date per_people_extra_info.pei_information12%type

204: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info

Line 209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type

205: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type

Line 210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type

206: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type

Line 211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type

207: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
208: ,FERS_Election_Date per_people_extra_info.pei_information12%type
209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type

Line 213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type

209: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
216: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);

Line 214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type

210: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
216: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
218: --

Line 215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type

211: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
216: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
218: --
219: type per_scd_info_type is record

Line 216: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type

212: -- 6312144 addition of new segments related to per_benefit_info
213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
216: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
218: --
219: type per_scd_info_type is record
220: (per_scd_info_flag varchar2(1)

Line 217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);

213: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
214: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
215: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
216: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
218: --
219: type per_scd_info_type is record
220: (per_scd_info_flag varchar2(1)
221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

217: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
218: --
219: type per_scd_info_type is record
220: (per_scd_info_flag varchar2(1)
221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
222: ,object_version_number per_people_extra_info.object_version_number%type
223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type

Line 222: ,object_version_number per_people_extra_info.object_version_number%type

218: --
219: type per_scd_info_type is record
220: (per_scd_info_flag varchar2(1)
221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
222: ,object_version_number per_people_extra_info.object_version_number%type
223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type

Line 223: ,scd_leave per_people_extra_info.pei_information3%type

219: type per_scd_info_type is record
220: (per_scd_info_flag varchar2(1)
221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
222: ,object_version_number per_people_extra_info.object_version_number%type
223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type

Line 224: ,scd_civilian per_people_extra_info.pei_information4%type

220: (per_scd_info_flag varchar2(1)
221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
222: ,object_version_number per_people_extra_info.object_version_number%type
223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type
228: -- Bug 4164083 eHRI New Attributions

Line 225: ,scd_rif per_people_extra_info.pei_information5%type

221: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
222: ,object_version_number per_people_extra_info.object_version_number%type
223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type
228: -- Bug 4164083 eHRI New Attributions
229: ,scd_ses per_people_extra_info.pei_information10%type

Line 226: ,scd_tsp per_people_extra_info.pei_information6%type

222: ,object_version_number per_people_extra_info.object_version_number%type
223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type
228: -- Bug 4164083 eHRI New Attributions
229: ,scd_ses per_people_extra_info.pei_information10%type
230: ,scd_spl_retirement per_people_extra_info.pei_information11%type

Line 227: ,scd_retirement per_people_extra_info.pei_information7%type

223: ,scd_leave per_people_extra_info.pei_information3%type
224: ,scd_civilian per_people_extra_info.pei_information4%type
225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type
228: -- Bug 4164083 eHRI New Attributions
229: ,scd_ses per_people_extra_info.pei_information10%type
230: ,scd_spl_retirement per_people_extra_info.pei_information11%type
231: -- End Bug 4164083

Line 229: ,scd_ses per_people_extra_info.pei_information10%type

225: ,scd_rif per_people_extra_info.pei_information5%type
226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type
228: -- Bug 4164083 eHRI New Attributions
229: ,scd_ses per_people_extra_info.pei_information10%type
230: ,scd_spl_retirement per_people_extra_info.pei_information11%type
231: -- End Bug 4164083
232: --Bug 4443968
233: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type

Line 230: ,scd_spl_retirement per_people_extra_info.pei_information11%type

226: ,scd_tsp per_people_extra_info.pei_information6%type
227: ,scd_retirement per_people_extra_info.pei_information7%type
228: -- Bug 4164083 eHRI New Attributions
229: ,scd_ses per_people_extra_info.pei_information10%type
230: ,scd_spl_retirement per_people_extra_info.pei_information11%type
231: -- End Bug 4164083
232: --Bug 4443968
233: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type
234: );

Line 233: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type

229: ,scd_ses per_people_extra_info.pei_information10%type
230: ,scd_spl_retirement per_people_extra_info.pei_information11%type
231: -- End Bug 4164083
232: --Bug 4443968
233: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type
234: );
235: --
236: type per_probations_type is record
237: (per_probation_flag varchar2(1)

Line 238: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

234: );
235: --
236: type per_probations_type is record
237: (per_probation_flag varchar2(1)
238: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
239: ,object_version_number per_people_extra_info.object_version_number%type
240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575

Line 239: ,object_version_number per_people_extra_info.object_version_number%type

235: --
236: type per_probations_type is record
237: (per_probation_flag varchar2(1)
238: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
239: ,object_version_number per_people_extra_info.object_version_number%type
240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type

Line 240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type

236: type per_probations_type is record
237: (per_probation_flag varchar2(1)
238: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
239: ,object_version_number per_people_extra_info.object_version_number%type
240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type

Line 241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type

237: (per_probation_flag varchar2(1)
238: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
239: ,object_version_number per_people_extra_info.object_version_number%type
240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);

Line 242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575

238: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
239: ,object_version_number per_people_extra_info.object_version_number%type
240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
246: --

Line 243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type

239: ,object_version_number per_people_extra_info.object_version_number%type
240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
246: --
247: type per_retained_grade_type is record

Line 244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type

240: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
246: --
247: type per_retained_grade_type is record
248: (per_retained_grade_flag varchar2(1)

Line 245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);

241: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
242: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
243: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
244: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
246: --
247: type per_retained_grade_type is record
248: (per_retained_grade_flag varchar2(1)
249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

245: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
246: --
247: type per_retained_grade_type is record
248: (per_retained_grade_flag varchar2(1)
249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
250: ,object_version_number per_people_extra_info.object_version_number%type
251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type

Line 250: ,object_version_number per_people_extra_info.object_version_number%type

246: --
247: type per_retained_grade_type is record
248: (per_retained_grade_flag varchar2(1)
249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
250: ,object_version_number per_people_extra_info.object_version_number%type
251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type

Line 251: ,date_from per_people_extra_info.pei_information1%type

247: type per_retained_grade_type is record
248: (per_retained_grade_flag varchar2(1)
249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
250: ,object_version_number per_people_extra_info.object_version_number%type
251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type

Line 252: ,date_to per_people_extra_info.pei_information2%type

248: (per_retained_grade_flag varchar2(1)
249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
250: ,object_version_number per_people_extra_info.object_version_number%type
251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type

Line 253: ,retain_grade per_people_extra_info.pei_information3%type

249: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
250: ,object_version_number per_people_extra_info.object_version_number%type
251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type

Line 254: ,retain_step_or_rate per_people_extra_info.pei_information4%type

250: ,object_version_number per_people_extra_info.object_version_number%type
251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type
258: ,retain_pay_basis per_people_extra_info.pei_information8%type

Line 255: ,retain_pay_plan per_people_extra_info.pei_information5%type

251: ,date_from per_people_extra_info.pei_information1%type
252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type
258: ,retain_pay_basis per_people_extra_info.pei_information8%type
259: ,temp_step per_people_extra_info.pei_information9%type

Line 256: ,retain_pay_table_id per_people_extra_info.pei_information6%type

252: ,date_to per_people_extra_info.pei_information2%type
253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type
258: ,retain_pay_basis per_people_extra_info.pei_information8%type
259: ,temp_step per_people_extra_info.pei_information9%type
260: );

Line 257: ,retain_locality_percent per_people_extra_info.pei_information7%type

253: ,retain_grade per_people_extra_info.pei_information3%type
254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type
258: ,retain_pay_basis per_people_extra_info.pei_information8%type
259: ,temp_step per_people_extra_info.pei_information9%type
260: );
261: --

Line 258: ,retain_pay_basis per_people_extra_info.pei_information8%type

254: ,retain_step_or_rate per_people_extra_info.pei_information4%type
255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type
258: ,retain_pay_basis per_people_extra_info.pei_information8%type
259: ,temp_step per_people_extra_info.pei_information9%type
260: );
261: --
262: type per_sep_retire_type is record

Line 259: ,temp_step per_people_extra_info.pei_information9%type

255: ,retain_pay_plan per_people_extra_info.pei_information5%type
256: ,retain_pay_table_id per_people_extra_info.pei_information6%type
257: ,retain_locality_percent per_people_extra_info.pei_information7%type
258: ,retain_pay_basis per_people_extra_info.pei_information8%type
259: ,temp_step per_people_extra_info.pei_information9%type
260: );
261: --
262: type per_sep_retire_type is record
263: (per_sep_retire_flag varchar2(1)

Line 264: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

260: );
261: --
262: type per_sep_retire_type is record
263: (per_sep_retire_flag varchar2(1)
264: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
265: ,object_version_number per_people_extra_info.object_version_number%type
266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type

Line 265: ,object_version_number per_people_extra_info.object_version_number%type

261: --
262: type per_sep_retire_type is record
263: (per_sep_retire_flag varchar2(1)
264: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
265: ,object_version_number per_people_extra_info.object_version_number%type
266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type

Line 266: ,fers_coverage per_people_extra_info.pei_information3%type

262: type per_sep_retire_type is record
263: (per_sep_retire_flag varchar2(1)
264: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
265: ,object_version_number per_people_extra_info.object_version_number%type
266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type

Line 267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type

263: (per_sep_retire_flag varchar2(1)
264: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
265: ,object_version_number per_people_extra_info.object_version_number%type
266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type

Line 268: ,frozen_service per_people_extra_info.pei_information5%type

264: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
265: ,object_version_number per_people_extra_info.object_version_number%type
266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type

Line 269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type

265: ,object_version_number per_people_extra_info.object_version_number%type
266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type

Line 270: ,reason_for_separation per_people_extra_info.pei_information7%type

266: ,fers_coverage per_people_extra_info.pei_information3%type
267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type

Line 271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type

267: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type

Line 272: ,date_projected_retirement per_people_extra_info.pei_information9%type

268: ,frozen_service per_people_extra_info.pei_information5%type
269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type

Line 273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type

269: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type

Line 274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type

270: ,reason_for_separation per_people_extra_info.pei_information7%type
271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type

Line 275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type

271: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type

Line 276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type

272: ,date_projected_retirement per_people_extra_info.pei_information9%type
273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);

Line 277: ,date_ret_appl_received per_people_extra_info.pei_information14%type

273: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
281: --

Line 278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type

274: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
281: --
282: type per_security_type is record

Line 279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type

275: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
281: --
282: type per_security_type is record
283: (per_security_flag varchar2(1)

Line 280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);

276: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
277: ,date_ret_appl_received per_people_extra_info.pei_information14%type
278: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
279: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
281: --
282: type per_security_type is record
283: (per_security_flag varchar2(1)
284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

280: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
281: --
282: type per_security_type is record
283: (per_security_flag varchar2(1)
284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
285: ,object_version_number per_people_extra_info.object_version_number%type
286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type

Line 285: ,object_version_number per_people_extra_info.object_version_number%type

281: --
282: type per_security_type is record
283: (per_security_flag varchar2(1)
284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
285: ,object_version_number per_people_extra_info.object_version_number%type
286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type

Line 286: ,sec_investigation_basis per_people_extra_info.pei_information3%type

282: type per_security_type is record
283: (per_security_flag varchar2(1)
284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
285: ,object_version_number per_people_extra_info.object_version_number%type
286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type

Line 287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type

283: (per_security_flag varchar2(1)
284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
285: ,object_version_number per_people_extra_info.object_version_number%type
286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type

Line 288: ,date_sec_invest_required per_people_extra_info.pei_information5%type

284: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
285: ,object_version_number per_people_extra_info.object_version_number%type
286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
292: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);

Line 289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type

285: ,object_version_number per_people_extra_info.object_version_number%type
286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
292: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
293: --

Line 290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type

286: ,sec_investigation_basis per_people_extra_info.pei_information3%type
287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
292: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
293: --
294: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record

Line 291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type

287: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
292: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
293: --
294: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
295: type per_service_oblig_type is record

Line 292: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);

288: ,date_sec_invest_required per_people_extra_info.pei_information5%type
289: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
290: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
291: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
292: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
293: --
294: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
295: type per_service_oblig_type is record
296: (per_service_oblig_flag varchar2(1)

Line 297: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

293: --
294: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
295: type per_service_oblig_type is record
296: (per_service_oblig_flag varchar2(1)
297: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
298: ,object_version_number per_people_extra_info.object_version_number%type
299: ,service_oblig_type_code per_people_extra_info.pei_information3%type
300: ,service_oblig_start_date per_people_extra_info.pei_information4%type
301: ,service_oblig_end_date per_people_extra_info.pei_information5%type);

Line 298: ,object_version_number per_people_extra_info.object_version_number%type

294: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
295: type per_service_oblig_type is record
296: (per_service_oblig_flag varchar2(1)
297: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
298: ,object_version_number per_people_extra_info.object_version_number%type
299: ,service_oblig_type_code per_people_extra_info.pei_information3%type
300: ,service_oblig_start_date per_people_extra_info.pei_information4%type
301: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
302: --

Line 299: ,service_oblig_type_code per_people_extra_info.pei_information3%type

295: type per_service_oblig_type is record
296: (per_service_oblig_flag varchar2(1)
297: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
298: ,object_version_number per_people_extra_info.object_version_number%type
299: ,service_oblig_type_code per_people_extra_info.pei_information3%type
300: ,service_oblig_start_date per_people_extra_info.pei_information4%type
301: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
302: --
303: -- modified 10/24/97

Line 300: ,service_oblig_start_date per_people_extra_info.pei_information4%type

296: (per_service_oblig_flag varchar2(1)
297: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
298: ,object_version_number per_people_extra_info.object_version_number%type
299: ,service_oblig_type_code per_people_extra_info.pei_information3%type
300: ,service_oblig_start_date per_people_extra_info.pei_information4%type
301: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
302: --
303: -- modified 10/24/97
304: type per_conversions_type is record

Line 301: ,service_oblig_end_date per_people_extra_info.pei_information5%type);

297: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
298: ,object_version_number per_people_extra_info.object_version_number%type
299: ,service_oblig_type_code per_people_extra_info.pei_information3%type
300: ,service_oblig_start_date per_people_extra_info.pei_information4%type
301: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
302: --
303: -- modified 10/24/97
304: type per_conversions_type is record
305: (per_conversions_flag varchar2(1)

Line 306: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

302: --
303: -- modified 10/24/97
304: type per_conversions_type is record
305: (per_conversions_flag varchar2(1)
306: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
307: ,object_version_number per_people_extra_info.object_version_number%type
308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type

Line 307: ,object_version_number per_people_extra_info.object_version_number%type

303: -- modified 10/24/97
304: type per_conversions_type is record
305: (per_conversions_flag varchar2(1)
306: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
307: ,object_version_number per_people_extra_info.object_version_number%type
308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type

Line 308: ,date_conv_career_begins per_people_extra_info.pei_information3%type

304: type per_conversions_type is record
305: (per_conversions_flag varchar2(1)
306: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
307: ,object_version_number per_people_extra_info.object_version_number%type
308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
312: ,date_vra_conv_due per_people_extra_info.pei_information6%type);

Line 309: ,date_conv_career_due per_people_extra_info.pei_information4%type

305: (per_conversions_flag varchar2(1)
306: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
307: ,object_version_number per_people_extra_info.object_version_number%type
308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
312: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
313: --Bug# 4588575 Segments are wrongly defined. modified the same

Line 310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type

306: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
307: ,object_version_number per_people_extra_info.object_version_number%type
308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
312: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
313: --Bug# 4588575 Segments are wrongly defined. modified the same
314:

Line 311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type

307: ,object_version_number per_people_extra_info.object_version_number%type
308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
312: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
313: --Bug# 4588575 Segments are wrongly defined. modified the same
314:
315: --

Line 312: ,date_vra_conv_due per_people_extra_info.pei_information6%type);

308: ,date_conv_career_begins per_people_extra_info.pei_information3%type
309: ,date_conv_career_due per_people_extra_info.pei_information4%type
310: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
311: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
312: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
313: --Bug# 4588575 Segments are wrongly defined. modified the same
314:
315: --
316: type per_uniformed_services_type is record

Line 318: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

314:
315: --
316: type per_uniformed_services_type is record
317: (per_uniformed_services_flag varchar2(1)
318: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
319: ,object_version_number per_people_extra_info.object_version_number%type
320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type

Line 319: ,object_version_number per_people_extra_info.object_version_number%type

315: --
316: type per_uniformed_services_type is record
317: (per_uniformed_services_flag varchar2(1)
318: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
319: ,object_version_number per_people_extra_info.object_version_number%type
320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type

Line 320: ,reserve_category per_people_extra_info.pei_information3%type

316: type per_uniformed_services_type is record
317: (per_uniformed_services_flag varchar2(1)
318: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
319: ,object_version_number per_people_extra_info.object_version_number%type
320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type

Line 321: ,military_recall_status per_people_extra_info.pei_information4%type

317: (per_uniformed_services_flag varchar2(1)
318: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
319: ,object_version_number per_people_extra_info.object_version_number%type
320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type

Line 322: ,creditable_military_service per_people_extra_info.pei_information5%type

318: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
319: ,object_version_number per_people_extra_info.object_version_number%type
320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type

Line 323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type

319: ,object_version_number per_people_extra_info.object_version_number%type
320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type
327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type

Line 324: ,uniform_service_component per_people_extra_info.pei_information7%type

320: ,reserve_category per_people_extra_info.pei_information3%type
321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type
327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);

Line 325: ,uniform_service_designation per_people_extra_info.pei_information8%type

321: ,military_recall_status per_people_extra_info.pei_information4%type
322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type
327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
329: --

Line 326: ,retirement_grade per_people_extra_info.pei_information9%type

322: ,creditable_military_service per_people_extra_info.pei_information5%type
323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type
327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
329: --
330: type pos_valid_grade_type is record

Line 327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type

323: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type
327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
329: --
330: type pos_valid_grade_type is record
331: (pos_valid_grade_flag varchar2(1)

Line 328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);

324: ,uniform_service_component per_people_extra_info.pei_information7%type
325: ,uniform_service_designation per_people_extra_info.pei_information8%type
326: ,retirement_grade per_people_extra_info.pei_information9%type
327: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
329: --
330: type pos_valid_grade_type is record
331: (pos_valid_grade_flag varchar2(1)
332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 609: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

605:
606: -- added by skutteti on 3-mar-98
607: type par_term_retained_grade_type is record
608: (par_term_retained_grade_flag varchar2(1)
609: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
610: ,object_version_number per_people_extra_info.object_version_number%type
611: );
612: --
613: type entitlement_type is record

Line 610: ,object_version_number per_people_extra_info.object_version_number%type

606: -- added by skutteti on 3-mar-98
607: type par_term_retained_grade_type is record
608: (par_term_retained_grade_flag varchar2(1)
609: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
610: ,object_version_number per_people_extra_info.object_version_number%type
611: );
612: --
613: type entitlement_type is record
614: (entitlement_flag varchar2(1)

Line 800: person_extra_info_id per_people_extra_info.person_extra_info_id%type,

796:
797: -- Bug 4724337 Race or National Origin changes
798: type per_race_ethnic_type is record
799: ( p_race_ethnic_info_flag varchar2(1),
800: person_extra_info_id per_people_extra_info.person_extra_info_id%type,
801: object_version_number per_people_extra_info.object_version_number%type,
802: p_hispanic varchar2(1),
803: p_american_indian varchar2(1),
804: p_asian varchar2(1),

Line 801: object_version_number per_people_extra_info.object_version_number%type,

797: -- Bug 4724337 Race or National Origin changes
798: type per_race_ethnic_type is record
799: ( p_race_ethnic_info_flag varchar2(1),
800: person_extra_info_id per_people_extra_info.person_extra_info_id%type,
801: object_version_number per_people_extra_info.object_version_number%type,
802: p_hispanic varchar2(1),
803: p_american_indian varchar2(1),
804: p_asian varchar2(1),
805: p_black_afr_american varchar2(1),

Line 814: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

810:
811: -- 6312144 IPA Benefits Continuation EIT changes
812: type per_ipa_ben_cont_info_type is record
813: ( per_ben_cont_info_flag varchar2(1)
814: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
815: ,object_version_number per_people_extra_info.object_version_number%type
816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type

Line 815: ,object_version_number per_people_extra_info.object_version_number%type

811: -- 6312144 IPA Benefits Continuation EIT changes
812: type per_ipa_ben_cont_info_type is record
813: ( per_ben_cont_info_flag varchar2(1)
814: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
815: ,object_version_number per_people_extra_info.object_version_number%type
816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type

Line 816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type

812: type per_ipa_ben_cont_info_type is record
813: ( per_ben_cont_info_flag varchar2(1)
814: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
815: ,object_version_number per_people_extra_info.object_version_number%type
816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type

Line 817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type

813: ( per_ben_cont_info_flag varchar2(1)
814: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
815: ,object_version_number per_people_extra_info.object_version_number%type
816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type

Line 818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type

814: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
815: ,object_version_number per_people_extra_info.object_version_number%type
816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type

Line 819: ,FEHB_Indicator per_people_extra_info.pei_information4%type

815: ,object_version_number per_people_extra_info.object_version_number%type
816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type

Line 820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type

816: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type

Line 821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type

817: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type

Line 822: ,Retirement_Indicator per_people_extra_info.pei_information7%type

818: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type

Line 823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type

819: ,FEHB_Indicator per_people_extra_info.pei_information4%type
820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
827: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);

Line 824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type

820: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
827: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
828:

Line 825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type

821: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
827: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
828:
829: -- 6312144 Retirement System information

Line 826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type

822: ,Retirement_Indicator per_people_extra_info.pei_information7%type
823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
827: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
828:
829: -- 6312144 Retirement System information
830: type per_retirement_info_type is record

Line 827: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);

823: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
824: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
825: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
826: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
827: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
828:
829: -- 6312144 Retirement System information
830: type per_retirement_info_type is record
831: (per_retirement_info_flag varchar2(1)

Line 832: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

828:
829: -- 6312144 Retirement System information
830: type per_retirement_info_type is record
831: (per_retirement_info_flag varchar2(1)
832: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
833: ,object_version_number per_people_extra_info.object_version_number%type
834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type

Line 833: ,object_version_number per_people_extra_info.object_version_number%type

829: -- 6312144 Retirement System information
830: type per_retirement_info_type is record
831: (per_retirement_info_flag varchar2(1)
832: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
833: ,object_version_number per_people_extra_info.object_version_number%type
834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type

Line 834: ,special_population_code per_people_extra_info.pei_information1%type

830: type per_retirement_info_type is record
831: (per_retirement_info_flag varchar2(1)
832: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
833: ,object_version_number per_people_extra_info.object_version_number%type
834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
838: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);

Line 835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type

831: (per_retirement_info_flag varchar2(1)
832: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
833: ,object_version_number per_people_extra_info.object_version_number%type
834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
838: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
839:

Line 836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type

832: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
833: ,object_version_number per_people_extra_info.object_version_number%type
834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
838: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
839:
840:

Line 837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type

833: ,object_version_number per_people_extra_info.object_version_number%type
834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
838: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
839:
840:
841:

Line 838: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);

834: ,special_population_code per_people_extra_info.pei_information1%type
835: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
836: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
837: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
838: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
839:
840:
841:
842: