[Home] [Help]
PACKAGE BODY: APPS.PER_QH_SUMMARY_QUERY
Source
1 PACKAGE BODY per_qh_summary_query as
2 /* $Header: peqhsumq.pkb 120.1 2005/12/29 05:40:35 rvarshne noship $ */
3
4 procedure sumquery
5 (resultset IN OUT NOCOPY sumtab
6 ,p_person_id IN number
7 ,p_assignment_id IN number default null
8 ,p_effective_date IN date
9 ,p_template_name IN varchar2
10 ,p_block_name IN varchar2
11 ,p_legislation_code IN varchar2
12 ) is
13 l_main_rec per_qh_maintain_query.mainrec;
14 l_out_rec sumrec;
15 --
16 cursor csr_establishment
17 (p_person_id number) is
18 select pea.attended_start_date
19 , pe.name
20 , pea.full_time
21 , pea.attended_end_date
22 from per_establishments pe
23 , per_establishment_attendances pea
24 where pea.person_id=p_person_id
25 and pea.establishment_id=pe.establishment_id(+)
26 order by attended_end_date desc, attended_start_date desc;
27 --
28 begin
29 per_qh_maintain_query.onerow(l_main_rec
30 ,p_person_id
31 ,p_assignment_id
32 ,p_effective_date
33 ,p_template_name
34 ,p_block_name
35 ,p_legislation_code
36 );
37
38 l_out_rec.person_id :=l_main_rec.person_id;
39 l_out_rec.business_group_name :=l_main_rec.business_group_name;
40 l_out_rec.per_effective_start_date :=l_main_rec.per_effective_start_date;
41 l_out_rec.per_effective_end_date :=l_main_rec.per_effective_end_date;
42 l_out_rec.person_type :=l_main_rec.person_type;
43 l_out_rec.system_person_type :=l_main_rec.system_person_type;
44 l_out_rec.last_name :=l_main_rec.last_name;
45 l_out_rec.start_date :=l_main_rec.start_date;
46 l_out_rec.applicant_number :=l_main_rec.applicant_number;
47 l_out_rec.background_check_status :=l_main_rec.background_check_status;
48 l_out_rec.background_date_check :=l_main_rec.background_date_check;
49 l_out_rec.blood_type_meaning :=l_main_rec.blood_type_meaning;
50 l_out_rec.corr_lang_meaning :=l_main_rec.corr_lang_meaning;
51 --CWK
52 l_out_rec.npw_number :=l_main_rec.npw_number;
53 l_out_rec.period_of_placement_date_start :=l_main_rec.period_of_placement_date_start;
54 l_out_rec.projected_assignment_end := l_main_rec.projected_assignment_end;
55 l_out_rec.vendor_employee_number :=l_main_rec.vendor_employee_number;
56 l_out_rec.vendor_assignment_number :=l_main_rec.vendor_assignment_number;
57 l_out_rec.vendor_name :=l_main_rec.vendor_name;
58 l_out_rec.project_title :=l_main_rec.project_title;
59 l_out_rec.vendor_site_code :=l_main_rec.vendor_site_code;
60 l_out_rec.po_header_num :=l_main_rec.po_header_num;
61 l_out_rec.po_line_num :=l_main_rec.po_line_num;
62 --
63 l_out_rec.date_employee_data_verified :=l_main_rec.date_employee_data_verified;
64 l_out_rec.date_of_birth :=l_main_rec.date_of_birth;
65 l_out_rec.age :=l_main_rec.age;
66 l_out_rec.email_address :=l_main_rec.email_address;
67 l_out_rec.employee_number :=l_main_rec.employee_number;
68 l_out_rec.expnse_chk_send_addr_meaning :=l_main_rec.expnse_chk_send_addr_meaning;
69 l_out_rec.first_name :=l_main_rec.first_name;
70 l_out_rec.per_fte_capacity :=l_main_rec.per_fte_capacity;
71 l_out_rec.full_name :=l_main_rec.full_name;
72 l_out_rec.hold_applicant_date_until :=l_main_rec.hold_applicant_date_until;
73 l_out_rec.honors :=l_main_rec.honors;
74 l_out_rec.internal_location :=l_main_rec.internal_location;
75 l_out_rec.known_as :=l_main_rec.known_as;
76 l_out_rec.last_medical_test_by :=l_main_rec.last_medical_test_by;
77 l_out_rec.last_medical_test_date :=l_main_rec.last_medical_test_date;
78 l_out_rec.mailstop :=l_main_rec.mailstop;
79 l_out_rec.marital_status_meaning :=l_main_rec.marital_status_meaning;
80 l_out_rec.middle_names :=l_main_rec.middle_names;
81 l_out_rec.nationality_meaning :=l_main_rec.nationality_meaning;
82 l_out_rec.national_identifier :=l_main_rec.national_identifier;
83 l_out_rec.office_number :=l_main_rec.office_number;
84 l_out_rec.on_military_service :=l_main_rec.on_military_service;
85 l_out_rec.pre_name_adjunct :=l_main_rec.pre_name_adjunct;
86 l_out_rec.previous_last_name :=l_main_rec.previous_last_name;
87 l_out_rec.rehire_recommendation :=l_main_rec.rehire_recommendation;
88 l_out_rec.rehire_reason :=l_main_rec.rehire_reason;
89 l_out_rec.resume_exists :=l_main_rec.resume_exists;
90 l_out_rec.resume_last_updated :=l_main_rec.resume_last_updated;
91 -- Bug 3037019
92 l_out_rec.registered_disabled_flag :=l_main_rec.registered_disabled_flag;
93 l_out_rec.second_passport_exists :=l_main_rec.second_passport_exists;
94 l_out_rec.sex :=l_main_rec.sex;
95 l_out_rec.sex_meaning :=l_main_rec.sex_meaning;
96 l_out_rec.student_status_meaning :=l_main_rec.student_status_meaning;
97 l_out_rec.suffix :=l_main_rec.suffix;
98 l_out_rec.title_meaning :=l_main_rec.title_meaning;
99 l_out_rec.work_schedule_meaning :=l_main_rec.work_schedule_meaning;
100 l_out_rec.coord_ben_med_pln_no :=l_main_rec.coord_ben_med_pln_no;
101 l_out_rec.coord_ben_no_cvg_flag :=l_main_rec.coord_ben_no_cvg_flag;
102 l_out_rec.dpdnt_adoption_date :=l_main_rec.dpdnt_adoption_date;
103 l_out_rec.dpdnt_vlntry_svce_flag :=l_main_rec.dpdnt_vlntry_svce_flag;
104 l_out_rec.receipt_of_death_cert_date :=l_main_rec.receipt_of_death_cert_date;
105 l_out_rec.uses_tobacco_flag :=l_main_rec.uses_tobacco_flag;
106 l_out_rec.benefit_group :=l_main_rec.benefit_group;
107 l_out_rec.attribute_category :=l_main_rec.attribute_category;
108 l_out_rec.attribute1 :=l_main_rec.attribute1;
109 l_out_rec.attribute2 :=l_main_rec.attribute2;
110 l_out_rec.attribute3 :=l_main_rec.attribute3;
111 l_out_rec.attribute4 :=l_main_rec.attribute4;
112 l_out_rec.attribute5 :=l_main_rec.attribute5;
113 l_out_rec.attribute6 :=l_main_rec.attribute6;
114 l_out_rec.attribute7 :=l_main_rec.attribute7;
115 l_out_rec.attribute8 :=l_main_rec.attribute8;
116 l_out_rec.attribute9 :=l_main_rec.attribute9;
117 l_out_rec.attribute10 :=l_main_rec.attribute10;
118 l_out_rec.attribute11 :=l_main_rec.attribute11;
119 l_out_rec.attribute12 :=l_main_rec.attribute12;
120 l_out_rec.attribute13 :=l_main_rec.attribute13;
121 l_out_rec.attribute14 :=l_main_rec.attribute14;
122 l_out_rec.attribute15 :=l_main_rec.attribute15;
123 l_out_rec.attribute16 :=l_main_rec.attribute16;
124 l_out_rec.attribute17 :=l_main_rec.attribute17;
125 l_out_rec.attribute18 :=l_main_rec.attribute18;
126 l_out_rec.attribute19 :=l_main_rec.attribute19;
127 l_out_rec.attribute20 :=l_main_rec.attribute20;
128 l_out_rec.attribute21 :=l_main_rec.attribute21;
129 l_out_rec.attribute22 :=l_main_rec.attribute22;
130 l_out_rec.attribute23 :=l_main_rec.attribute23;
131 l_out_rec.attribute24 :=l_main_rec.attribute24;
132 l_out_rec.attribute25 :=l_main_rec.attribute25;
133 l_out_rec.attribute26 :=l_main_rec.attribute26;
134 l_out_rec.attribute27 :=l_main_rec.attribute27;
135 l_out_rec.attribute28 :=l_main_rec.attribute28;
136 l_out_rec.attribute29 :=l_main_rec.attribute29;
137 l_out_rec.attribute30 :=l_main_rec.attribute30;
138 l_out_rec.per_information_category :=l_main_rec.per_information_category;
139 l_out_rec.per_information1 :=l_main_rec.per_information1;
140 l_out_rec.per_information2 :=l_main_rec.per_information2;
141 l_out_rec.per_information3 :=l_main_rec.per_information3;
142 l_out_rec.per_information4 :=l_main_rec.per_information4;
143 l_out_rec.per_information5 :=l_main_rec.per_information5;
144 l_out_rec.per_information6 :=l_main_rec.per_information6;
145 l_out_rec.per_information7 :=l_main_rec.per_information7;
146 l_out_rec.per_information8 :=l_main_rec.per_information8;
147 l_out_rec.per_information9 :=l_main_rec.per_information9;
148 l_out_rec.per_information10 :=l_main_rec.per_information10;
149 l_out_rec.per_information11 :=l_main_rec.per_information11;
150 l_out_rec.per_information12 :=l_main_rec.per_information12;
151 l_out_rec.per_information13 :=l_main_rec.per_information13;
152 l_out_rec.per_information14 :=l_main_rec.per_information14;
153 l_out_rec.per_information15 :=l_main_rec.per_information15;
154 l_out_rec.per_information16 :=l_main_rec.per_information16;
155 l_out_rec.per_information17 :=l_main_rec.per_information17;
156 l_out_rec.per_information18 :=l_main_rec.per_information18;
157 l_out_rec.per_information19 :=l_main_rec.per_information19;
158 l_out_rec.per_information20 :=l_main_rec.per_information20;
159 l_out_rec.per_information21 :=l_main_rec.per_information21;
160 l_out_rec.per_information22 :=l_main_rec.per_information22;
161 l_out_rec.per_information23 :=l_main_rec.per_information23;
162 l_out_rec.per_information24 :=l_main_rec.per_information24;
163 l_out_rec.per_information25 :=l_main_rec.per_information25;
164 l_out_rec.per_information26 :=l_main_rec.per_information26;
165 l_out_rec.per_information27 :=l_main_rec.per_information27;
166 l_out_rec.per_information28 :=l_main_rec.per_information28;
167 l_out_rec.per_information29 :=l_main_rec.per_information29;
168 l_out_rec.per_information30 :=l_main_rec.per_information30;
169 l_out_rec.date_of_death :=l_main_rec.date_of_death;
170 l_out_rec.original_date_of_hire :=l_main_rec.original_date_of_hire;
171 l_out_rec.town_of_birth_meaning :=l_main_rec.town_of_birth_meaning;
172 l_out_rec.region_of_birth_meaning :=l_main_rec.region_of_birth_meaning;
173 l_out_rec.country_of_birth_meaning :=l_main_rec.country_of_birth_meaning;
174 l_out_rec.per_object_version_number :=l_main_rec.per_object_version_number;
175 l_out_rec.person_update_allowed :=l_main_rec.person_update_allowed;
176 l_out_rec.assignment_id :=l_main_rec.assignment_id;
177 l_out_rec.asg_effective_start_date :=l_main_rec.asg_effective_start_date;
178 l_out_rec.asg_effective_end_date :=l_main_rec.asg_effective_end_date;
179 l_out_rec.recruiter :=l_main_rec.recruiter;
180 l_out_rec.grade :=l_main_rec.grade;
181 l_out_rec.grade_ladder :=l_main_rec.grade_ladder;
182 l_out_rec.position :=l_main_rec.position;
183 l_out_rec.job :=l_main_rec.job;
184 l_out_rec.assignment_status_type :=l_main_rec.assignment_status_type;
185 l_out_rec.system_status :=l_main_rec.system_status;
186 l_out_rec.payroll :=l_main_rec.payroll;
187 l_out_rec.location :=l_main_rec.location;
188 l_out_rec.person_referred_by :=l_main_rec.person_referred_by;
189 l_out_rec.supervisor :=l_main_rec.supervisor;
190 l_out_rec.recruitment_activity :=l_main_rec.recruitment_activity;
191 l_out_rec.source_organization :=l_main_rec.source_organization;
192 l_out_rec.organization :=l_main_rec.organization;
193 l_out_rec.pgp_segment1 :=l_main_rec.pgp_segment1;
194 l_out_rec.pgp_segment2 :=l_main_rec.pgp_segment2;
195 l_out_rec.pgp_segment3 :=l_main_rec.pgp_segment3;
196 l_out_rec.pgp_segment4 :=l_main_rec.pgp_segment4;
197 l_out_rec.pgp_segment5 :=l_main_rec.pgp_segment5;
198 l_out_rec.pgp_segment6 :=l_main_rec.pgp_segment6;
199 l_out_rec.pgp_segment7 :=l_main_rec.pgp_segment7;
200 l_out_rec.pgp_segment8 :=l_main_rec.pgp_segment8;
201 l_out_rec.pgp_segment9 :=l_main_rec.pgp_segment9;
202 l_out_rec.pgp_segment10 :=l_main_rec.pgp_segment10;
203 l_out_rec.pgp_segment11 :=l_main_rec.pgp_segment11;
204 l_out_rec.pgp_segment12 :=l_main_rec.pgp_segment12;
205 l_out_rec.pgp_segment13 :=l_main_rec.pgp_segment13;
206 l_out_rec.pgp_segment14 :=l_main_rec.pgp_segment14;
207 l_out_rec.pgp_segment15 :=l_main_rec.pgp_segment15;
208 l_out_rec.pgp_segment16 :=l_main_rec.pgp_segment16;
209 l_out_rec.pgp_segment17 :=l_main_rec.pgp_segment17;
210 l_out_rec.pgp_segment18 :=l_main_rec.pgp_segment18;
211 l_out_rec.pgp_segment19 :=l_main_rec.pgp_segment19;
212 l_out_rec.pgp_segment20 :=l_main_rec.pgp_segment20;
213 l_out_rec.pgp_segment21 :=l_main_rec.pgp_segment21;
214 l_out_rec.pgp_segment22 :=l_main_rec.pgp_segment22;
215 l_out_rec.pgp_segment23 :=l_main_rec.pgp_segment23;
216 l_out_rec.pgp_segment24 :=l_main_rec.pgp_segment24;
217 l_out_rec.pgp_segment25 :=l_main_rec.pgp_segment25;
218 l_out_rec.pgp_segment26 :=l_main_rec.pgp_segment26;
219 l_out_rec.pgp_segment27 :=l_main_rec.pgp_segment27;
220 l_out_rec.pgp_segment28 :=l_main_rec.pgp_segment28;
221 l_out_rec.pgp_segment29 :=l_main_rec.pgp_segment29;
222 l_out_rec.pgp_segment30 :=l_main_rec.pgp_segment30;
223 l_out_rec.people_group_id :=l_main_rec.people_group_id;
224 l_out_rec.scl_segment1 :=l_main_rec.scl_segment1;
225 l_out_rec.scl_segment2 :=l_main_rec.scl_segment2;
226 l_out_rec.scl_segment3 :=l_main_rec.scl_segment3;
227 l_out_rec.scl_segment4 :=l_main_rec.scl_segment4;
228 l_out_rec.scl_segment5 :=l_main_rec.scl_segment5;
229 l_out_rec.scl_segment6 :=l_main_rec.scl_segment6;
230 l_out_rec.scl_segment7 :=l_main_rec.scl_segment7;
231 l_out_rec.scl_segment8 :=l_main_rec.scl_segment8;
232 l_out_rec.scl_segment9 :=l_main_rec.scl_segment9;
233 l_out_rec.scl_segment10 :=l_main_rec.scl_segment10;
234 l_out_rec.scl_segment11 :=l_main_rec.scl_segment11;
235 l_out_rec.scl_segment12 :=l_main_rec.scl_segment12;
236 l_out_rec.scl_segment13 :=l_main_rec.scl_segment13;
237 l_out_rec.scl_segment14 :=l_main_rec.scl_segment14;
238 l_out_rec.scl_segment15 :=l_main_rec.scl_segment15;
239 l_out_rec.scl_segment16 :=l_main_rec.scl_segment16;
240 l_out_rec.scl_segment17 :=l_main_rec.scl_segment17;
241 l_out_rec.scl_segment18 :=l_main_rec.scl_segment18;
242 l_out_rec.scl_segment19 :=l_main_rec.scl_segment19;
243 l_out_rec.scl_segment20 :=l_main_rec.scl_segment20;
244 l_out_rec.scl_segment21 :=l_main_rec.scl_segment21;
245 l_out_rec.scl_segment22 :=l_main_rec.scl_segment22;
246 l_out_rec.scl_segment23 :=l_main_rec.scl_segment23;
247 l_out_rec.scl_segment24 :=l_main_rec.scl_segment24;
248 l_out_rec.scl_segment25 :=l_main_rec.scl_segment25;
249 l_out_rec.scl_segment26 :=l_main_rec.scl_segment26;
250 l_out_rec.scl_segment27 :=l_main_rec.scl_segment27;
251 l_out_rec.scl_segment28 :=l_main_rec.scl_segment28;
252 l_out_rec.scl_segment29 :=l_main_rec.scl_segment29;
253 l_out_rec.scl_segment30 :=l_main_rec.scl_segment30;
254 l_out_rec.soft_coding_keyflex_id :=l_main_rec.soft_coding_keyflex_id;
255 l_out_rec.vacancy :=l_main_rec.vacancy;
256 l_out_rec.requisition :=l_main_rec.requisition;
257 l_out_rec.salary_basis :=l_main_rec.salary_basis;
258 l_out_rec.pay_basis :=l_main_rec.pay_basis;
259 l_out_rec.pay_basis_meaning :=l_main_rec.pay_basis_meaning;
260 l_out_rec.assignment_sequence :=l_main_rec.assignment_sequence;
261 l_out_rec.assignment_type :=l_main_rec.assignment_type;
262 l_out_rec.asg_primary_flag :=l_main_rec.asg_primary_flag;
263 l_out_rec.assignment_number :=l_main_rec.assignment_number;
264 l_out_rec.date_probation_end :=l_main_rec.date_probation_end;
265 l_out_rec.default_code_comb_id :=l_main_rec.default_code_comb_id;
266 l_out_rec.employment_category_meaning :=l_main_rec.employment_category_meaning;
267 l_out_rec.employee_category_meaning :=l_main_rec.employee_category_meaning;
268 l_out_rec.frequency_meaning :=l_main_rec.frequency_meaning;
269 l_out_rec.normal_hours :=l_main_rec.normal_hours;
270 l_out_rec.probation_period :=l_main_rec.probation_period;
271 l_out_rec.probation_unit_meaning :=l_main_rec.probation_unit_meaning;
272 l_out_rec.notice_period :=l_main_rec.notice_period;
273 l_out_rec.notice_unit_meaning :=l_main_rec.notice_unit_meaning;
274 l_out_rec.time_normal_finish :=l_main_rec.time_normal_finish;
275 l_out_rec.time_normal_start :=l_main_rec.time_normal_start;
276 l_out_rec.ass_attribute_category :=l_main_rec.ass_attribute_category;
277 l_out_rec.ass_attribute1 :=l_main_rec.ass_attribute1;
278 l_out_rec.ass_attribute2 :=l_main_rec.ass_attribute2;
279 l_out_rec.ass_attribute3 :=l_main_rec.ass_attribute3;
280 l_out_rec.ass_attribute4 :=l_main_rec.ass_attribute4;
281 l_out_rec.ass_attribute5 :=l_main_rec.ass_attribute5;
282 l_out_rec.ass_attribute6 :=l_main_rec.ass_attribute6;
283 l_out_rec.ass_attribute7 :=l_main_rec.ass_attribute7;
284 l_out_rec.ass_attribute8 :=l_main_rec.ass_attribute8;
285 l_out_rec.ass_attribute9 :=l_main_rec.ass_attribute9;
286 l_out_rec.ass_attribute10 :=l_main_rec.ass_attribute10;
287 l_out_rec.ass_attribute11 :=l_main_rec.ass_attribute11;
288 l_out_rec.ass_attribute12 :=l_main_rec.ass_attribute12;
289 l_out_rec.ass_attribute13 :=l_main_rec.ass_attribute13;
290 l_out_rec.ass_attribute14 :=l_main_rec.ass_attribute14;
291 l_out_rec.ass_attribute15 :=l_main_rec.ass_attribute15;
292 l_out_rec.ass_attribute16 :=l_main_rec.ass_attribute16;
293 l_out_rec.ass_attribute17 :=l_main_rec.ass_attribute17;
294 l_out_rec.ass_attribute18 :=l_main_rec.ass_attribute18;
295 l_out_rec.ass_attribute19 :=l_main_rec.ass_attribute19;
296 l_out_rec.ass_attribute20 :=l_main_rec.ass_attribute20;
297 l_out_rec.ass_attribute21 :=l_main_rec.ass_attribute21;
298 l_out_rec.ass_attribute22 :=l_main_rec.ass_attribute22;
299 l_out_rec.ass_attribute23 :=l_main_rec.ass_attribute23;
300 l_out_rec.ass_attribute24 :=l_main_rec.ass_attribute24;
301 l_out_rec.ass_attribute25 :=l_main_rec.ass_attribute25;
302 l_out_rec.ass_attribute26 :=l_main_rec.ass_attribute26;
303 l_out_rec.ass_attribute27 :=l_main_rec.ass_attribute27;
304 l_out_rec.ass_attribute28 :=l_main_rec.ass_attribute28;
305 l_out_rec.ass_attribute29 :=l_main_rec.ass_attribute29;
306 l_out_rec.ass_attribute30 :=l_main_rec.ass_attribute30;
307 l_out_rec.bargaining_unit_code_meaning :=l_main_rec.bargaining_unit_code_meaning;
308 l_out_rec.labour_union_member_flag :=l_main_rec.labour_union_member_flag;
309 l_out_rec.hourly_salaried_meaning :=l_main_rec.hourly_salaried_meaning;
310 l_out_rec.special_ceiling_step :=l_main_rec.special_ceiling_step;
311 l_out_rec.special_ceiling_point :=l_main_rec.special_ceiling_point;
312 l_out_rec.change_reason_meaning :=l_main_rec.change_reason_meaning;
313 l_out_rec.internal_address_line :=l_main_rec.internal_address_line;
314 l_out_rec.manager_flag :=l_main_rec.manager_flag;
315 l_out_rec.perf_review_period :=l_main_rec.perf_review_period;
316 l_out_rec.perf_rev_period_freq_meaning :=l_main_rec.perf_rev_period_freq_meaning;
317 l_out_rec.sal_review_period :=l_main_rec.sal_review_period;
318 l_out_rec.sal_rev_period_freq_meaning :=l_main_rec.sal_rev_period_freq_meaning;
319 l_out_rec.source_type_meaning :=l_main_rec.source_type_meaning;
320 l_out_rec.contract :=l_main_rec.contract;
321 l_out_rec.collective_agreement :=l_main_rec.collective_agreement;
322 l_out_rec.cagr_id_flex_name :=l_main_rec.cagr_id_flex_name;
323 l_out_rec.cagr_grade :=l_main_rec.cagr_grade;
324 --Bug 4003788
325 l_out_rec.cagr_id_flex_num :=l_main_rec.cagr_id_flex_num;
326 l_out_rec.cagr_grade_def_id :=l_main_rec.cagr_grade_def_id;
327 --Bug 4003788
328 l_out_rec.establishment :=l_main_rec.establishment;
329 l_out_rec.asg_object_version_number :=l_main_rec.asg_object_version_number;
330 l_out_rec.asg_update_allowed :=l_main_rec.asg_update_allowed;
331 l_out_rec.projected_hire_date :=l_main_rec.projected_hire_date;
332 l_out_rec.appl_attribute_category :=l_main_rec.appl_attribute_category;
333 l_out_rec.appl_attribute1 :=l_main_rec.appl_attribute1;
334 l_out_rec.appl_attribute2 :=l_main_rec.appl_attribute2;
335 l_out_rec.appl_attribute3 :=l_main_rec.appl_attribute3;
336 l_out_rec.appl_attribute4 :=l_main_rec.appl_attribute4;
337 l_out_rec.appl_attribute5 :=l_main_rec.appl_attribute5;
338 l_out_rec.appl_attribute6 :=l_main_rec.appl_attribute6;
339 l_out_rec.appl_attribute7 :=l_main_rec.appl_attribute7;
340 l_out_rec.appl_attribute8 :=l_main_rec.appl_attribute8;
341 l_out_rec.appl_attribute9 :=l_main_rec.appl_attribute9;
342 l_out_rec.appl_attribute10 :=l_main_rec.appl_attribute10;
343 l_out_rec.appl_attribute11 :=l_main_rec.appl_attribute11;
344 l_out_rec.appl_attribute12 :=l_main_rec.appl_attribute12;
345 l_out_rec.appl_attribute13 :=l_main_rec.appl_attribute13;
346 l_out_rec.appl_attribute14 :=l_main_rec.appl_attribute14;
347 l_out_rec.appl_attribute15 :=l_main_rec.appl_attribute15;
348 l_out_rec.appl_attribute16 :=l_main_rec.appl_attribute16;
349 l_out_rec.appl_attribute17 :=l_main_rec.appl_attribute17;
350 l_out_rec.appl_attribute18 :=l_main_rec.appl_attribute18;
351 l_out_rec.appl_attribute19 :=l_main_rec.appl_attribute19;
352 l_out_rec.appl_attribute20 :=l_main_rec.appl_attribute20;
353 l_out_rec.current_employer :=l_main_rec.current_employer;
354 l_out_rec.successful_flag :=l_main_rec.successful_flag;
355 l_out_rec.termination_reason_meaning :=l_main_rec.termination_reason_meaning;
356 l_out_rec.app_date_received :=l_main_rec.app_date_received;
357 l_out_rec.app_date_end :=l_main_rec.app_date_end;
358 l_out_rec.adjusted_svc_date :=l_main_rec.adjusted_svc_date;
359 l_out_rec.hire_date :=l_main_rec.hire_date;
360 l_out_rec.adr_date_from :=l_main_rec.adr_date_from;
361 l_out_rec.style :=l_main_rec.style;
362 l_out_rec.style_meaning :=l_main_rec.style_meaning;
363 l_out_rec.address_line1 :=l_main_rec.address_line1;
364 l_out_rec.address_line2 :=l_main_rec.address_line2;
365 l_out_rec.address_line3 :=l_main_rec.address_line3;
366 l_out_rec.address_type_meaning :=l_main_rec.address_type_meaning;
367 l_out_rec.address_type :=l_main_rec.address_type;
368 l_out_rec.country :=l_main_rec.country;
369 l_out_rec.adr_date_to :=l_main_rec.adr_date_to;
370 l_out_rec.postal_code :=l_main_rec.postal_code;
371 l_out_rec.region_1 :=l_main_rec.region_1;
372 l_out_rec.region_2 :=l_main_rec.region_2;
373 l_out_rec.region_3 :=l_main_rec.region_3;
374 l_out_rec.town_or_city :=l_main_rec.town_or_city;
375 l_out_rec.telephone_number_1 :=l_main_rec.telephone_number_1;
376 l_out_rec.telephone_number_2 :=l_main_rec.telephone_number_2;
377 l_out_rec.telephone_number_3 :=l_main_rec.telephone_number_3;
378 l_out_rec.add_information13 :=l_main_rec.add_information13;
379 l_out_rec.add_information14 :=l_main_rec.add_information14;
380 l_out_rec.add_information15 :=l_main_rec.add_information15;
381 l_out_rec.add_information16 :=l_main_rec.add_information16;
382 l_out_rec.add_information17 :=l_main_rec.add_information17;
383 l_out_rec.add_information18 :=l_main_rec.add_information18;
384 l_out_rec.add_information19 :=l_main_rec.add_information19;
385 l_out_rec.add_information20 :=l_main_rec.add_information20;
386 l_out_rec.addr_attribute_category :=l_main_rec.addr_attribute_category;
387 l_out_rec.addr_attribute1 :=l_main_rec.addr_attribute1;
388 l_out_rec.addr_attribute2 :=l_main_rec.addr_attribute2;
389 l_out_rec.addr_attribute3 :=l_main_rec.addr_attribute3;
390 l_out_rec.addr_attribute4 :=l_main_rec.addr_attribute4;
391 l_out_rec.addr_attribute5 :=l_main_rec.addr_attribute5;
392 l_out_rec.addr_attribute6 :=l_main_rec.addr_attribute6;
393 l_out_rec.addr_attribute7 :=l_main_rec.addr_attribute7;
394 l_out_rec.addr_attribute8 :=l_main_rec.addr_attribute8;
395 l_out_rec.addr_attribute9 :=l_main_rec.addr_attribute9;
396 l_out_rec.addr_attribute10 :=l_main_rec.addr_attribute10;
397 l_out_rec.addr_attribute11 :=l_main_rec.addr_attribute11;
398 l_out_rec.addr_attribute12 :=l_main_rec.addr_attribute12;
399 l_out_rec.addr_attribute13 :=l_main_rec.addr_attribute13;
400 l_out_rec.addr_attribute14 :=l_main_rec.addr_attribute14;
401 l_out_rec.addr_attribute15 :=l_main_rec.addr_attribute15;
402 l_out_rec.addr_attribute16 :=l_main_rec.addr_attribute16;
403 l_out_rec.addr_attribute17 :=l_main_rec.addr_attribute17;
404 l_out_rec.addr_attribute18 :=l_main_rec.addr_attribute18;
405 l_out_rec.addr_attribute19 :=l_main_rec.addr_attribute19;
406 l_out_rec.addr_attribute20 :=l_main_rec.addr_attribute20;
407 l_out_rec.phn_h_date_from :=l_main_rec.phn_h_date_from;
408 l_out_rec.phn_h_date_to :=l_main_rec.phn_h_date_to;
409 l_out_rec.phn_h_phone_number :=l_main_rec.phn_h_phone_number;
410 l_out_rec.phn_w_date_from :=l_main_rec.phn_w_date_from;
411 l_out_rec.phn_w_date_to :=l_main_rec.phn_w_date_to;
412 l_out_rec.phn_w_phone_number :=l_main_rec.phn_w_phone_number;
413 l_out_rec.phn_m_date_from :=l_main_rec.phn_m_date_from;
414 l_out_rec.phn_m_date_to :=l_main_rec.phn_m_date_to;
415 l_out_rec.phn_m_phone_number :=l_main_rec.phn_m_phone_number;
416 l_out_rec.phn_hf_date_from :=l_main_rec.phn_hf_date_from;
417 l_out_rec.phn_hf_date_to :=l_main_rec.phn_hf_date_to;
418 l_out_rec.phn_hf_phone_number :=l_main_rec.phn_hf_phone_number;
419 l_out_rec.phn_wf_date_from :=l_main_rec.phn_wf_date_from;
420 l_out_rec.phn_wf_date_to :=l_main_rec.phn_wf_date_to;
421 l_out_rec.phn_wf_phone_number :=l_main_rec.phn_wf_phone_number;
422 l_out_rec.change_date :=l_main_rec.change_date;
423 l_out_rec.proposed_salary_n :=l_main_rec.proposed_salary_n;
424 l_out_rec.currency_code :=l_main_rec.currency_code;
425 l_out_rec.proposal_reason_meaning :=l_main_rec.proposal_reason_meaning;
426 l_out_rec.pyp_attribute_category :=l_main_rec.pyp_attribute_category;
427 l_out_rec.pyp_attribute1 :=l_main_rec.pyp_attribute1;
428 l_out_rec.pyp_attribute2 :=l_main_rec.pyp_attribute2;
429 l_out_rec.pyp_attribute3 :=l_main_rec.pyp_attribute3;
430 l_out_rec.pyp_attribute4 :=l_main_rec.pyp_attribute4;
431 l_out_rec.pyp_attribute5 :=l_main_rec.pyp_attribute5;
432 l_out_rec.pyp_attribute6 :=l_main_rec.pyp_attribute6;
433 l_out_rec.pyp_attribute7 :=l_main_rec.pyp_attribute7;
434 l_out_rec.pyp_attribute8 :=l_main_rec.pyp_attribute8;
435 l_out_rec.pyp_attribute9 :=l_main_rec.pyp_attribute9;
436 l_out_rec.pyp_attribute10 :=l_main_rec.pyp_attribute10;
437 l_out_rec.pyp_attribute11 :=l_main_rec.pyp_attribute11;
438 l_out_rec.pyp_attribute12 :=l_main_rec.pyp_attribute12;
439 l_out_rec.pyp_attribute13 :=l_main_rec.pyp_attribute13;
440 l_out_rec.pyp_attribute14 :=l_main_rec.pyp_attribute14;
441 l_out_rec.pyp_attribute15 :=l_main_rec.pyp_attribute15;
442 l_out_rec.pyp_attribute16 :=l_main_rec.pyp_attribute16;
443 l_out_rec.pyp_attribute17 :=l_main_rec.pyp_attribute17;
444 l_out_rec.pyp_attribute18 :=l_main_rec.pyp_attribute18;
445 l_out_rec.pyp_attribute19 :=l_main_rec.pyp_attribute19;
446 l_out_rec.pyp_attribute20 :=l_main_rec.pyp_attribute20;
447 l_out_rec.approved :=l_main_rec.approved;
448 l_out_rec.work_any_country :=l_main_rec.work_any_country;
449 l_out_rec.work_any_location :=l_main_rec.work_any_location;
450 l_out_rec.relocate_domestically :=l_main_rec.relocate_domestically;
451 l_out_rec.relocate_internationally :=l_main_rec.relocate_internationally;
452 l_out_rec.travel_required :=l_main_rec.travel_required;
453 l_out_rec.country1_meaning :=l_main_rec.country1_meaning;
454 l_out_rec.country2_meaning :=l_main_rec.country2_meaning;
455 l_out_rec.country3_meaning :=l_main_rec.country3_meaning;
456 l_out_rec.dpf_work_duration_meaning :=l_main_rec.dpf_work_duration_meaning;
457 l_out_rec.dpf_work_schedule_meaning :=l_main_rec.dpf_work_schedule_meaning;
458 l_out_rec.dpf_work_hours_meaning :=l_main_rec.dpf_work_hours_meaning;
459 l_out_rec.dpf_fte_capacity_meaning :=l_main_rec.dpf_fte_capacity_meaning;
460 l_out_rec.visit_internationally :=l_main_rec.visit_internationally;
461 l_out_rec.only_current_location :=l_main_rec.only_current_location;
462 l_out_rec.no_country1_meaning :=l_main_rec.no_country1_meaning;
463 l_out_rec.no_country2_meaning :=l_main_rec.no_country2_meaning;
464 l_out_rec.no_country3_meaning :=l_main_rec.no_country3_meaning;
465 l_out_rec.earliest_available_date :=l_main_rec.earliest_available_date;
466 l_out_rec.available_for_transfer :=l_main_rec.available_for_transfer;
467 l_out_rec.relocation_pref_meaning :=l_main_rec.relocation_pref_meaning;
468 l_out_rec.relocation_preference :=l_main_rec.relocation_preference;
469 l_out_rec.dpf_attribute_category :=l_main_rec.dpf_attribute_category;
470 l_out_rec.dpf_attribute1 :=l_main_rec.dpf_attribute1;
471 l_out_rec.dpf_attribute2 :=l_main_rec.dpf_attribute2;
472 l_out_rec.dpf_attribute3 :=l_main_rec.dpf_attribute3;
473 l_out_rec.dpf_attribute4 :=l_main_rec.dpf_attribute4;
474 l_out_rec.dpf_attribute5 :=l_main_rec.dpf_attribute5;
475 l_out_rec.dpf_attribute6 :=l_main_rec.dpf_attribute6;
476 l_out_rec.dpf_attribute7 :=l_main_rec.dpf_attribute7;
477 l_out_rec.dpf_attribute8 :=l_main_rec.dpf_attribute8;
478 l_out_rec.dpf_attribute9 :=l_main_rec.dpf_attribute9;
479 l_out_rec.dpf_attribute10 :=l_main_rec.dpf_attribute10;
480 l_out_rec.dpf_attribute11 :=l_main_rec.dpf_attribute11;
481 l_out_rec.dpf_attribute12 :=l_main_rec.dpf_attribute12;
482 l_out_rec.dpf_attribute13 :=l_main_rec.dpf_attribute13;
483 l_out_rec.dpf_attribute14 :=l_main_rec.dpf_attribute14;
484 l_out_rec.dpf_attribute15 :=l_main_rec.dpf_attribute15;
485 l_out_rec.dpf_attribute16 :=l_main_rec.dpf_attribute16;
486 l_out_rec.dpf_attribute17 :=l_main_rec.dpf_attribute17;
487 l_out_rec.dpf_attribute18 :=l_main_rec.dpf_attribute18;
488 l_out_rec.dpf_attribute19 :=l_main_rec.dpf_attribute19;
489 l_out_rec.dpf_attribute20 :=l_main_rec.dpf_attribute20;
490 l_out_rec.chk1_checklist_item_id :=l_main_rec.chk1_checklist_item_id;
491 l_out_rec.chk1_item_code_meaning :=l_main_rec.chk1_item_code_meaning;
492 l_out_rec.chk1_item_code :=l_main_rec.chk1_item_code;
493 l_out_rec.chk1_date_due :=l_main_rec.chk1_date_due;
494 l_out_rec.chk1_date_done :=l_main_rec.chk1_date_done;
495 l_out_rec.chk1_status_meaning :=l_main_rec.chk1_status_meaning;
496 l_out_rec.chk1_status :=l_main_rec.chk1_status;
497 l_out_rec.chk1_notes :=l_main_rec.chk1_notes;
498 l_out_rec.chk1_object_version_number :=l_main_rec.chk1_object_version_number;
499 l_out_rec.chk2_checklist_item_id :=l_main_rec.chk2_checklist_item_id;
500 l_out_rec.chk2_item_code_meaning :=l_main_rec.chk2_item_code_meaning;
501 l_out_rec.chk2_item_code :=l_main_rec.chk2_item_code;
502 l_out_rec.chk2_date_due :=l_main_rec.chk2_date_due;
503 l_out_rec.chk2_date_done :=l_main_rec.chk2_date_done;
504 l_out_rec.chk2_status_meaning :=l_main_rec.chk2_status_meaning;
505 l_out_rec.chk2_status :=l_main_rec.chk2_status;
506 l_out_rec.chk2_notes :=l_main_rec.chk2_notes;
507 l_out_rec.chk2_object_version_number :=l_main_rec.chk2_object_version_number;
508 l_out_rec.chk3_checklist_item_id :=l_main_rec.chk3_checklist_item_id;
509 l_out_rec.chk3_item_code_meaning :=l_main_rec.chk3_item_code_meaning;
510 l_out_rec.chk3_item_code :=l_main_rec.chk3_item_code;
511 l_out_rec.chk3_date_due :=l_main_rec.chk3_date_due;
512 l_out_rec.chk3_date_done :=l_main_rec.chk3_date_done;
513 l_out_rec.chk3_status_meaning :=l_main_rec.chk3_status_meaning;
514 l_out_rec.chk3_status :=l_main_rec.chk3_status;
515 l_out_rec.chk3_notes :=l_main_rec.chk3_notes;
516 l_out_rec.chk3_object_version_number :=l_main_rec.chk3_object_version_number;
517 l_out_rec.chk4_checklist_item_id :=l_main_rec.chk4_checklist_item_id;
518 l_out_rec.chk4_item_code_meaning :=l_main_rec.chk4_item_code_meaning;
519 l_out_rec.chk4_item_code :=l_main_rec.chk4_item_code;
520 l_out_rec.chk4_date_due :=l_main_rec.chk4_date_due;
521 l_out_rec.chk4_date_done :=l_main_rec.chk4_date_done;
522 l_out_rec.chk4_status_meaning :=l_main_rec.chk4_status_meaning;
523 l_out_rec.chk4_status :=l_main_rec.chk4_status;
524 l_out_rec.chk4_notes :=l_main_rec.chk4_notes;
525 l_out_rec.chk4_object_version_number :=l_main_rec.chk4_object_version_number;
526 l_out_rec.chk5_checklist_item_id :=l_main_rec.chk5_checklist_item_id;
527 l_out_rec.chk5_item_code_meaning :=l_main_rec.chk5_item_code_meaning;
528 l_out_rec.chk5_item_code :=l_main_rec.chk5_item_code;
529 l_out_rec.chk5_date_due :=l_main_rec.chk5_date_due;
530 l_out_rec.chk5_date_done :=l_main_rec.chk5_date_done;
531 l_out_rec.chk5_status_meaning :=l_main_rec.chk5_status_meaning;
532 l_out_rec.chk5_status :=l_main_rec.chk5_status;
533 l_out_rec.chk5_notes :=l_main_rec.chk5_notes;
534 l_out_rec.chk5_object_version_number :=l_main_rec.chk5_object_version_number;
535 l_out_rec.chk6_checklist_item_id :=l_main_rec.chk6_checklist_item_id;
536 l_out_rec.chk6_item_code_meaning :=l_main_rec.chk6_item_code_meaning;
537 l_out_rec.chk6_item_code :=l_main_rec.chk6_item_code;
538 l_out_rec.chk6_date_due :=l_main_rec.chk6_date_due;
539 l_out_rec.chk6_date_done :=l_main_rec.chk6_date_done;
540 l_out_rec.chk6_status_meaning :=l_main_rec.chk6_status_meaning;
541 l_out_rec.chk6_status :=l_main_rec.chk6_status;
542 l_out_rec.chk6_notes :=l_main_rec.chk6_notes;
543 l_out_rec.chk6_object_version_number :=l_main_rec.chk6_object_version_number;
544 l_out_rec.chk7_checklist_item_id :=l_main_rec.chk7_checklist_item_id;
545 l_out_rec.chk7_item_code_meaning :=l_main_rec.chk7_item_code_meaning;
546 l_out_rec.chk7_item_code :=l_main_rec.chk7_item_code;
547 l_out_rec.chk7_date_due :=l_main_rec.chk7_date_due;
548 l_out_rec.chk7_date_done :=l_main_rec.chk7_date_done;
549 l_out_rec.chk7_status_meaning :=l_main_rec.chk7_status_meaning;
550 l_out_rec.chk7_status :=l_main_rec.chk7_status;
551 l_out_rec.chk7_notes :=l_main_rec.chk7_notes;
552 l_out_rec.chk7_object_version_number :=l_main_rec.chk7_object_version_number;
553 l_out_rec.chk8_checklist_item_id :=l_main_rec.chk8_checklist_item_id;
554 l_out_rec.chk8_item_code_meaning :=l_main_rec.chk8_item_code_meaning;
555 l_out_rec.chk8_item_code :=l_main_rec.chk8_item_code;
556 l_out_rec.chk8_date_due :=l_main_rec.chk8_date_due;
557 l_out_rec.chk8_date_done :=l_main_rec.chk8_date_done;
558 l_out_rec.chk8_status_meaning :=l_main_rec.chk8_status_meaning;
559 l_out_rec.chk8_status :=l_main_rec.chk8_status;
560 l_out_rec.chk8_notes :=l_main_rec.chk8_notes;
561 l_out_rec.chk8_object_version_number :=l_main_rec.chk8_object_version_number;
562 l_out_rec.chk9_checklist_item_id :=l_main_rec.chk9_checklist_item_id;
563 l_out_rec.chk9_item_code_meaning :=l_main_rec.chk9_item_code_meaning;
564 l_out_rec.chk9_item_code :=l_main_rec.chk9_item_code;
565 l_out_rec.chk9_date_due :=l_main_rec.chk9_date_due;
566 l_out_rec.chk9_date_done :=l_main_rec.chk9_date_done;
567 l_out_rec.chk9_status_meaning :=l_main_rec.chk9_status_meaning;
568 l_out_rec.chk9_status :=l_main_rec.chk9_status;
569 l_out_rec.chk9_notes :=l_main_rec.chk9_notes;
570 l_out_rec.chk9_object_version_number :=l_main_rec.chk9_object_version_number;
571 l_out_rec.chk10_checklist_item_id :=l_main_rec.chk10_checklist_item_id;
572 l_out_rec.chk10_item_code_meaning :=l_main_rec.chk10_item_code_meaning;
573 l_out_rec.chk10_item_code :=l_main_rec.chk10_item_code;
574 l_out_rec.chk10_date_due :=l_main_rec.chk10_date_due;
575 l_out_rec.chk10_date_done :=l_main_rec.chk10_date_done;
576 l_out_rec.chk10_status_meaning :=l_main_rec.chk10_status_meaning;
577 l_out_rec.chk10_status :=l_main_rec.chk10_status;
578 l_out_rec.chk10_notes :=l_main_rec.chk10_notes;
579 l_out_rec.chk10_object_version_number :=l_main_rec.chk10_object_version_number;
580 l_out_rec.tax_effective_start_date :=l_main_rec.tax_effective_start_date;
581 l_out_rec.tax_effective_end_date :=l_main_rec.tax_effective_end_date;
582 l_out_rec.tax_field1 :=l_main_rec.tax_field1;
583 l_out_rec.tax_field2 :=l_main_rec.tax_field2;
584 l_out_rec.tax_field3 :=l_main_rec.tax_field3;
585 l_out_rec.tax_field4 :=l_main_rec.tax_field4;
586 l_out_rec.tax_field5 :=l_main_rec.tax_field5;
587 l_out_rec.tax_field6 :=l_main_rec.tax_field6;
588 l_out_rec.tax_field7 :=l_main_rec.tax_field7;
589 l_out_rec.tax_field8 :=l_main_rec.tax_field8;
590 l_out_rec.tax_field9 :=l_main_rec.tax_field9;
591 l_out_rec.tax_field10 :=l_main_rec.tax_field10;
592 l_out_rec.tax_field11 :=l_main_rec.tax_field11;
593 l_out_rec.tax_field12 :=l_main_rec.tax_field12;
594 l_out_rec.tax_field13 :=l_main_rec.tax_field13;
595 l_out_rec.tax_field14 :=l_main_rec.tax_field14;
596 l_out_rec.tax_field15 :=l_main_rec.tax_field15;
597 l_out_rec.tax_field16 :=l_main_rec.tax_field16;
598 l_out_rec.tax_field17 :=l_main_rec.tax_field17;
599 l_out_rec.tax_field18 :=l_main_rec.tax_field18;
600 l_out_rec.tax_field19 :=l_main_rec.tax_field19;
601 l_out_rec.tax_field20 :=l_main_rec.tax_field20;
602 l_out_rec.tax_field21 :=l_main_rec.tax_field21;
603 l_out_rec.tax_field22 :=l_main_rec.tax_field22;
604 l_out_rec.tax_field23 :=l_main_rec.tax_field23;
605 l_out_rec.tax_field24 :=l_main_rec.tax_field24;
606 l_out_rec.tax_field25 :=l_main_rec.tax_field25;
607 l_out_rec.tax_field26 :=l_main_rec.tax_field26;
608 l_out_rec.tax_field27 :=l_main_rec.tax_field27;
609 l_out_rec.tax_field28 :=l_main_rec.tax_field28;
610 l_out_rec.tax_field29 :=l_main_rec.tax_field29;
611 l_out_rec.tax_field30 :=l_main_rec.tax_field30;
612 l_out_rec.tax_field31 :=l_main_rec.tax_field31;
613 l_out_rec.tax_field32 :=l_main_rec.tax_field32;
614 l_out_rec.tax_field33 :=l_main_rec.tax_field33;
615 l_out_rec.tax_field34 :=l_main_rec.tax_field34;
616 l_out_rec.tax_field35 :=l_main_rec.tax_field35;
617 l_out_rec.tax_field36 :=l_main_rec.tax_field36;
618 l_out_rec.tax_field37 :=l_main_rec.tax_field37;
619 l_out_rec.tax_field38 :=l_main_rec.tax_field38;
620 l_out_rec.tax_field39 :=l_main_rec.tax_field39;
621 l_out_rec.tax_field40 :=l_main_rec.tax_field40;
622 l_out_rec.tax_field41 :=l_main_rec.tax_field41;
623 l_out_rec.tax_field42 :=l_main_rec.tax_field42;
624 l_out_rec.tax_field43 :=l_main_rec.tax_field43;
625 l_out_rec.tax_field44 :=l_main_rec.tax_field44;
626 l_out_rec.tax_field45 :=l_main_rec.tax_field45;
627 l_out_rec.tax_field46 :=l_main_rec.tax_field46;
628 l_out_rec.tax_field47 :=l_main_rec.tax_field47;
629 l_out_rec.tax_field48 :=l_main_rec.tax_field48;
630 l_out_rec.tax_field49 :=l_main_rec.tax_field49;
631 l_out_rec.tax_field50 :=l_main_rec.tax_field50;
632 l_out_rec.tax_field51 :=l_main_rec.tax_field51;
633 l_out_rec.tax_field52 :=l_main_rec.tax_field52;
634 l_out_rec.tax_field53 :=l_main_rec.tax_field53;
635 l_out_rec.tax_field54 :=l_main_rec.tax_field54;
636 l_out_rec.tax_field55 :=l_main_rec.tax_field55;
637 l_out_rec.tax_field56 :=l_main_rec.tax_field56;
638 l_out_rec.tax_field57 :=l_main_rec.tax_field57;
639 l_out_rec.tax_field58 :=l_main_rec.tax_field58;
640 l_out_rec.tax_field59 :=l_main_rec.tax_field59;
641 l_out_rec.tax_field60 :=l_main_rec.tax_field60;
642 l_out_rec.tax_field61 :=l_main_rec.tax_field61;
643 l_out_rec.tax_field62 :=l_main_rec.tax_field62;
644 l_out_rec.tax_field63 :=l_main_rec.tax_field63;
645 l_out_rec.tax_field64 :=l_main_rec.tax_field64;
646 l_out_rec.tax_field65 :=l_main_rec.tax_field65;
647 l_out_rec.tax_field66 :=l_main_rec.tax_field66;
648 l_out_rec.tax_field67 :=l_main_rec.tax_field67;
649 l_out_rec.tax_field68 :=l_main_rec.tax_field68;
650 l_out_rec.tax_field69 :=l_main_rec.tax_field69;
651 l_out_rec.tax_field70 :=l_main_rec.tax_field70;
652 l_out_rec.tax_field71 :=l_main_rec.tax_field71;
653 l_out_rec.tax_field72 :=l_main_rec.tax_field72;
654 l_out_rec.tax_field73 :=l_main_rec.tax_field73;
655 l_out_rec.tax_field74 :=l_main_rec.tax_field74;
656 l_out_rec.tax_field75 :=l_main_rec.tax_field75;
657 l_out_rec.tax_field76 :=l_main_rec.tax_field76;
658 l_out_rec.tax_field77 :=l_main_rec.tax_field77;
659 l_out_rec.tax_field78 :=l_main_rec.tax_field78;
660 l_out_rec.tax_field79 :=l_main_rec.tax_field79;
661 l_out_rec.tax_field80 :=l_main_rec.tax_field80;
662 l_out_rec.tax_field81 :=l_main_rec.tax_field81;
663 l_out_rec.tax_field82 :=l_main_rec.tax_field82;
664 l_out_rec.tax_field83 :=l_main_rec.tax_field83;
665 l_out_rec.tax_field84 :=l_main_rec.tax_field84;
666 l_out_rec.tax_field85 :=l_main_rec.tax_field85;
667 l_out_rec.tax_field86 :=l_main_rec.tax_field86;
668 l_out_rec.tax_field87 :=l_main_rec.tax_field87;
669 l_out_rec.tax_field88 :=l_main_rec.tax_field88;
670 l_out_rec.tax_field89 :=l_main_rec.tax_field89;
671 l_out_rec.tax_field90 :=l_main_rec.tax_field90;
672 l_out_rec.tax_field91 :=l_main_rec.tax_field91;
673 l_out_rec.tax_field92 :=l_main_rec.tax_field92;
674 l_out_rec.tax_field93 :=l_main_rec.tax_field93;
675 l_out_rec.tax_field94 :=l_main_rec.tax_field94;
676 l_out_rec.tax_field95 :=l_main_rec.tax_field95;
677 l_out_rec.tax_field96 :=l_main_rec.tax_field96;
678 l_out_rec.tax_field97 :=l_main_rec.tax_field97;
679 l_out_rec.tax_field98 :=l_main_rec.tax_field98;
680 l_out_rec.tax_field99 :=l_main_rec.tax_field99;
681 l_out_rec.tax_field100 :=l_main_rec.tax_field100;
682 l_out_rec.tax_field101 :=l_main_rec.tax_field101;
683 l_out_rec.tax_field102 :=l_main_rec.tax_field102;
684 l_out_rec.tax_field103 :=l_main_rec.tax_field103;
685 l_out_rec.tax_field104 :=l_main_rec.tax_field104;
686 l_out_rec.tax_field105 :=l_main_rec.tax_field105;
687 l_out_rec.tax_field106 :=l_main_rec.tax_field106;
688 l_out_rec.tax_field107 :=l_main_rec.tax_field107;
689 l_out_rec.tax_field108 :=l_main_rec.tax_field108;
690 l_out_rec.tax_field109 :=l_main_rec.tax_field109;
691 l_out_rec.tax_field110 :=l_main_rec.tax_field110;
692 l_out_rec.tax_field111 :=l_main_rec.tax_field111;
693 l_out_rec.tax_field112 :=l_main_rec.tax_field112;
694 l_out_rec.tax_field113 :=l_main_rec.tax_field113;
695 l_out_rec.tax_field114 :=l_main_rec.tax_field114;
696 l_out_rec.tax_field115 :=l_main_rec.tax_field115;
697 l_out_rec.tax_field116 :=l_main_rec.tax_field116;
698 l_out_rec.tax_field117 :=l_main_rec.tax_field117;
699 l_out_rec.tax_field118 :=l_main_rec.tax_field118;
700 l_out_rec.tax_field119 :=l_main_rec.tax_field119;
701 l_out_rec.tax_field120 :=l_main_rec.tax_field120;
702 l_out_rec.tax_field121 :=l_main_rec.tax_field121;
703 l_out_rec.tax_field122 :=l_main_rec.tax_field122;
704 l_out_rec.tax_field123 :=l_main_rec.tax_field123;
705 l_out_rec.tax_field124 :=l_main_rec.tax_field124;
706 l_out_rec.tax_field125 :=l_main_rec.tax_field125;
707 l_out_rec.tax_field126 :=l_main_rec.tax_field126;
708 l_out_rec.tax_field127 :=l_main_rec.tax_field127;
709 l_out_rec.tax_field128 :=l_main_rec.tax_field128;
710 l_out_rec.tax_field129 :=l_main_rec.tax_field129;
711 l_out_rec.tax_field130 :=l_main_rec.tax_field130;
712 l_out_rec.tax_field131 :=l_main_rec.tax_field131;
713 l_out_rec.tax_field132 :=l_main_rec.tax_field132;
714 l_out_rec.tax_field133 :=l_main_rec.tax_field133;
715 l_out_rec.tax_field134 :=l_main_rec.tax_field134;
716 l_out_rec.tax_field135 :=l_main_rec.tax_field135;
717 l_out_rec.tax_field136 :=l_main_rec.tax_field136;
718 l_out_rec.tax_field137 :=l_main_rec.tax_field137;
719 l_out_rec.tax_field138 :=l_main_rec.tax_field138;
720 l_out_rec.tax_field139 :=l_main_rec.tax_field139;
721 l_out_rec.tax_field140 :=l_main_rec.tax_field140;
722 l_out_rec.tax_field141 :=l_main_rec.tax_field141;
723 l_out_rec.tax_field142 :=l_main_rec.tax_field142;
724 l_out_rec.tax_field143 :=l_main_rec.tax_field143;
725 l_out_rec.tax_field144 :=l_main_rec.tax_field144;
726 l_out_rec.tax_field145 :=l_main_rec.tax_field145;
727 l_out_rec.tax_field146 :=l_main_rec.tax_field146;
728 l_out_rec.tax_field147 :=l_main_rec.tax_field147;
729 l_out_rec.tax_field148 :=l_main_rec.tax_field148;
730 l_out_rec.tax_field149 :=l_main_rec.tax_field149;
731 l_out_rec.tax_field150 :=l_main_rec.tax_field150;
732 --
733 open csr_establishment(p_person_id);
734 fetch csr_establishment into
735 l_out_rec.ea1_attended_start_date
736 ,l_out_rec.ea1_establishment
737 ,l_out_rec.ea1_full_time
738 ,l_out_rec.ea1_attended_end_date;
739 if csr_establishment%found then
740 fetch csr_establishment into
741 l_out_rec.ea2_attended_start_date
742 ,l_out_rec.ea2_establishment
743 ,l_out_rec.ea2_full_time
744 ,l_out_rec.ea2_attended_end_date;
745 if csr_establishment%found then
746 fetch csr_establishment into
747 l_out_rec.ea3_attended_start_date
748 ,l_out_rec.ea3_establishment
749 ,l_out_rec.ea3_full_time
750 ,l_out_rec.ea3_attended_end_date;
751 if csr_establishment%found then
752 fetch csr_establishment into
753 l_out_rec.ea4_attended_start_date
754 ,l_out_rec.ea4_establishment
755 ,l_out_rec.ea4_full_time
756 ,l_out_rec.ea4_attended_end_date;
757 end if;
758 end if;
759 end if;
760 close csr_establishment;
761
762 resultset(1):=l_out_rec;
763 end sumquery;
764
765 end per_qh_summary_query;