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