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 174: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

170: );
171: --
172: type per_sf52_type is record
173: (per_sf52_flag varchar2(1)
174: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
175: ,object_version_number per_people_extra_info.object_version_number%type
176: ,citizenship per_people_extra_info.pei_information3%type
177: ,veterans_preference per_people_extra_info.pei_information4%type
178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type

Line 175: ,object_version_number per_people_extra_info.object_version_number%type

171: --
172: type per_sf52_type is record
173: (per_sf52_flag varchar2(1)
174: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
175: ,object_version_number per_people_extra_info.object_version_number%type
176: ,citizenship per_people_extra_info.pei_information3%type
177: ,veterans_preference per_people_extra_info.pei_information4%type
178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
179: ,veterans_status per_people_extra_info.pei_information6%type);

Line 176: ,citizenship per_people_extra_info.pei_information3%type

172: type per_sf52_type is record
173: (per_sf52_flag varchar2(1)
174: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
175: ,object_version_number per_people_extra_info.object_version_number%type
176: ,citizenship per_people_extra_info.pei_information3%type
177: ,veterans_preference per_people_extra_info.pei_information4%type
178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
179: ,veterans_status per_people_extra_info.pei_information6%type);
180: --

Line 177: ,veterans_preference per_people_extra_info.pei_information4%type

173: (per_sf52_flag varchar2(1)
174: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
175: ,object_version_number per_people_extra_info.object_version_number%type
176: ,citizenship per_people_extra_info.pei_information3%type
177: ,veterans_preference per_people_extra_info.pei_information4%type
178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
179: ,veterans_status per_people_extra_info.pei_information6%type);
180: --
181: -- Bug#4486823 added retention_incentive_review_date

Line 178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type

174: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
175: ,object_version_number per_people_extra_info.object_version_number%type
176: ,citizenship per_people_extra_info.pei_information3%type
177: ,veterans_preference per_people_extra_info.pei_information4%type
178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
179: ,veterans_status per_people_extra_info.pei_information6%type);
180: --
181: -- Bug#4486823 added retention_incentive_review_date
182: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2

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

175: ,object_version_number per_people_extra_info.object_version_number%type
176: ,citizenship per_people_extra_info.pei_information3%type
177: ,veterans_preference per_people_extra_info.pei_information4%type
178: ,veterans_preference_for_rif per_people_extra_info.pei_information5%type
179: ,veterans_status per_people_extra_info.pei_information6%type);
180: --
181: -- Bug#4486823 added retention_incentive_review_date
182: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2
183: type per_group1_type is record

Line 185: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

