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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );