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