181: -- Bug#4486823 added retention_incentive_review_date
182: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2
183: type per_group1_type is record
184: ( per_group1_flag varchar2(1)
185: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
186: ,object_version_number per_people_extra_info.object_version_number%type
187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type

Line 186: ,object_version_number per_people_extra_info.object_version_number%type

182: -- --Bug# 4941984(AFHR2) added columns org_appointment_desc1,org_appointment_desc2
183: type per_group1_type is record
184: ( per_group1_flag varchar2(1)
185: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
186: ,object_version_number per_people_extra_info.object_version_number%type
187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type

Line 187: ,appointment_type per_people_extra_info.pei_information3%type

183: type per_group1_type is record
184: ( per_group1_flag varchar2(1)
185: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
186: ,object_version_number per_people_extra_info.object_version_number%type
187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085

Line 188: ,type_of_employment per_people_extra_info.pei_information4%type

184: ( per_group1_flag varchar2(1)
185: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
186: ,object_version_number per_people_extra_info.object_version_number%type
187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type

Line 189: ,race_national_origin per_people_extra_info.pei_information5%type

185: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
186: ,object_version_number per_people_extra_info.object_version_number%type
187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type

Line 190: ,date_last_promotion per_people_extra_info.pei_information6%type

186: ,object_version_number per_people_extra_info.object_version_number%type
187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type

Line 191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085

187: ,appointment_type per_people_extra_info.pei_information3%type
188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type

Line 192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type

188: ,type_of_employment per_people_extra_info.pei_information4%type
189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type

Line 193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type

189: ,race_national_origin per_people_extra_info.pei_information5%type
190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type

Line 194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type

190: ,date_last_promotion per_people_extra_info.pei_information6%type
191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type

Line 195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type

191: ,promotion_eligibility_date per_people_extra_info.pei_information29%type --Bug# 13942237,16023085
192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type

Line 196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type

192: ,agency_code_transfer_from per_people_extra_info.pei_information7%type
193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type

Line 197: ,country_world_citizenship per_people_extra_info.pei_information10%type

193: ,org_appointment_auth_code1 per_people_extra_info.pei_information8%type
194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type

Line 198: ,handicap_code per_people_extra_info.pei_information11%type

194: ,org_appointment_desc1 per_people_extra_info.pei_information22%type
195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type

Line 199: ,consent_id per_people_extra_info.pei_information12%type

195: ,org_appointment_auth_code2 per_people_extra_info.pei_information9%type
196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type

Line 200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type

196: ,org_appointment_desc2 per_people_extra_info.pei_information23%type
197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type
204: ,family_member_status per_people_extra_info.pei_information17%type

Line 201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type

197: ,country_world_citizenship per_people_extra_info.pei_information10%type
198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type
204: ,family_member_status per_people_extra_info.pei_information17%type
205: ,retention_inc_review_date per_people_extra_info.pei_information21%type);

Line 202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type

198: ,handicap_code per_people_extra_info.pei_information11%type
199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type
204: ,family_member_status per_people_extra_info.pei_information17%type
205: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
206: --

Line 203: ,family_member_emp_pref per_people_extra_info.pei_information16%type

199: ,consent_id per_people_extra_info.pei_information12%type
200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type
204: ,family_member_status per_people_extra_info.pei_information17%type
205: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
206: --
207:

Line 204: ,family_member_status per_people_extra_info.pei_information17%type

200: ,date_fehb_eligibility_expires per_people_extra_info.pei_information13%type
201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type
204: ,family_member_status per_people_extra_info.pei_information17%type
205: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
206: --
207:
208: --BUG #14276354 added pathways segments

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

201: ,date_temp_eligibility_fehb per_people_extra_info.pei_information14%type
202: ,date_febh_dependent_cert_exp per_people_extra_info.pei_information15%type
203: ,family_member_emp_pref per_people_extra_info.pei_information16%type
204: ,family_member_status per_people_extra_info.pei_information17%type
205: ,retention_inc_review_date per_people_extra_info.pei_information21%type);
206: --
207:
208: --BUG #14276354 added pathways segments
209: type per_group2_type is record

Line 211: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

207:
208: --BUG #14276354 added pathways segments
209: type per_group2_type is record
210: (per_group2_flag varchar2(1)
211: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
212: ,object_version_number per_people_extra_info.object_version_number%type
213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type

Line 212: ,object_version_number per_people_extra_info.object_version_number%type

208: --BUG #14276354 added pathways segments
209: type per_group2_type is record
210: (per_group2_flag varchar2(1)
211: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
212: ,object_version_number per_people_extra_info.object_version_number%type
213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type

Line 213: ,obligated_position_number per_people_extra_info.pei_information3%type

209: type per_group2_type is record
210: (per_group2_flag varchar2(1)
211: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
212: ,object_version_number per_people_extra_info.object_version_number%type
213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type

Line 214: ,obligated_position_type per_people_extra_info.pei_information4%type

210: (per_group2_flag varchar2(1)
211: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
212: ,object_version_number per_people_extra_info.object_version_number%type
213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type

Line 215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type

211: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
212: ,object_version_number per_people_extra_info.object_version_number%type
213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type

Line 216: ,date_return_rights_expires per_people_extra_info.pei_information6%type

212: ,object_version_number per_people_extra_info.object_version_number%type
213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type

Line 217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type

213: ,obligated_position_number per_people_extra_info.pei_information3%type
214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type

Line 218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type

214: ,obligated_position_type per_people_extra_info.pei_information4%type
215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type
222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type

Line 219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type

215: ,date_overseas_tour_expires per_people_extra_info.pei_information5%type
216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type
222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type
223: ,pathways_program_end_date per_people_extra_info.pei_information13%type);

Line 220: ,draw_down_action_id per_people_extra_info.pei_information10%type

216: ,date_return_rights_expires per_people_extra_info.pei_information6%type
217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type
222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type
223: ,pathways_program_end_date per_people_extra_info.pei_information13%type);
224: --

Line 221: ,pathways_program_start_date per_people_extra_info.pei_information11%type

217: ,date_stat_return_rights_expir per_people_extra_info.pei_information7%type
218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type
222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type
223: ,pathways_program_end_date per_people_extra_info.pei_information13%type);
224: --
225: -- 4352589 BEN_EIT Created new benefits EIT Type

Line 222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type

218: ,civilian_duty_stat_contigency per_people_extra_info.pei_information8%type
219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type
222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type
223: ,pathways_program_end_date per_people_extra_info.pei_information13%type);
224: --
225: -- 4352589 BEN_EIT Created new benefits EIT Type
226: type per_benefit_info_type is record

Line 223: ,pathways_program_end_date per_people_extra_info.pei_information13%type);

219: ,date_travel_agmt_pcs_expires per_people_extra_info.pei_information9%type
220: ,draw_down_action_id per_people_extra_info.pei_information10%type
221: ,pathways_program_start_date per_people_extra_info.pei_information11%type
222: ,pathways_program_extn_date per_people_extra_info.pei_information12%type
223: ,pathways_program_end_date per_people_extra_info.pei_information13%type);
224: --
225: -- 4352589 BEN_EIT Created new benefits EIT Type
226: type per_benefit_info_type is record
227: ( per_benefit_info_flag varchar2(1)

Line 228: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

224: --
225: -- 4352589 BEN_EIT Created new benefits EIT Type
226: type per_benefit_info_type is record
227: ( per_benefit_info_flag varchar2(1)
228: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
229: ,object_version_number per_people_extra_info.object_version_number%type
230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type

Line 229: ,object_version_number per_people_extra_info.object_version_number%type

225: -- 4352589 BEN_EIT Created new benefits EIT Type
226: type per_benefit_info_type is record
227: ( per_benefit_info_flag varchar2(1)
228: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
229: ,object_version_number per_people_extra_info.object_version_number%type
230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type

Line 230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type

226: type per_benefit_info_type is record
227: ( per_benefit_info_flag varchar2(1)
228: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
229: ,object_version_number per_people_extra_info.object_version_number%type
230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type

Line 231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type

227: ( per_benefit_info_flag varchar2(1)
228: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
229: ,object_version_number per_people_extra_info.object_version_number%type
230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type

Line 232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type

228: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
229: ,object_version_number per_people_extra_info.object_version_number%type
230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type

Line 233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type

229: ,object_version_number per_people_extra_info.object_version_number%type
230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type

Line 234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type

230: ,FEGLI_Date_Eligibility_Expires per_people_extra_info.pei_information3%type
231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type

Line 235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type

231: ,FEHB_Date_Eligibility_expires per_people_extra_info.pei_information4%type
232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type

Line 236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type

232: ,FEHB_Date_temp_eligibility per_people_extra_info.pei_information5%type
233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type

Line 237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type

233: ,FEHB_Date_dependent_cert_expir per_people_extra_info.pei_information6%type
234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type

Line 238: ,FERS_Election_Date per_people_extra_info.pei_information12%type

234: ,FEHB_LWOP_contingency_st_date per_people_extra_info.pei_information7%type
235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info

Line 239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type

235: ,FEHB_LWOP_contingency_end_date per_people_extra_info.pei_information8%type
236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type

Line 240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type

236: ,FEHB_Child_equiry_court_date per_people_extra_info.pei_information10%type
237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type

Line 241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type

237: ,FERS_Date_eligibility_expires per_people_extra_info.pei_information11%type
238: ,FERS_Election_Date per_people_extra_info.pei_information12%type
239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type

Line 243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type

239: ,FERS_Election_Indicator per_people_extra_info.pei_information13%type
240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
246: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
247: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);

Line 244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type

240: ,TSP_Agncy_Contrib_Elig_date per_people_extra_info.pei_information14%type
241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
246: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
247: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
248: --

Line 245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type

241: ,TSP_Emp_Contrib_Elig_date per_people_extra_info.pei_information15%type
242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
246: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
247: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
248: --
249: type per_scd_info_type is record

Line 246: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type

242: -- 6312144 addition of new segments related to per_benefit_info
243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
246: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
247: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
248: --
249: type per_scd_info_type is record
250: (per_scd_info_flag varchar2(1)

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

243: ,FEGLI_Assignment_Ind per_people_extra_info.pei_information16%type
244: ,FEGLI_Post_Elec_Basic_Ins_Amt per_people_extra_info.pei_information17%type
245: ,FEGLI_Court_Order_Ind per_people_extra_info.pei_information18%type
246: ,Desg_FEGLI_Benf_Ind per_people_extra_info.pei_information19%type
247: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
248: --
249: type per_scd_info_type is record
250: (per_scd_info_flag varchar2(1)
251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

247: ,FEHB_Event_Code per_people_extra_info.pei_information20%type);
248: --
249: type per_scd_info_type is record
250: (per_scd_info_flag varchar2(1)
251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
252: ,object_version_number per_people_extra_info.object_version_number%type
253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type

Line 252: ,object_version_number per_people_extra_info.object_version_number%type

248: --
249: type per_scd_info_type is record
250: (per_scd_info_flag varchar2(1)
251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
252: ,object_version_number per_people_extra_info.object_version_number%type
253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type

Line 253: ,scd_leave per_people_extra_info.pei_information3%type

249: type per_scd_info_type is record
250: (per_scd_info_flag varchar2(1)
251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
252: ,object_version_number per_people_extra_info.object_version_number%type
253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type

Line 254: ,scd_civilian per_people_extra_info.pei_information4%type

250: (per_scd_info_flag varchar2(1)
251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
252: ,object_version_number per_people_extra_info.object_version_number%type
253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type
258: -- Bug 4164083 eHRI New Attributions

Line 255: ,scd_rif per_people_extra_info.pei_information5%type

251: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
252: ,object_version_number per_people_extra_info.object_version_number%type
253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type
258: -- Bug 4164083 eHRI New Attributions
259: ,scd_ses per_people_extra_info.pei_information10%type

Line 256: ,scd_tsp per_people_extra_info.pei_information6%type

252: ,object_version_number per_people_extra_info.object_version_number%type
253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type
258: -- Bug 4164083 eHRI New Attributions
259: ,scd_ses per_people_extra_info.pei_information10%type
260: ,scd_spl_retirement per_people_extra_info.pei_information11%type

Line 257: ,scd_retirement per_people_extra_info.pei_information7%type

253: ,scd_leave per_people_extra_info.pei_information3%type
254: ,scd_civilian per_people_extra_info.pei_information4%type
255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type
258: -- Bug 4164083 eHRI New Attributions
259: ,scd_ses per_people_extra_info.pei_information10%type
260: ,scd_spl_retirement per_people_extra_info.pei_information11%type
261: -- End Bug 4164083

Line 259: ,scd_ses per_people_extra_info.pei_information10%type

255: ,scd_rif per_people_extra_info.pei_information5%type
256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type
258: -- Bug 4164083 eHRI New Attributions
259: ,scd_ses per_people_extra_info.pei_information10%type
260: ,scd_spl_retirement per_people_extra_info.pei_information11%type
261: -- End Bug 4164083
262: --Bug 4443968
263: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type

Line 260: ,scd_spl_retirement per_people_extra_info.pei_information11%type

256: ,scd_tsp per_people_extra_info.pei_information6%type
257: ,scd_retirement per_people_extra_info.pei_information7%type
258: -- Bug 4164083 eHRI New Attributions
259: ,scd_ses per_people_extra_info.pei_information10%type
260: ,scd_spl_retirement per_people_extra_info.pei_information11%type
261: -- End Bug 4164083
262: --Bug 4443968
263: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type
264: ,scd_Length_of_Service per_people_extra_info.pei_information13%type --Bug# 14514445

Line 263: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type

259: ,scd_ses per_people_extra_info.pei_information10%type
260: ,scd_spl_retirement per_people_extra_info.pei_information11%type
261: -- End Bug 4164083
262: --Bug 4443968
263: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type
264: ,scd_Length_of_Service per_people_extra_info.pei_information13%type --Bug# 14514445
265: );
266: --
267: type per_probations_type is record

Line 264: ,scd_Length_of_Service per_people_extra_info.pei_information13%type --Bug# 14514445

260: ,scd_spl_retirement per_people_extra_info.pei_information11%type
261: -- End Bug 4164083
262: --Bug 4443968
263: ,scd_creditable_svc_annl_leave per_people_extra_info.pei_information12%type
264: ,scd_Length_of_Service per_people_extra_info.pei_information13%type --Bug# 14514445
265: );
266: --
267: type per_probations_type is record
268: (per_probation_flag varchar2(1)

Line 269: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

265: );
266: --
267: type per_probations_type is record
268: (per_probation_flag varchar2(1)
269: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
270: ,object_version_number per_people_extra_info.object_version_number%type
271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575

Line 270: ,object_version_number per_people_extra_info.object_version_number%type

266: --
267: type per_probations_type is record
268: (per_probation_flag varchar2(1)
269: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
270: ,object_version_number per_people_extra_info.object_version_number%type
271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type

Line 271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type

267: type per_probations_type is record
268: (per_probation_flag varchar2(1)
269: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
270: ,object_version_number per_people_extra_info.object_version_number%type
271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type

Line 272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type

268: (per_probation_flag varchar2(1)
269: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
270: ,object_version_number per_people_extra_info.object_version_number%type
271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
276: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);

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

269: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
270: ,object_version_number per_people_extra_info.object_version_number%type
271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
276: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
277: --

Line 274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type

270: ,object_version_number per_people_extra_info.object_version_number%type
271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
276: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
277: --
278: type per_retained_grade_type is record

Line 275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type

271: ,date_prob_trial_period_begin per_people_extra_info.pei_information3%type
272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
276: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
277: --
278: type per_retained_grade_type is record
279: (per_retained_grade_flag varchar2(1)

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

272: ,date_prob_trial_period_ends per_people_extra_info.pei_information4%type
273: ,date_spvr_mgr_prob_begins per_people_extra_info.pei_information8%type--Bug# 4588575
274: ,date_spvr_mgr_prob_ends per_people_extra_info.pei_information5%type
275: ,spvr_mgr_prob_completion per_people_extra_info.pei_information6%type
276: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
277: --
278: type per_retained_grade_type is record
279: (per_retained_grade_flag varchar2(1)
280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

276: ,date_ses_prob_expires per_people_extra_info.pei_information7%type);
277: --
278: type per_retained_grade_type is record
279: (per_retained_grade_flag varchar2(1)
280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
281: ,object_version_number per_people_extra_info.object_version_number%type
282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type

Line 281: ,object_version_number per_people_extra_info.object_version_number%type

277: --
278: type per_retained_grade_type is record
279: (per_retained_grade_flag varchar2(1)
280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
281: ,object_version_number per_people_extra_info.object_version_number%type
282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type

Line 282: ,date_from per_people_extra_info.pei_information1%type

278: type per_retained_grade_type is record
279: (per_retained_grade_flag varchar2(1)
280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
281: ,object_version_number per_people_extra_info.object_version_number%type
282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type

Line 283: ,date_to per_people_extra_info.pei_information2%type

279: (per_retained_grade_flag varchar2(1)
280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
281: ,object_version_number per_people_extra_info.object_version_number%type
282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type

Line 284: ,retain_grade per_people_extra_info.pei_information3%type

280: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
281: ,object_version_number per_people_extra_info.object_version_number%type
282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type

Line 285: ,retain_step_or_rate per_people_extra_info.pei_information4%type

281: ,object_version_number per_people_extra_info.object_version_number%type
282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type
289: ,retain_pay_basis per_people_extra_info.pei_information8%type

Line 286: ,retain_pay_plan per_people_extra_info.pei_information5%type

282: ,date_from per_people_extra_info.pei_information1%type
283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type
289: ,retain_pay_basis per_people_extra_info.pei_information8%type
290: ,temp_step per_people_extra_info.pei_information9%type

Line 287: ,retain_pay_table_id per_people_extra_info.pei_information6%type

283: ,date_to per_people_extra_info.pei_information2%type
284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type
289: ,retain_pay_basis per_people_extra_info.pei_information8%type
290: ,temp_step per_people_extra_info.pei_information9%type
291: );

Line 288: ,retain_locality_percent per_people_extra_info.pei_information7%type

284: ,retain_grade per_people_extra_info.pei_information3%type
285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type
289: ,retain_pay_basis per_people_extra_info.pei_information8%type
290: ,temp_step per_people_extra_info.pei_information9%type
291: );
292: --

Line 289: ,retain_pay_basis per_people_extra_info.pei_information8%type

285: ,retain_step_or_rate per_people_extra_info.pei_information4%type
286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type
289: ,retain_pay_basis per_people_extra_info.pei_information8%type
290: ,temp_step per_people_extra_info.pei_information9%type
291: );
292: --
293: type per_sep_retire_type is record

Line 290: ,temp_step per_people_extra_info.pei_information9%type

286: ,retain_pay_plan per_people_extra_info.pei_information5%type
287: ,retain_pay_table_id per_people_extra_info.pei_information6%type
288: ,retain_locality_percent per_people_extra_info.pei_information7%type
289: ,retain_pay_basis per_people_extra_info.pei_information8%type
290: ,temp_step per_people_extra_info.pei_information9%type
291: );
292: --
293: type per_sep_retire_type is record
294: (per_sep_retire_flag varchar2(1)

Line 295: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

291: );
292: --
293: type per_sep_retire_type is record
294: (per_sep_retire_flag varchar2(1)
295: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
296: ,object_version_number per_people_extra_info.object_version_number%type
297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type

Line 296: ,object_version_number per_people_extra_info.object_version_number%type

292: --
293: type per_sep_retire_type is record
294: (per_sep_retire_flag varchar2(1)
295: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
296: ,object_version_number per_people_extra_info.object_version_number%type
297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type

Line 297: ,fers_coverage per_people_extra_info.pei_information3%type

293: type per_sep_retire_type is record
294: (per_sep_retire_flag varchar2(1)
295: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
296: ,object_version_number per_people_extra_info.object_version_number%type
297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type

Line 298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type

294: (per_sep_retire_flag varchar2(1)
295: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
296: ,object_version_number per_people_extra_info.object_version_number%type
297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type

Line 299: ,frozen_service per_people_extra_info.pei_information5%type

295: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
296: ,object_version_number per_people_extra_info.object_version_number%type
297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type

Line 300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type

296: ,object_version_number per_people_extra_info.object_version_number%type
297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type

Line 301: ,reason_for_separation per_people_extra_info.pei_information7%type

297: ,fers_coverage per_people_extra_info.pei_information3%type
298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type

Line 302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type

298: ,prev_retirement_coverage per_people_extra_info.pei_information4%type
299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type

Line 303: ,date_projected_retirement per_people_extra_info.pei_information9%type

299: ,frozen_service per_people_extra_info.pei_information5%type
300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type

Line 304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type

300: ,naf_retirement_indicator per_people_extra_info.pei_information6%type
301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type

Line 305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type

301: ,reason_for_separation per_people_extra_info.pei_information7%type
302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type

Line 306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type

302: ,agency_code_transfer_to per_people_extra_info.pei_information8%type
303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type

Line 307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type

303: ,date_projected_retirement per_people_extra_info.pei_information9%type
304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
311: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);

Line 308: ,date_ret_appl_received per_people_extra_info.pei_information14%type

304: ,mandatory_retirement_date per_people_extra_info.pei_information10%type
305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
311: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
312: --

Line 309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type

305: ,separate_pkg_status_indicator per_people_extra_info.pei_information11%type
306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
311: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
312: --
313: type per_security_type is record

Line 310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type

306: ,separate_pkg_register_number per_people_extra_info.pei_information12%type
307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
311: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
312: --
313: type per_security_type is record
314: (per_security_flag varchar2(1)

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

307: ,separate_pkg_pay_office_id per_people_extra_info.pei_information13%type
308: ,date_ret_appl_received per_people_extra_info.pei_information14%type
309: ,date_ret_pkg_sent_to_payroll per_people_extra_info.pei_information15%type
310: ,date_ret_pkg_recv_payroll per_people_extra_info.pei_information16%type
311: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
312: --
313: type per_security_type is record
314: (per_security_flag varchar2(1)
315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

Line 315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

311: ,date_ret_pkg_to_opm per_people_extra_info.pei_information17%type);
312: --
313: type per_security_type is record
314: (per_security_flag varchar2(1)
315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
316: ,object_version_number per_people_extra_info.object_version_number%type
317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type

Line 316: ,object_version_number per_people_extra_info.object_version_number%type

312: --
313: type per_security_type is record
314: (per_security_flag varchar2(1)
315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
316: ,object_version_number per_people_extra_info.object_version_number%type
317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type

Line 317: ,sec_investigation_basis per_people_extra_info.pei_information3%type

313: type per_security_type is record
314: (per_security_flag varchar2(1)
315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
316: ,object_version_number per_people_extra_info.object_version_number%type
317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type

Line 318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type

314: (per_security_flag varchar2(1)
315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
316: ,object_version_number per_people_extra_info.object_version_number%type
317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type

Line 319: ,date_sec_invest_required per_people_extra_info.pei_information5%type

315: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
316: ,object_version_number per_people_extra_info.object_version_number%type
317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
323: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);

Line 320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type

316: ,object_version_number per_people_extra_info.object_version_number%type
317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
323: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
324: --

Line 321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type

317: ,sec_investigation_basis per_people_extra_info.pei_information3%type
318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
323: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
324: --
325: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record

Line 322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type

318: ,type_of_sec_investigation per_people_extra_info.pei_information4%type
319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
323: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
324: --
325: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
326: type per_service_oblig_type is record

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

319: ,date_sec_invest_required per_people_extra_info.pei_information5%type
320: ,date_sec_invest_completed per_people_extra_info.pei_information6%type
321: ,personnel_sec_clearance per_people_extra_info.pei_information7%type
322: ,sec_clearance_eligilb_date per_people_extra_info.pei_information8%type
323: ,prp_sci_status_employment per_people_extra_info.pei_information9%type);
324: --
325: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
326: type per_service_oblig_type is record
327: (per_service_oblig_flag varchar2(1)

Line 328: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

324: --
325: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
326: type per_service_oblig_type is record
327: (per_service_oblig_flag varchar2(1)
328: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
329: ,object_version_number per_people_extra_info.object_version_number%type
330: ,service_oblig_type_code per_people_extra_info.pei_information3%type
331: ,service_oblig_start_date per_people_extra_info.pei_information4%type
332: ,service_oblig_end_date per_people_extra_info.pei_information5%type);

Line 329: ,object_version_number per_people_extra_info.object_version_number%type

325: -- Bug#4486823 RRR Changes -- Added per_service_oblig_type record
326: type per_service_oblig_type is record
327: (per_service_oblig_flag varchar2(1)
328: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
329: ,object_version_number per_people_extra_info.object_version_number%type
330: ,service_oblig_type_code per_people_extra_info.pei_information3%type
331: ,service_oblig_start_date per_people_extra_info.pei_information4%type
332: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
333: --

Line 330: ,service_oblig_type_code per_people_extra_info.pei_information3%type

326: type per_service_oblig_type is record
327: (per_service_oblig_flag varchar2(1)
328: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
329: ,object_version_number per_people_extra_info.object_version_number%type
330: ,service_oblig_type_code per_people_extra_info.pei_information3%type
331: ,service_oblig_start_date per_people_extra_info.pei_information4%type
332: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
333: --
334: -- modified 10/24/97

Line 331: ,service_oblig_start_date per_people_extra_info.pei_information4%type

327: (per_service_oblig_flag varchar2(1)
328: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
329: ,object_version_number per_people_extra_info.object_version_number%type
330: ,service_oblig_type_code per_people_extra_info.pei_information3%type
331: ,service_oblig_start_date per_people_extra_info.pei_information4%type
332: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
333: --
334: -- modified 10/24/97
335: type per_conversions_type is record

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

328: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
329: ,object_version_number per_people_extra_info.object_version_number%type
330: ,service_oblig_type_code per_people_extra_info.pei_information3%type
331: ,service_oblig_start_date per_people_extra_info.pei_information4%type
332: ,service_oblig_end_date per_people_extra_info.pei_information5%type);
333: --
334: -- modified 10/24/97
335: type per_conversions_type is record
336: (per_conversions_flag varchar2(1)

Line 337: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

333: --
334: -- modified 10/24/97
335: type per_conversions_type is record
336: (per_conversions_flag varchar2(1)
337: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
338: ,object_version_number per_people_extra_info.object_version_number%type
339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type

Line 338: ,object_version_number per_people_extra_info.object_version_number%type

334: -- modified 10/24/97
335: type per_conversions_type is record
336: (per_conversions_flag varchar2(1)
337: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
338: ,object_version_number per_people_extra_info.object_version_number%type
339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type

Line 339: ,date_conv_career_begins per_people_extra_info.pei_information3%type

335: type per_conversions_type is record
336: (per_conversions_flag varchar2(1)
337: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
338: ,object_version_number per_people_extra_info.object_version_number%type
339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
343: ,date_vra_conv_due per_people_extra_info.pei_information6%type);

Line 340: ,date_conv_career_due per_people_extra_info.pei_information4%type

336: (per_conversions_flag varchar2(1)
337: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
338: ,object_version_number per_people_extra_info.object_version_number%type
339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
343: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
344: --Bug# 4588575 Segments are wrongly defined. modified the same

Line 341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type

337: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
338: ,object_version_number per_people_extra_info.object_version_number%type
339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
343: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
344: --Bug# 4588575 Segments are wrongly defined. modified the same
345:

Line 342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type

338: ,object_version_number per_people_extra_info.object_version_number%type
339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
343: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
344: --Bug# 4588575 Segments are wrongly defined. modified the same
345:
346: --

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

339: ,date_conv_career_begins per_people_extra_info.pei_information3%type
340: ,date_conv_career_due per_people_extra_info.pei_information4%type
341: ,date_recmd_conv_begins per_people_extra_info.pei_information5%type
342: ,date_recmd_conv_due per_people_extra_info.pei_information7%type
343: ,date_vra_conv_due per_people_extra_info.pei_information6%type);
344: --Bug# 4588575 Segments are wrongly defined. modified the same
345:
346: --
347: type per_uniformed_services_type is record

Line 349: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

345:
346: --
347: type per_uniformed_services_type is record
348: (per_uniformed_services_flag varchar2(1)
349: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
350: ,object_version_number per_people_extra_info.object_version_number%type
351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type

Line 350: ,object_version_number per_people_extra_info.object_version_number%type

346: --
347: type per_uniformed_services_type is record
348: (per_uniformed_services_flag varchar2(1)
349: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
350: ,object_version_number per_people_extra_info.object_version_number%type
351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type

Line 351: ,reserve_category per_people_extra_info.pei_information3%type

347: type per_uniformed_services_type is record
348: (per_uniformed_services_flag varchar2(1)
349: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
350: ,object_version_number per_people_extra_info.object_version_number%type
351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type

Line 352: ,military_recall_status per_people_extra_info.pei_information4%type

348: (per_uniformed_services_flag varchar2(1)
349: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
350: ,object_version_number per_people_extra_info.object_version_number%type
351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type

Line 353: ,creditable_military_service per_people_extra_info.pei_information5%type

349: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
350: ,object_version_number per_people_extra_info.object_version_number%type
351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type

Line 354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type

350: ,object_version_number per_people_extra_info.object_version_number%type
351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type
358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type

Line 355: ,uniform_service_component per_people_extra_info.pei_information7%type

351: ,reserve_category per_people_extra_info.pei_information3%type
352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type
358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
359: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);

Line 356: ,uniform_service_designation per_people_extra_info.pei_information8%type

352: ,military_recall_status per_people_extra_info.pei_information4%type
353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type
358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
359: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
360: --

Line 357: ,retirement_grade per_people_extra_info.pei_information9%type

353: ,creditable_military_service per_people_extra_info.pei_information5%type
354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type
358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
359: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
360: --
361: type pos_valid_grade_type is record

Line 358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type

354: ,date_retired_uniform_service per_people_extra_info.pei_information6%type
355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type
358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
359: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
360: --
361: type pos_valid_grade_type is record
362: (pos_valid_grade_flag varchar2(1)

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

355: ,uniform_service_component per_people_extra_info.pei_information7%type
356: ,uniform_service_designation per_people_extra_info.pei_information8%type
357: ,retirement_grade per_people_extra_info.pei_information9%type
358: ,military_retire_waiver_ind per_people_extra_info.pei_information10%type
359: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
360: --
361: type pos_valid_grade_type is record
362: (pos_valid_grade_flag varchar2(1)
363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 640: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

636:
637: -- added by skutteti on 3-mar-98
638: type par_term_retained_grade_type is record
639: (par_term_retained_grade_flag varchar2(1)
640: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
641: ,object_version_number per_people_extra_info.object_version_number%type
642: );
643: --
644: type entitlement_type is record

Line 641: ,object_version_number per_people_extra_info.object_version_number%type

637: -- added by skutteti on 3-mar-98
638: type par_term_retained_grade_type is record
639: (par_term_retained_grade_flag varchar2(1)
640: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
641: ,object_version_number per_people_extra_info.object_version_number%type
642: );
643: --
644: type entitlement_type is record
645: (entitlement_flag varchar2(1)

Line 838: person_extra_info_id per_people_extra_info.person_extra_info_id%type,

834:
835: -- Bug 4724337 Race or National Origin changes
836: type per_race_ethnic_type is record
837: ( p_race_ethnic_info_flag varchar2(1),
838: person_extra_info_id per_people_extra_info.person_extra_info_id%type,
839: object_version_number per_people_extra_info.object_version_number%type,
840: p_hispanic varchar2(1),
841: p_american_indian varchar2(1),
842: p_asian varchar2(1),

Line 839: object_version_number per_people_extra_info.object_version_number%type,

835: -- Bug 4724337 Race or National Origin changes
836: type per_race_ethnic_type is record
837: ( p_race_ethnic_info_flag varchar2(1),
838: person_extra_info_id per_people_extra_info.person_extra_info_id%type,
839: object_version_number per_people_extra_info.object_version_number%type,
840: p_hispanic varchar2(1),
841: p_american_indian varchar2(1),
842: p_asian varchar2(1),
843: p_black_afr_american varchar2(1),

Line 852: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

848:
849: -- 6312144 IPA Benefits Continuation EIT changes
850: type per_ipa_ben_cont_info_type is record
851: ( per_ben_cont_info_flag varchar2(1)
852: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
853: ,object_version_number per_people_extra_info.object_version_number%type
854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type

Line 853: ,object_version_number per_people_extra_info.object_version_number%type

849: -- 6312144 IPA Benefits Continuation EIT changes
850: type per_ipa_ben_cont_info_type is record
851: ( per_ben_cont_info_flag varchar2(1)
852: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
853: ,object_version_number per_people_extra_info.object_version_number%type
854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type

Line 854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type

850: type per_ipa_ben_cont_info_type is record
851: ( per_ben_cont_info_flag varchar2(1)
852: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
853: ,object_version_number per_people_extra_info.object_version_number%type
854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type

Line 855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type

851: ( per_ben_cont_info_flag varchar2(1)
852: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
853: ,object_version_number per_people_extra_info.object_version_number%type
854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type

Line 856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type

852: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
853: ,object_version_number per_people_extra_info.object_version_number%type
854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type

Line 857: ,FEHB_Indicator per_people_extra_info.pei_information4%type

853: ,object_version_number per_people_extra_info.object_version_number%type
854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type

Line 858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type

854: ,FEGLI_Indicator per_people_extra_info.pei_information1%type
855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type

Line 859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type

855: ,FEGLI_Election_Date per_people_extra_info.pei_information2%type
856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type

Line 860: ,Retirement_Indicator per_people_extra_info.pei_information7%type

856: ,FEGLI_Elec_Not_Date per_people_extra_info.pei_information3%type
857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type

Line 861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type

857: ,FEHB_Indicator per_people_extra_info.pei_information4%type
858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
865: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);

Line 862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type

858: ,FEHB_Election_Date per_people_extra_info.pei_information5%type
859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
865: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
866:

Line 863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type

859: ,FEHB_Elec_Notf_Date per_people_extra_info.pei_information6%type
860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
865: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
866:
867: -- 6312144 Retirement System information

Line 864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type

860: ,Retirement_Indicator per_people_extra_info.pei_information7%type
861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
865: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
866:
867: -- 6312144 Retirement System information
868: type per_retirement_info_type is record

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

861: ,Retirement_Elec_Date per_people_extra_info.pei_information12%type
862: ,Retirement_Elec_Notf_Date per_people_extra_info.pei_information8%type
863: ,Cont_Term_Insuff_Pay_Elec_Date per_people_extra_info.pei_information9%type
864: ,Cont_Term_Insuff_Pay_Notf_Date per_people_extra_info.pei_information10%type
865: ,Cont_Term_Insuff_Pmt_Type_Code per_people_extra_info.pei_information11%type);
866:
867: -- 6312144 Retirement System information
868: type per_retirement_info_type is record
869: (per_retirement_info_flag varchar2(1)

Line 870: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type

866:
867: -- 6312144 Retirement System information
868: type per_retirement_info_type is record
869: (per_retirement_info_flag varchar2(1)
870: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
871: ,object_version_number per_people_extra_info.object_version_number%type
872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type

Line 871: ,object_version_number per_people_extra_info.object_version_number%type

867: -- 6312144 Retirement System information
868: type per_retirement_info_type is record
869: (per_retirement_info_flag varchar2(1)
870: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
871: ,object_version_number per_people_extra_info.object_version_number%type
872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type

Line 872: ,special_population_code per_people_extra_info.pei_information1%type

868: type per_retirement_info_type is record
869: (per_retirement_info_flag varchar2(1)
870: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
871: ,object_version_number per_people_extra_info.object_version_number%type
872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
876: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);

Line 873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type

869: (per_retirement_info_flag varchar2(1)
870: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
871: ,object_version_number per_people_extra_info.object_version_number%type
872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
876: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
877:

Line 874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type

870: ,person_extra_info_id per_people_extra_info.person_extra_info_id%type
871: ,object_version_number per_people_extra_info.object_version_number%type
872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
876: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
877:
878:

Line 875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type

871: ,object_version_number per_people_extra_info.object_version_number%type
872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
876: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
877:
878:
879:

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

872: ,special_population_code per_people_extra_info.pei_information1%type
873: ,App_Exc_CSRS_Ind per_people_extra_info.pei_information2%type
874: ,App_Exc_FERS_Ind per_people_extra_info.pei_information3%type
875: ,FICA_Coverage_Ind1 per_people_extra_info.pei_information4%type
876: ,FICA_Coverage_Ind2 per_people_extra_info.pei_information5%type);
877:
878:
879:
880: