[Home] [Help]
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
28: ,project_title per_all_assignments_f.project_title%type
29: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
30: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
31: ,vendor_name po_vendors.vendor_name%type
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
25: ,full_name per_all_people_f.full_name%type
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
28: ,project_title per_all_assignments_f.project_title%type
29: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
30: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
31: ,vendor_name po_vendors.vendor_name%type
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
33: ,po_header_num po_headers_all.segment1%TYPE
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
28: ,project_title per_all_assignments_f.project_title%type
29: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
30: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
31: ,vendor_name po_vendors.vendor_name%type
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
33: ,po_header_num po_headers_all.segment1%TYPE
34: ,po_line_num po_lines_all.line_num%TYPE
254: ,per_information30_m varchar2(150)
255: ,date_of_death per_all_people_f.date_of_death%type
256: ,hire_date per_periods_of_service.date_start%type
257: ,projected_hire_date per_applications.projected_hire_date%type
258: ,assignment_id per_all_assignments_f.assignment_id%type
259: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
260: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
261: ,recruiter per_all_people_f.full_name%type
262: ,grade per_grades.name%type
255: ,date_of_death per_all_people_f.date_of_death%type
256: ,hire_date per_periods_of_service.date_start%type
257: ,projected_hire_date per_applications.projected_hire_date%type
258: ,assignment_id per_all_assignments_f.assignment_id%type
259: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
260: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
261: ,recruiter per_all_people_f.full_name%type
262: ,grade per_grades.name%type
263: ,grade_ladder ben_pgm_f.name%type
256: ,hire_date per_periods_of_service.date_start%type
257: ,projected_hire_date per_applications.projected_hire_date%type
258: ,assignment_id per_all_assignments_f.assignment_id%type
259: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
260: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
261: ,recruiter per_all_people_f.full_name%type
262: ,grade per_grades.name%type
263: ,grade_ladder ben_pgm_f.name%type
264: ,position hr_all_positions_f.name%type
362: ,pgp_segment29_m varchar2(150)
363: ,pgp_segment30 pay_people_groups.segment30%type
364: ,pgp_segment30_v varchar2(150)
365: ,pgp_segment30_m varchar2(150)
366: ,people_group_id per_all_assignments_f.people_group_id%type
367: ,scl_segment1 hr_soft_coding_keyflex.segment1%type
368: ,scl_segment1_v varchar2(150)
369: ,scl_segment1_m varchar2(150)
370: ,scl_segment2 hr_soft_coding_keyflex.segment2%type
453: ,scl_segment29_m varchar2(150)
454: ,scl_segment30 hr_soft_coding_keyflex.segment30%type
455: ,scl_segment30_v varchar2(150)
456: ,scl_segment30_m varchar2(150)
457: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type
458: ,vacancy per_vacancies.name%type
459: ,requisition per_requisitions.name%type default null
460: ,salary_basis per_pay_bases.name%type
461: ,pay_basis per_pay_bases.pay_basis%type
458: ,vacancy per_vacancies.name%type
459: ,requisition per_requisitions.name%type default null
460: ,salary_basis per_pay_bases.name%type
461: ,pay_basis per_pay_bases.pay_basis%type
462: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
463: ,assignment_type per_all_assignments_f.assignment_type%type
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
459: ,requisition per_requisitions.name%type default null
460: ,salary_basis per_pay_bases.name%type
461: ,pay_basis per_pay_bases.pay_basis%type
462: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
463: ,assignment_type per_all_assignments_f.assignment_type%type
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
460: ,salary_basis per_pay_bases.name%type
461: ,pay_basis per_pay_bases.pay_basis%type
462: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
463: ,assignment_type per_all_assignments_f.assignment_type%type
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
461: ,pay_basis per_pay_bases.pay_basis%type
462: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
463: ,assignment_type per_all_assignments_f.assignment_type%type
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
462: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
463: ,assignment_type per_all_assignments_f.assignment_type%type
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
463: ,assignment_type per_all_assignments_f.assignment_type%type
464: ,asg_primary_flag per_all_assignments_f.primary_flag%type
465: ,assignment_number per_all_assignments_f.assignment_number%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
466: ,date_probation_end per_all_assignments_f.date_probation_end%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
473: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
474: ,time_normal_start per_all_assignments_f.time_normal_start%type
467: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468: ,employment_category_meaning hr_lookups.meaning%type
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
473: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
474: ,time_normal_start per_all_assignments_f.time_normal_start%type
475: /* These fields are no longer used because they may change
469: ,frequency_meaning hr_lookups.meaning%type
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
473: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
474: ,time_normal_start per_all_assignments_f.time_normal_start%type
475: /* These fields are no longer used because they may change
476: context on a row by row basis, making them meaningless in a table
477:
470: ,normal_hours per_all_assignments_f.normal_hours%type
471: ,probation_period per_all_assignments_f.probation_period%type
472: ,probation_unit_meaning hr_lookups.meaning%type
473: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
474: ,time_normal_start per_all_assignments_f.time_normal_start%type
475: /* These fields are no longer used because they may change
476: context on a row by row basis, making them meaningless in a table
477:
478: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
474: ,time_normal_start per_all_assignments_f.time_normal_start%type
475: /* These fields are no longer used because they may change
476: context on a row by row basis, making them meaningless in a table
477:
478: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
479: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
480: ,ass_attribute1_v varchar2(150)
481: ,ass_attribute1_m varchar2(150)
482: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
475: /* These fields are no longer used because they may change
476: context on a row by row basis, making them meaningless in a table
477:
478: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
479: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
480: ,ass_attribute1_v varchar2(150)
481: ,ass_attribute1_m varchar2(150)
482: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
483: ,ass_attribute2_v varchar2(150)
478: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
479: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
480: ,ass_attribute1_v varchar2(150)
481: ,ass_attribute1_m varchar2(150)
482: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
483: ,ass_attribute2_v varchar2(150)
484: ,ass_attribute2_m varchar2(150)
485: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
486: ,ass_attribute3_v varchar2(150)
481: ,ass_attribute1_m varchar2(150)
482: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
483: ,ass_attribute2_v varchar2(150)
484: ,ass_attribute2_m varchar2(150)
485: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
486: ,ass_attribute3_v varchar2(150)
487: ,ass_attribute3_m varchar2(150)
488: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
489: ,ass_attribute4_v varchar2(150)
484: ,ass_attribute2_m varchar2(150)
485: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
486: ,ass_attribute3_v varchar2(150)
487: ,ass_attribute3_m varchar2(150)
488: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
489: ,ass_attribute4_v varchar2(150)
490: ,ass_attribute4_m varchar2(150)
491: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
492: ,ass_attribute5_v varchar2(150)
487: ,ass_attribute3_m varchar2(150)
488: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
489: ,ass_attribute4_v varchar2(150)
490: ,ass_attribute4_m varchar2(150)
491: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
492: ,ass_attribute5_v varchar2(150)
493: ,ass_attribute5_m varchar2(150)
494: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
495: ,ass_attribute6_v varchar2(150)
490: ,ass_attribute4_m varchar2(150)
491: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
492: ,ass_attribute5_v varchar2(150)
493: ,ass_attribute5_m varchar2(150)
494: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
495: ,ass_attribute6_v varchar2(150)
496: ,ass_attribute6_m varchar2(150)
497: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
498: ,ass_attribute7_v varchar2(150)
493: ,ass_attribute5_m varchar2(150)
494: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
495: ,ass_attribute6_v varchar2(150)
496: ,ass_attribute6_m varchar2(150)
497: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
498: ,ass_attribute7_v varchar2(150)
499: ,ass_attribute7_m varchar2(150)
500: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
501: ,ass_attribute8_v varchar2(150)
496: ,ass_attribute6_m varchar2(150)
497: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
498: ,ass_attribute7_v varchar2(150)
499: ,ass_attribute7_m varchar2(150)
500: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
501: ,ass_attribute8_v varchar2(150)
502: ,ass_attribute8_m varchar2(150)
503: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
504: ,ass_attribute9_v varchar2(150)
499: ,ass_attribute7_m varchar2(150)
500: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
501: ,ass_attribute8_v varchar2(150)
502: ,ass_attribute8_m varchar2(150)
503: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
504: ,ass_attribute9_v varchar2(150)
505: ,ass_attribute9_m varchar2(150)
506: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
507: ,ass_attribute10_v varchar2(150)
502: ,ass_attribute8_m varchar2(150)
503: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
504: ,ass_attribute9_v varchar2(150)
505: ,ass_attribute9_m varchar2(150)
506: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
507: ,ass_attribute10_v varchar2(150)
508: ,ass_attribute10_m varchar2(150)
509: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
510: ,ass_attribute11_v varchar2(150)
505: ,ass_attribute9_m varchar2(150)
506: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
507: ,ass_attribute10_v varchar2(150)
508: ,ass_attribute10_m varchar2(150)
509: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
510: ,ass_attribute11_v varchar2(150)
511: ,ass_attribute11_m varchar2(150)
512: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
513: ,ass_attribute12_v varchar2(150)
508: ,ass_attribute10_m varchar2(150)
509: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
510: ,ass_attribute11_v varchar2(150)
511: ,ass_attribute11_m varchar2(150)
512: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
513: ,ass_attribute12_v varchar2(150)
514: ,ass_attribute12_m varchar2(150)
515: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
516: ,ass_attribute13_v varchar2(150)
511: ,ass_attribute11_m varchar2(150)
512: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
513: ,ass_attribute12_v varchar2(150)
514: ,ass_attribute12_m varchar2(150)
515: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
516: ,ass_attribute13_v varchar2(150)
517: ,ass_attribute13_m varchar2(150)
518: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
519: ,ass_attribute14_v varchar2(150)
514: ,ass_attribute12_m varchar2(150)
515: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
516: ,ass_attribute13_v varchar2(150)
517: ,ass_attribute13_m varchar2(150)
518: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
519: ,ass_attribute14_v varchar2(150)
520: ,ass_attribute14_m varchar2(150)
521: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
522: ,ass_attribute15_v varchar2(150)
517: ,ass_attribute13_m varchar2(150)
518: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
519: ,ass_attribute14_v varchar2(150)
520: ,ass_attribute14_m varchar2(150)
521: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
522: ,ass_attribute15_v varchar2(150)
523: ,ass_attribute15_m varchar2(150)
524: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
525: ,ass_attribute16_v varchar2(150)
520: ,ass_attribute14_m varchar2(150)
521: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
522: ,ass_attribute15_v varchar2(150)
523: ,ass_attribute15_m varchar2(150)
524: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
525: ,ass_attribute16_v varchar2(150)
526: ,ass_attribute16_m varchar2(150)
527: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
528: ,ass_attribute17_v varchar2(150)
523: ,ass_attribute15_m varchar2(150)
524: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
525: ,ass_attribute16_v varchar2(150)
526: ,ass_attribute16_m varchar2(150)
527: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
528: ,ass_attribute17_v varchar2(150)
529: ,ass_attribute17_m varchar2(150)
530: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
531: ,ass_attribute18_v varchar2(150)
526: ,ass_attribute16_m varchar2(150)
527: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
528: ,ass_attribute17_v varchar2(150)
529: ,ass_attribute17_m varchar2(150)
530: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
531: ,ass_attribute18_v varchar2(150)
532: ,ass_attribute18_m varchar2(150)
533: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
534: ,ass_attribute19_v varchar2(150)
529: ,ass_attribute17_m varchar2(150)
530: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
531: ,ass_attribute18_v varchar2(150)
532: ,ass_attribute18_m varchar2(150)
533: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
534: ,ass_attribute19_v varchar2(150)
535: ,ass_attribute19_m varchar2(150)
536: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
537: ,ass_attribute20_v varchar2(150)
532: ,ass_attribute18_m varchar2(150)
533: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
534: ,ass_attribute19_v varchar2(150)
535: ,ass_attribute19_m varchar2(150)
536: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
537: ,ass_attribute20_v varchar2(150)
538: ,ass_attribute20_m varchar2(150)
539: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
540: ,ass_attribute21_v varchar2(150)
535: ,ass_attribute19_m varchar2(150)
536: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
537: ,ass_attribute20_v varchar2(150)
538: ,ass_attribute20_m varchar2(150)
539: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
540: ,ass_attribute21_v varchar2(150)
541: ,ass_attribute21_m varchar2(150)
542: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
543: ,ass_attribute22_v varchar2(150)
538: ,ass_attribute20_m varchar2(150)
539: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
540: ,ass_attribute21_v varchar2(150)
541: ,ass_attribute21_m varchar2(150)
542: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
543: ,ass_attribute22_v varchar2(150)
544: ,ass_attribute22_m varchar2(150)
545: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
546: ,ass_attribute23_v varchar2(150)
541: ,ass_attribute21_m varchar2(150)
542: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
543: ,ass_attribute22_v varchar2(150)
544: ,ass_attribute22_m varchar2(150)
545: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
546: ,ass_attribute23_v varchar2(150)
547: ,ass_attribute23_m varchar2(150)
548: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
549: ,ass_attribute24_v varchar2(150)
544: ,ass_attribute22_m varchar2(150)
545: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
546: ,ass_attribute23_v varchar2(150)
547: ,ass_attribute23_m varchar2(150)
548: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
549: ,ass_attribute24_v varchar2(150)
550: ,ass_attribute24_m varchar2(150)
551: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
552: ,ass_attribute25_v varchar2(150)
547: ,ass_attribute23_m varchar2(150)
548: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
549: ,ass_attribute24_v varchar2(150)
550: ,ass_attribute24_m varchar2(150)
551: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
552: ,ass_attribute25_v varchar2(150)
553: ,ass_attribute25_m varchar2(150)
554: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
555: ,ass_attribute26_v varchar2(150)
550: ,ass_attribute24_m varchar2(150)
551: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
552: ,ass_attribute25_v varchar2(150)
553: ,ass_attribute25_m varchar2(150)
554: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
555: ,ass_attribute26_v varchar2(150)
556: ,ass_attribute26_m varchar2(150)
557: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
558: ,ass_attribute27_v varchar2(150)
553: ,ass_attribute25_m varchar2(150)
554: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
555: ,ass_attribute26_v varchar2(150)
556: ,ass_attribute26_m varchar2(150)
557: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
558: ,ass_attribute27_v varchar2(150)
559: ,ass_attribute27_m varchar2(150)
560: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
561: ,ass_attribute28_v varchar2(150)
556: ,ass_attribute26_m varchar2(150)
557: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
558: ,ass_attribute27_v varchar2(150)
559: ,ass_attribute27_m varchar2(150)
560: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
561: ,ass_attribute28_v varchar2(150)
562: ,ass_attribute28_m varchar2(150)
563: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
564: ,ass_attribute29_v varchar2(150)
559: ,ass_attribute27_m varchar2(150)
560: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
561: ,ass_attribute28_v varchar2(150)
562: ,ass_attribute28_m varchar2(150)
563: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
564: ,ass_attribute29_v varchar2(150)
565: ,ass_attribute29_m varchar2(150)
566: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
567: ,ass_attribute30_v varchar2(150)
562: ,ass_attribute28_m varchar2(150)
563: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
564: ,ass_attribute29_v varchar2(150)
565: ,ass_attribute29_m varchar2(150)
566: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
567: ,ass_attribute30_v varchar2(150)
568: ,ass_attribute30_m varchar2(150)
569: */
570: ,bargaining_unit_code_meaning hr_lookups.meaning%type
567: ,ass_attribute30_v varchar2(150)
568: ,ass_attribute30_m varchar2(150)
569: */
570: ,bargaining_unit_code_meaning hr_lookups.meaning%type
571: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
572: ,hourly_salaried_meaning hr_lookups.meaning%type
573: ,special_ceiling_step number
574: ,special_ceiling_point per_spinal_points.spinal_point%type
575: ,change_reason_meaning hr_lookups.meaning%type
572: ,hourly_salaried_meaning hr_lookups.meaning%type
573: ,special_ceiling_step number
574: ,special_ceiling_point per_spinal_points.spinal_point%type
575: ,change_reason_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
573: ,special_ceiling_step number
574: ,special_ceiling_point per_spinal_points.spinal_point%type
575: ,change_reason_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
581: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
574: ,special_ceiling_point per_spinal_points.spinal_point%type
575: ,change_reason_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
581: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
582: ,source_type_meaning hr_lookups.meaning%type
576: ,internal_address_line per_all_assignments_f.internal_address_line%type
577: ,manager_flag per_all_assignments_f.manager_flag%type
578: ,perf_review_period per_all_assignments_f.perf_review_period%type
579: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580: ,sal_review_period per_all_assignments_f.sal_review_period%type
581: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
582: ,source_type_meaning hr_lookups.meaning%type
583: ,contract per_contracts_f.reference%type
584: ,collective_agreement per_collective_agreements.name%type
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
608: ,npw_number per_all_people_f.npw_number%type default null
609: ,project_title per_all_assignments_f.project_title%type default null
610: ,vendor_id per_all_assignments_f.vendor_id%type default null
611: ,vendor_name po_vendors.vendor_name%type default null
612: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
613: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
608: ,npw_number per_all_people_f.npw_number%type default null
609: ,project_title per_all_assignments_f.project_title%type default null
610: ,vendor_id per_all_assignments_f.vendor_id%type default null
611: ,vendor_name po_vendors.vendor_name%type default null
612: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
613: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
614: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
608: ,npw_number per_all_people_f.npw_number%type default null
609: ,project_title per_all_assignments_f.project_title%type default null
610: ,vendor_id per_all_assignments_f.vendor_id%type default null
611: ,vendor_name po_vendors.vendor_name%type default null
612: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
613: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
614: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
615: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
616: ,po_header_num po_headers_all.segment1%TYPE default null
609: ,project_title per_all_assignments_f.project_title%type default null
610: ,vendor_id per_all_assignments_f.vendor_id%type default null
611: ,vendor_name po_vendors.vendor_name%type default null
612: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
613: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
614: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
615: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
616: ,po_header_num po_headers_all.segment1%TYPE default null
617: ,po_header_id po_headers_all.po_header_id%TYPE default null
632: ,sex per_all_people_f.sex%type default null
633: ,benefit_group ben_benfts_grp.name%type default null
634: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
635: ,grade per_grades.name%type default null
636: ,grade_id per_all_assignments_f.grade_id%type default null
637: ,grade_ladder ben_pgm_f.name%type default null
638: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
639: ,position hr_all_positions_f.name%type default null
640: ,position_id per_all_assignments_f.position_id%type default null
634: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
635: ,grade per_grades.name%type default null
636: ,grade_id per_all_assignments_f.grade_id%type default null
637: ,grade_ladder ben_pgm_f.name%type default null
638: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
639: ,position hr_all_positions_f.name%type default null
640: ,position_id per_all_assignments_f.position_id%type default null
641: ,job per_jobs.name%type default null
642: ,job_id per_all_assignments_f.job_id%type default null
636: ,grade_id per_all_assignments_f.grade_id%type default null
637: ,grade_ladder ben_pgm_f.name%type default null
638: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
639: ,position hr_all_positions_f.name%type default null
640: ,position_id per_all_assignments_f.position_id%type default null
641: ,job per_jobs.name%type default null
642: ,job_id per_all_assignments_f.job_id%type default null
643: ,assignment_status_type per_assignment_status_types.user_status%type default null
644: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
638: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
639: ,position hr_all_positions_f.name%type default null
640: ,position_id per_all_assignments_f.position_id%type default null
641: ,job per_jobs.name%type default null
642: ,job_id per_all_assignments_f.job_id%type default null
643: ,assignment_status_type per_assignment_status_types.user_status%type default null
644: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
645: ,payroll pay_all_payrolls_f.payroll_name%type default null
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
640: ,position_id per_all_assignments_f.position_id%type default null
641: ,job per_jobs.name%type default null
642: ,job_id per_all_assignments_f.job_id%type default null
643: ,assignment_status_type per_assignment_status_types.user_status%type default null
644: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
645: ,payroll pay_all_payrolls_f.payroll_name%type default null
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
647: ,location hr_locations.location_code%type default null
648: ,location_id per_all_assignments_f.location_id%type default null
642: ,job_id per_all_assignments_f.job_id%type default null
643: ,assignment_status_type per_assignment_status_types.user_status%type default null
644: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
645: ,payroll pay_all_payrolls_f.payroll_name%type default null
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
647: ,location hr_locations.location_code%type default null
648: ,location_id per_all_assignments_f.location_id%type default null
649: ,supervisor per_all_people_f.full_name%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
644: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
645: ,payroll pay_all_payrolls_f.payroll_name%type default null
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
647: ,location hr_locations.location_code%type default null
648: ,location_id per_all_assignments_f.location_id%type default null
649: ,supervisor per_all_people_f.full_name%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
652: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
647: ,location hr_locations.location_code%type default null
648: ,location_id per_all_assignments_f.location_id%type default null
649: ,supervisor per_all_people_f.full_name%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
652: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
653: ,recruitment_activity per_recruitment_activities.name%type default null
654: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
648: ,location_id per_all_assignments_f.location_id%type default null
649: ,supervisor per_all_people_f.full_name%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
652: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
653: ,recruitment_activity per_recruitment_activities.name%type default null
654: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
655: ,organization hr_all_organization_units.name%type default null
656: ,organization_id per_all_assignments_f.organization_id%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
652: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
653: ,recruitment_activity per_recruitment_activities.name%type default null
654: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
655: ,organization hr_all_organization_units.name%type default null
656: ,organization_id per_all_assignments_f.organization_id%type default null
657: ,people_group pay_people_groups.group_name%type default null
658: ,people_group_id per_all_assignments_f.people_group_id%type default null
652: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
653: ,recruitment_activity per_recruitment_activities.name%type default null
654: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
655: ,organization hr_all_organization_units.name%type default null
656: ,organization_id per_all_assignments_f.organization_id%type default null
657: ,people_group pay_people_groups.group_name%type default null
658: ,people_group_id per_all_assignments_f.people_group_id%type default null
659: ,vacancy per_vacancies.name%type default null
660: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
654: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
655: ,organization hr_all_organization_units.name%type default null
656: ,organization_id per_all_assignments_f.organization_id%type default null
657: ,people_group pay_people_groups.group_name%type default null
658: ,people_group_id per_all_assignments_f.people_group_id%type default null
659: ,vacancy per_vacancies.name%type default null
660: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
661: ,requisition per_requisitions.name%type default null
662: ,requisition_id per_requisitions.requisition_id%type default null
656: ,organization_id per_all_assignments_f.organization_id%type default null
657: ,people_group pay_people_groups.group_name%type default null
658: ,people_group_id per_all_assignments_f.people_group_id%type default null
659: ,vacancy per_vacancies.name%type default null
660: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
661: ,requisition per_requisitions.name%type default null
662: ,requisition_id per_requisitions.requisition_id%type default null
663: ,salary_basis per_pay_bases.name%type default null
664: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
660: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
661: ,requisition per_requisitions.name%type default null
662: ,requisition_id per_requisitions.requisition_id%type default null
663: ,salary_basis per_pay_bases.name%type default null
664: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
665: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
662: ,requisition_id per_requisitions.requisition_id%type default null
663: ,salary_basis per_pay_bases.name%type default null
664: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
665: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
669: ,establishment hr_leg_establishments_v.name%type default null
670: ,establishment_id hr_leg_establishments_v.organization_id%type default null
664: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
665: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
669: ,establishment hr_leg_establishments_v.name%type default null
670: ,establishment_id hr_leg_establishments_v.organization_id%type default null
671: ,projected_hire_date per_applications.projected_hire_date%type default null
672: ,secure varchar2 default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
712: ,npw_number in per_all_people_f.npw_number%type default null
713: ,project_title in per_all_assignments_f.project_title%type default null
714: ,vendor_id in per_all_assignments_f.vendor_id%type default null
715: ,vendor_name in po_vendors.vendor_name%type default null
716: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
717: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
712: ,npw_number in per_all_people_f.npw_number%type default null
713: ,project_title in per_all_assignments_f.project_title%type default null
714: ,vendor_id in per_all_assignments_f.vendor_id%type default null
715: ,vendor_name in po_vendors.vendor_name%type default null
716: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
717: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
718: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
712: ,npw_number in per_all_people_f.npw_number%type default null
713: ,project_title in per_all_assignments_f.project_title%type default null
714: ,vendor_id in per_all_assignments_f.vendor_id%type default null
715: ,vendor_name in po_vendors.vendor_name%type default null
716: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
717: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
718: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
719: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
720: ,po_header_num in po_headers_all.segment1%TYPE default null
713: ,project_title in per_all_assignments_f.project_title%type default null
714: ,vendor_id in per_all_assignments_f.vendor_id%type default null
715: ,vendor_name in po_vendors.vendor_name%type default null
716: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
717: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
718: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
719: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
720: ,po_header_num in po_headers_all.segment1%TYPE default null
721: ,po_header_id in po_headers_all.po_header_id%TYPE default null
736: ,sex in per_all_people_f.sex%type default null
737: ,benefit_group in ben_benfts_grp.name%type default null
738: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
739: ,grade in per_grades.name%type default null
740: ,grade_id in per_all_assignments_f.grade_id%type default null
741: ,grade_ladder in ben_pgm_f.name%type default null
742: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
743: ,position in hr_all_positions_f.name%type default null
744: ,position_id in per_all_assignments_f.position_id%type default null
738: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
739: ,grade in per_grades.name%type default null
740: ,grade_id in per_all_assignments_f.grade_id%type default null
741: ,grade_ladder in ben_pgm_f.name%type default null
742: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
743: ,position in hr_all_positions_f.name%type default null
744: ,position_id in per_all_assignments_f.position_id%type default null
745: ,job in per_jobs.name%type default null
746: ,job_id in per_all_assignments_f.job_id%type default null
740: ,grade_id in per_all_assignments_f.grade_id%type default null
741: ,grade_ladder in ben_pgm_f.name%type default null
742: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
743: ,position in hr_all_positions_f.name%type default null
744: ,position_id in per_all_assignments_f.position_id%type default null
745: ,job in per_jobs.name%type default null
746: ,job_id in per_all_assignments_f.job_id%type default null
747: ,assignment_status_type in per_assignment_status_types.user_status%type default null
748: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
742: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
743: ,position in hr_all_positions_f.name%type default null
744: ,position_id in per_all_assignments_f.position_id%type default null
745: ,job in per_jobs.name%type default null
746: ,job_id in per_all_assignments_f.job_id%type default null
747: ,assignment_status_type in per_assignment_status_types.user_status%type default null
748: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
749: ,payroll in pay_all_payrolls_f.payroll_name%type default null
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
744: ,position_id in per_all_assignments_f.position_id%type default null
745: ,job in per_jobs.name%type default null
746: ,job_id in per_all_assignments_f.job_id%type default null
747: ,assignment_status_type in per_assignment_status_types.user_status%type default null
748: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
749: ,payroll in pay_all_payrolls_f.payroll_name%type default null
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
751: ,location in hr_locations.location_code%type default null
752: ,location_id in per_all_assignments_f.location_id%type default null
746: ,job_id in per_all_assignments_f.job_id%type default null
747: ,assignment_status_type in per_assignment_status_types.user_status%type default null
748: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
749: ,payroll in pay_all_payrolls_f.payroll_name%type default null
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
751: ,location in hr_locations.location_code%type default null
752: ,location_id in per_all_assignments_f.location_id%type default null
753: ,supervisor in per_all_people_f.full_name%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
748: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
749: ,payroll in pay_all_payrolls_f.payroll_name%type default null
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
751: ,location in hr_locations.location_code%type default null
752: ,location_id in per_all_assignments_f.location_id%type default null
753: ,supervisor in per_all_people_f.full_name%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
756: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
751: ,location in hr_locations.location_code%type default null
752: ,location_id in per_all_assignments_f.location_id%type default null
753: ,supervisor in per_all_people_f.full_name%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
756: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
757: ,recruitment_activity in per_recruitment_activities.name%type default null
758: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
752: ,location_id in per_all_assignments_f.location_id%type default null
753: ,supervisor in per_all_people_f.full_name%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
756: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
757: ,recruitment_activity in per_recruitment_activities.name%type default null
758: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
759: ,organization in hr_all_organization_units.name%type default null
760: ,organization_id in per_all_assignments_f.organization_id%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
756: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
757: ,recruitment_activity in per_recruitment_activities.name%type default null
758: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
759: ,organization in hr_all_organization_units.name%type default null
760: ,organization_id in per_all_assignments_f.organization_id%type default null
761: ,people_group in pay_people_groups.group_name%type default null
762: ,people_group_id in per_all_assignments_f.people_group_id%type default null
756: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
757: ,recruitment_activity in per_recruitment_activities.name%type default null
758: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
759: ,organization in hr_all_organization_units.name%type default null
760: ,organization_id in per_all_assignments_f.organization_id%type default null
761: ,people_group in pay_people_groups.group_name%type default null
762: ,people_group_id in per_all_assignments_f.people_group_id%type default null
763: ,vacancy in per_vacancies.name%type default null
764: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
758: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
759: ,organization in hr_all_organization_units.name%type default null
760: ,organization_id in per_all_assignments_f.organization_id%type default null
761: ,people_group in pay_people_groups.group_name%type default null
762: ,people_group_id in per_all_assignments_f.people_group_id%type default null
763: ,vacancy in per_vacancies.name%type default null
764: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
765: ,requisition in per_requisitions.name%type default null
766: ,requisition_id in per_requisitions.requisition_id%type default null
760: ,organization_id in per_all_assignments_f.organization_id%type default null
761: ,people_group in pay_people_groups.group_name%type default null
762: ,people_group_id in per_all_assignments_f.people_group_id%type default null
763: ,vacancy in per_vacancies.name%type default null
764: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
765: ,requisition in per_requisitions.name%type default null
766: ,requisition_id in per_requisitions.requisition_id%type default null
767: ,salary_basis in per_pay_bases.name%type default null
768: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
764: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
765: ,requisition in per_requisitions.name%type default null
766: ,requisition_id in per_requisitions.requisition_id%type default null
767: ,salary_basis in per_pay_bases.name%type default null
768: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
769: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
766: ,requisition_id in per_requisitions.requisition_id%type default null
767: ,salary_basis in per_pay_bases.name%type default null
768: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
769: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
773: ,establishment in hr_leg_establishments_v.name%type default null
774: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
768: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
769: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
773: ,establishment in hr_leg_establishments_v.name%type default null
774: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
775: ,projected_hire_date in per_applications.projected_hire_date%type default null
776: ,secure in varchar2 default null