[Home] [Help]
24:
25: --
26: -- detail - personal (25)
27: -- ======================
28: g_person_id per_all_people_f.person_id%TYPE;
29: --
30: g_chg_evt_cd varchar2(30);
31: g_chg_evt_source varchar2(30);
32: g_chg_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
63: g_chg_pay_evt_index number ;
64: --
65: g_part_type varchar2(30);
66: g_per_rlshp_type varchar2(30);
67: g_part_ssn per_all_people_f.national_identifier%TYPE;
68: g_part_first_name per_all_people_f.first_name%TYPE;
69: g_part_last_name per_all_people_f.last_name%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
64: --
65: g_part_type varchar2(30);
66: g_per_rlshp_type varchar2(30);
67: g_part_ssn per_all_people_f.national_identifier%TYPE;
68: g_part_first_name per_all_people_f.first_name%TYPE;
69: g_part_last_name per_all_people_f.last_name%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
65: g_part_type varchar2(30);
66: g_per_rlshp_type varchar2(30);
67: g_part_ssn per_all_people_f.national_identifier%TYPE;
68: g_part_first_name per_all_people_f.first_name%TYPE;
69: g_part_last_name per_all_people_f.last_name%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
67: g_part_ssn per_all_people_f.national_identifier%TYPE;
68: g_part_first_name per_all_people_f.first_name%TYPE;
69: g_part_last_name per_all_people_f.last_name%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
68: g_part_first_name per_all_people_f.first_name%TYPE;
69: g_part_last_name per_all_people_f.last_name%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
69: g_part_last_name per_all_people_f.last_name%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
70: --
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
71: g_national_identifier per_all_people_f.national_identifier%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
72: g_last_name per_all_people_f.last_name%TYPE;
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
73: g_first_name per_all_people_f.first_name%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
74: g_middle_names per_all_people_f.middle_names%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
75: g_full_name per_all_people_f.full_name%TYPE;
76: g_suffix per_all_people_f.suffix%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
77: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
78: g_title per_all_people_f.title%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
79: g_sup_full_name per_all_people_f.full_name%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
80: --
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
81: g_sex per_all_people_f.sex%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
82: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
83: g_marital_status per_all_people_f.marital_status%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
84: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
85: g_student_status per_all_people_f.student_status%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
86: g_date_of_death per_all_people_f.date_of_death%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
87: g_employee_number per_all_people_f.employee_number%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
88: g_per_information1 per_all_people_f.per_information1%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
89: g_per_information2 per_all_people_f.per_information2%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
90: g_per_information3 per_all_people_f.per_information3%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
91: g_per_information4 per_all_people_f.per_information4%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
92: g_per_information5 per_all_people_f.per_information5%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
93: g_per_information6 per_all_people_f.per_information6%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
94: g_per_information7 per_all_people_f.per_information7%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
95: g_per_information8 per_all_people_f.per_information8%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
96: g_per_information9 per_all_people_f.per_information9%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
97: g_per_information10 per_all_people_f.per_information10%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
98: g_per_information11 per_all_people_f.per_information11%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
99: g_per_information12 per_all_people_f.per_information12%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
100: g_per_information13 per_all_people_f.per_information13%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
101: g_per_information14 per_all_people_f.per_information14%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
102: g_per_information15 per_all_people_f.per_information14%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
103: g_per_information16 per_all_people_f.per_information16%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
104: g_per_information17 per_all_people_f.per_information17%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
105: g_per_information18 per_all_people_f.per_information18%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
106: g_per_information19 per_all_people_f.per_information19%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
107: g_per_information20 per_all_people_f.per_information20%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
108: g_per_information21 per_all_people_f.per_information20%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
116: g_per_information29 per_all_people_f.per_information29%TYPE;
109: g_per_information22 per_all_people_f.per_information21%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
116: g_per_information29 per_all_people_f.per_information29%TYPE;
117: g_per_information30 per_all_people_f.per_information30%TYPE;
110: g_per_information23 per_all_people_f.per_information22%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
116: g_per_information29 per_all_people_f.per_information29%TYPE;
117: g_per_information30 per_all_people_f.per_information30%TYPE;
118: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
111: g_per_information24 per_all_people_f.per_information23%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
116: g_per_information29 per_all_people_f.per_information29%TYPE;
117: g_per_information30 per_all_people_f.per_information30%TYPE;
118: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
119: g_benefit_group ben_benfts_grp.name%TYPE;
112: g_per_information25 per_all_people_f.per_information24%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
116: g_per_information29 per_all_people_f.per_information29%TYPE;
117: g_per_information30 per_all_people_f.per_information30%TYPE;
118: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
119: g_benefit_group ben_benfts_grp.name%TYPE;
120: g_benefit_bal_vacation ben_per_bnfts_bal_f.val%TYPE;
113: g_per_information26 per_all_people_f.per_information25%TYPE;
114: g_per_information27 per_all_people_f.per_information27%TYPE;
115: g_per_information28 per_all_people_f.per_information28%TYPE;
116: g_per_information29 per_all_people_f.per_information29%TYPE;
117: g_per_information30 per_all_people_f.per_information30%TYPE;
118: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
119: g_benefit_group ben_benfts_grp.name%TYPE;
120: g_benefit_bal_vacation ben_per_bnfts_bal_f.val%TYPE;
121: g_benefit_bal_sickleave ben_per_bnfts_bal_f.val%TYPE;
121: g_benefit_bal_sickleave ben_per_bnfts_bal_f.val%TYPE;
122: g_benefit_bal_pension ben_per_bnfts_bal_f.val%TYPE;
123: g_benefit_bal_dfncntrbn ben_per_bnfts_bal_f.val%TYPE;
124: g_benefit_bal_wellness ben_per_bnfts_bal_f.val%TYPE;
125: g_sup_employee_number per_all_people_f.employee_number%TYPE;
126: --
127: g_applicant_number per_all_people_f.applicant_number%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
123: g_benefit_bal_dfncntrbn ben_per_bnfts_bal_f.val%TYPE;
124: g_benefit_bal_wellness ben_per_bnfts_bal_f.val%TYPE;
125: g_sup_employee_number per_all_people_f.employee_number%TYPE;
126: --
127: g_applicant_number per_all_people_f.applicant_number%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
124: g_benefit_bal_wellness ben_per_bnfts_bal_f.val%TYPE;
125: g_sup_employee_number per_all_people_f.employee_number%TYPE;
126: --
127: g_applicant_number per_all_people_f.applicant_number%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
125: g_sup_employee_number per_all_people_f.employee_number%TYPE;
126: --
127: g_applicant_number per_all_people_f.applicant_number%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
126: --
127: g_applicant_number per_all_people_f.applicant_number%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
127: g_applicant_number per_all_people_f.applicant_number%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
128: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
129: g_email_address per_all_people_f.email_address%TYPE;
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
130: g_known_as per_all_people_f.known_as%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
131: g_mailstop per_all_people_f.mailstop%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
132: g_nationality per_all_people_f.nationality%TYPE;
133: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
134: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
135: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
136: g_office_number per_all_people_f.office_number%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
137: --
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
138: g_previous_last_name per_all_people_f.last_name%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
139: g_previous_first_name per_all_people_f.first_name%TYPE;
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
140: g_previous_middle_name per_all_people_f.middle_names%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
141: g_previous_suffix per_all_people_f.suffix%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
142: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
143: g_previous_ssn per_all_people_f.national_identifier%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
144: g_previous_dob per_all_people_f.date_of_birth%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
145: g_previous_sex per_all_people_f.Sex%TYPE;
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
146: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
147: --
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
148: g_last_update_date per_all_people_f.last_update_date%TYPE;
149: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
150: g_last_update_login per_all_people_f.last_update_login%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
151: g_created_by per_all_people_f.created_by%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
152: g_creation_date per_all_people_f.creation_date%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
153: --
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
154: g_per_attr_1 per_all_people_f.attribute1%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
155: g_per_attr_2 per_all_people_f.attribute2%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
156: g_per_attr_3 per_all_people_f.attribute3%TYPE;
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
164: --
157: g_per_attr_4 per_all_people_f.attribute4%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
164: --
165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
158: g_per_attr_5 per_all_people_f.attribute5%TYPE;
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
164: --
165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
166: --
159: g_per_attr_6 per_all_people_f.attribute6%TYPE;
160: g_per_attr_7 per_all_people_f.attribute7%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
164: --
165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
166: --
167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
161: g_per_attr_8 per_all_people_f.attribute8%TYPE;
162: g_per_attr_9 per_all_people_f.attribute9%TYPE;
163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
164: --
165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
166: --
167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
567: g_pev_ttl_other_rate number;
568: --
569: -- detail - dependent
570: --
571: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
572: g_dpnt_last_name per_all_people_f.last_name%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
568: --
569: -- detail - dependent
570: --
571: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
572: g_dpnt_last_name per_all_people_f.last_name%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
569: -- detail - dependent
570: --
571: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
572: g_dpnt_last_name per_all_people_f.last_name%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
577: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
570: --
571: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
572: g_dpnt_last_name per_all_people_f.last_name%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
577: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
578: g_dpnt_title per_all_people_f.title%TYPE;
571: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
572: g_dpnt_last_name per_all_people_f.last_name%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
577: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
578: g_dpnt_title per_all_people_f.title%TYPE;
579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
572: g_dpnt_last_name per_all_people_f.last_name%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
577: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
578: g_dpnt_title per_all_people_f.title%TYPE;
579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
573: g_dpnt_first_name per_all_people_f.first_name%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
577: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
578: g_dpnt_title per_all_people_f.title%TYPE;
579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
574: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
575: g_dpnt_full_name per_all_people_f.full_name%TYPE;
576: g_dpnt_suffix per_all_people_f.suffix%TYPE;
577: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
578: g_dpnt_title per_all_people_f.title%TYPE;
579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
582: g_dpnt_sex per_all_people_f.sex%TYPE;
578: g_dpnt_title per_all_people_f.title%TYPE;
579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
582: g_dpnt_sex per_all_people_f.sex%TYPE;
583: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
584: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
585: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
579: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
582: g_dpnt_sex per_all_people_f.sex%TYPE;
583: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
584: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
585: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
580: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
582: g_dpnt_sex per_all_people_f.sex%TYPE;
583: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
584: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
585: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
581: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
582: g_dpnt_sex per_all_people_f.sex%TYPE;
583: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
584: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
585: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
582: g_dpnt_sex per_all_people_f.sex%TYPE;
583: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
584: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
585: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
583: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
584: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
585: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
586: g_dpnt_student_status per_all_people_f.student_status%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
587: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
588: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
589: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
590: g_dpnt_nationality per_all_people_f.nationality%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
591: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
592: g_dpnt_email_address per_all_people_f.email_address%TYPE;
593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
610: g_dpnt_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
611: --
612: -- detail - eligible dependent
613: --
614: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
615: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
611: --
612: -- detail - eligible dependent
613: --
614: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
615: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
612: -- detail - eligible dependent
613: --
614: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
615: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
620: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
613: --
614: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
615: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
620: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
621: g_elig_dpnt_title per_all_people_f.title%TYPE;
614: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
615: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
620: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
621: g_elig_dpnt_title per_all_people_f.title%TYPE;
622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
615: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
620: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
621: g_elig_dpnt_title per_all_people_f.title%TYPE;
622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
616: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
620: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
621: g_elig_dpnt_title per_all_people_f.title%TYPE;
622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
617: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
618: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
619: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
620: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
621: g_elig_dpnt_title per_all_people_f.title%TYPE;
622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
625: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
621: g_elig_dpnt_title per_all_people_f.title%TYPE;
622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
625: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
626: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
627: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
628: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
629: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
622: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
625: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
626: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
627: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
628: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
629: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
630: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
623: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
625: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
626: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
627: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
628: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
629: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
630: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
631: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
624: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
625: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
626: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
627: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
628: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
629: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
630: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
631: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
632: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
625: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
626: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
627: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
628: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
629: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
630: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
631: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
632: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
633: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
626: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
627: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
628: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
629: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
630: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
631: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
632: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
633: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
634: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
632: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
633: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
634: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
635: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
636: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
637: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
633: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
634: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
635: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
636: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
637: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
634: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
635: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
636: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
637: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
635: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
636: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
637: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
636: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
637: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
637: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
638: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
656: g_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
657: --
658: -- contacts
659: --
660: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
661: g_contact_last_name per_all_people_f.last_name%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
657: --
658: -- contacts
659: --
660: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
661: g_contact_last_name per_all_people_f.last_name%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
658: -- contacts
659: --
660: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
661: g_contact_last_name per_all_people_f.last_name%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
659: --
660: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
661: g_contact_last_name per_all_people_f.last_name%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
660: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
661: g_contact_last_name per_all_people_f.last_name%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
661: g_contact_last_name per_all_people_f.last_name%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
662: g_contact_first_name per_all_people_f.first_name%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
663: g_contact_middle_names per_all_people_f.middle_names%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
664: g_contact_full_name per_all_people_f.full_name%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
665: g_contact_suffix per_all_people_f.suffix%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
666: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
667: g_contact_title per_all_people_f.title%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
668: g_contact_sex per_all_people_f.sex%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
669: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
670: g_contact_marital_status per_all_people_f.marital_status%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
671: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
672: g_contact_student_status per_all_people_f.student_status%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
673: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
674: g_contact_nationality per_all_people_f.nationality%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
675: g_contact_language per_all_people_f.correspondence_language%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
676: g_contact_email_address per_all_people_f.email_address%TYPE;
677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
964:
965: --
966: -- beneficiary
967: --
968: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
969: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
965: --
966: -- beneficiary
967: --
968: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
969: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
966: -- beneficiary
967: --
968: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
969: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
967: --
968: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
969: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
968: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
969: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
969: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
970: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
971: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
972: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
973: g_bnf_suffix per_all_people_f.suffix%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
974: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
975: g_bnf_title per_all_people_f.title%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
976: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
977: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
978: g_bnf_email_address per_all_people_f.email_address%TYPE;
979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
996: g_bnf_student_status per_all_people_f.student_status%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
996: g_bnf_student_status per_all_people_f.student_status%TYPE;
997: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
996: g_bnf_student_status per_all_people_f.student_status%TYPE;
997: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
998: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
996: g_bnf_student_status per_all_people_f.student_status%TYPE;
997: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
998: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
999: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
996: g_bnf_student_status per_all_people_f.student_status%TYPE;
997: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
998: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
999: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
1000: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
996: g_bnf_student_status per_all_people_f.student_status%TYPE;
997: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
998: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
999: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
1000: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;
1001: g_bnf_amt_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE;