APPS.HR_PERSON_ATT dependencies on PER_PEOPLE_F

Line 180: from per_people_f per

176: -- cursor to lock all rows for which the datetrack operation could
177: -- operate over
178: cursor csr_per_lck(c_lck_start_date date) is
179: select 1
180: from per_people_f per
181: where per.person_id = p_person_id
182: and per.effective_end_date >= c_lck_start_date
183: for update nowait;
184: -- select current and future rows

Line 449: l_last_name per_people_f.last_name%type;

445: and per.effective_end_date < l_constant_effective_date
446: and hc.comment_id (+) = per.comment_id
447: order by per.effective_end_date desc;
448: -- IN parameters for BP API
449: l_last_name per_people_f.last_name%type;
450: l_date_of_birth per_people_f.date_of_birth%type;
451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;

Line 450: l_date_of_birth per_people_f.date_of_birth%type;

446: and hc.comment_id (+) = per.comment_id
447: order by per.effective_end_date desc;
448: -- IN parameters for BP API
449: l_last_name per_people_f.last_name%type;
450: l_date_of_birth per_people_f.date_of_birth%type;
451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;

Line 451: l_email_address per_people_f.email_address%type;

447: order by per.effective_end_date desc;
448: -- IN parameters for BP API
449: l_last_name per_people_f.last_name%type;
450: l_date_of_birth per_people_f.date_of_birth%type;
451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;

Line 452: l_first_name per_people_f.first_name%type;

448: -- IN parameters for BP API
449: l_last_name per_people_f.last_name%type;
450: l_date_of_birth per_people_f.date_of_birth%type;
451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;

Line 453: l_known_as per_people_f.known_as%type;

449: l_last_name per_people_f.last_name%type;
450: l_date_of_birth per_people_f.date_of_birth%type;
451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;

Line 454: l_marital_status per_people_f.marital_status%type;

450: l_date_of_birth per_people_f.date_of_birth%type;
451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;

Line 455: l_middle_names per_people_f.middle_names%type;

451: l_email_address per_people_f.email_address%type;
452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;

Line 456: l_nationality per_people_f.nationality%type;

452: l_first_name per_people_f.first_name%type;
453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;

Line 457: l_previous_last_name per_people_f.previous_last_name%type;

453: l_known_as per_people_f.known_as%type;
454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;

Line 458: l_sex per_people_f.sex%type;

454: l_marital_status per_people_f.marital_status%type;
455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;

Line 459: l_title per_people_f.title%type;

455: l_middle_names per_people_f.middle_names%type;
456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;

Line 460: l_work_telephone per_people_f.work_telephone%type;

456: l_nationality per_people_f.nationality%type;
457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;

Line 461: l_suffix per_people_f.suffix%type;

457: l_previous_last_name per_people_f.previous_last_name%type;
458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;

Line 462: l_person_type_id per_people_f.person_type_id%type;

458: l_sex per_people_f.sex%type;
459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;

Line 463: l_applicant_number per_people_f.applicant_number%type;

459: l_title per_people_f.title%type;
460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;

Line 465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;

461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;

Line 466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;

462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;

Line 467: l_national_identifier per_people_f.national_identifier%type;

463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;

Line 468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;

464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;

Line 469: l_vendor_id per_people_f.vendor_id%type;

465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;

Line 470: l_attribute_category per_people_f.attribute_category%type;

466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;

Line 471: l_attribute1 per_people_f.attribute1%type;

467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;

Line 472: l_attribute2 per_people_f.attribute2%type;

468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;
469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;

Line 473: l_attribute3 per_people_f.attribute3%type;

469: l_vendor_id per_people_f.vendor_id%type;
470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;

Line 474: l_attribute4 per_people_f.attribute4%type;

470: l_attribute_category per_people_f.attribute_category%type;
471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;

Line 475: l_attribute5 per_people_f.attribute5%type;

471: l_attribute1 per_people_f.attribute1%type;
472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;

Line 476: l_attribute6 per_people_f.attribute6%type;

472: l_attribute2 per_people_f.attribute2%type;
473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;

Line 477: l_attribute7 per_people_f.attribute7%type;

473: l_attribute3 per_people_f.attribute3%type;
474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;

Line 478: l_attribute8 per_people_f.attribute8%type;

474: l_attribute4 per_people_f.attribute4%type;
475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;

Line 479: l_attribute9 per_people_f.attribute9%type;

475: l_attribute5 per_people_f.attribute5%type;
476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;

Line 480: l_attribute10 per_people_f.attribute10%type;

476: l_attribute6 per_people_f.attribute6%type;
477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;

Line 481: l_attribute11 per_people_f.attribute11%type;

477: l_attribute7 per_people_f.attribute7%type;
478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;

Line 482: l_attribute12 per_people_f.attribute12%type;

478: l_attribute8 per_people_f.attribute8%type;
479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;

Line 483: l_attribute13 per_people_f.attribute13%type;

479: l_attribute9 per_people_f.attribute9%type;
480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;

Line 484: l_attribute14 per_people_f.attribute14%type;

480: l_attribute10 per_people_f.attribute10%type;
481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;

Line 485: l_attribute15 per_people_f.attribute15%type;

481: l_attribute11 per_people_f.attribute11%type;
482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;

Line 486: l_attribute16 per_people_f.attribute16%type;

482: l_attribute12 per_people_f.attribute12%type;
483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;

Line 487: l_attribute17 per_people_f.attribute17%type;

483: l_attribute13 per_people_f.attribute13%type;
484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;

Line 488: l_attribute18 per_people_f.attribute18%type;

484: l_attribute14 per_people_f.attribute14%type;
485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;

Line 489: l_attribute19 per_people_f.attribute19%type;

485: l_attribute15 per_people_f.attribute15%type;
486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;

Line 490: l_attribute20 per_people_f.attribute20%type;

486: l_attribute16 per_people_f.attribute16%type;
487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;

Line 491: l_attribute21 per_people_f.attribute21%type;

487: l_attribute17 per_people_f.attribute17%type;
488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;

Line 492: l_attribute22 per_people_f.attribute22%type;

488: l_attribute18 per_people_f.attribute18%type;
489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;

Line 493: l_attribute23 per_people_f.attribute23%type;

489: l_attribute19 per_people_f.attribute19%type;
490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;

Line 494: l_attribute24 per_people_f.attribute24%type;

490: l_attribute20 per_people_f.attribute20%type;
491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;

Line 495: l_attribute25 per_people_f.attribute25%type;

491: l_attribute21 per_people_f.attribute21%type;
492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;

Line 496: l_attribute26 per_people_f.attribute26%type;

492: l_attribute22 per_people_f.attribute22%type;
493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;

Line 497: l_attribute27 per_people_f.attribute27%type;

493: l_attribute23 per_people_f.attribute23%type;
494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;

Line 498: l_attribute28 per_people_f.attribute28%type;

494: l_attribute24 per_people_f.attribute24%type;
495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;

Line 499: l_attribute29 per_people_f.attribute29%type;

495: l_attribute25 per_people_f.attribute25%type;
496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;

Line 500: l_attribute30 per_people_f.attribute30%type;

496: l_attribute26 per_people_f.attribute26%type;
497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;

Line 501: l_per_information_category per_people_f.per_information_category%type;

497: l_attribute27 per_people_f.attribute27%type;
498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;

Line 502: l_per_information1 per_people_f.per_information1%type;

498: l_attribute28 per_people_f.attribute28%type;
499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;

Line 503: l_per_information2 per_people_f.per_information2%type;

499: l_attribute29 per_people_f.attribute29%type;
500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;

Line 504: l_per_information3 per_people_f.per_information3%type;

500: l_attribute30 per_people_f.attribute30%type;
501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;

Line 505: l_per_information4 per_people_f.per_information4%type;

501: l_per_information_category per_people_f.per_information_category%type;
502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;

Line 506: l_per_information5 per_people_f.per_information5%type;

502: l_per_information1 per_people_f.per_information1%type;
503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;

Line 507: l_per_information6 per_people_f.per_information6%type;

503: l_per_information2 per_people_f.per_information2%type;
504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;

Line 508: l_per_information7 per_people_f.per_information7%type;

504: l_per_information3 per_people_f.per_information3%type;
505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;

Line 509: l_per_information8 per_people_f.per_information8%type;

505: l_per_information4 per_people_f.per_information4%type;
506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;

Line 510: l_per_information9 per_people_f.per_information9%type;

506: l_per_information5 per_people_f.per_information5%type;
507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;

Line 511: l_per_information10 per_people_f.per_information10%type;

507: l_per_information6 per_people_f.per_information6%type;
508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;

Line 512: l_per_information11 per_people_f.per_information11%type;

508: l_per_information7 per_people_f.per_information7%type;
509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;

Line 513: l_per_information12 per_people_f.per_information12%type;

509: l_per_information8 per_people_f.per_information8%type;
510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;

Line 514: l_per_information13 per_people_f.per_information13%type;

510: l_per_information9 per_people_f.per_information9%type;
511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;

Line 515: l_per_information14 per_people_f.per_information14%type;

511: l_per_information10 per_people_f.per_information10%type;
512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;

Line 516: l_per_information15 per_people_f.per_information15%type;

512: l_per_information11 per_people_f.per_information11%type;
513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;

Line 517: l_per_information16 per_people_f.per_information16%type;

513: l_per_information12 per_people_f.per_information12%type;
514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;

Line 518: l_per_information17 per_people_f.per_information17%type;

514: l_per_information13 per_people_f.per_information13%type;
515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;
522:

Line 519: l_per_information18 per_people_f.per_information18%type;

515: l_per_information14 per_people_f.per_information14%type;
516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;
522:
523: l_per_information21 per_people_f.per_information21%type;

Line 520: l_per_information19 per_people_f.per_information19%type;

516: l_per_information15 per_people_f.per_information15%type;
517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;
522:
523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;

Line 521: l_per_information20 per_people_f.per_information20%type;

517: l_per_information16 per_people_f.per_information16%type;
518: l_per_information17 per_people_f.per_information17%type;
519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;
522:
523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;

Line 523: l_per_information21 per_people_f.per_information21%type;

519: l_per_information18 per_people_f.per_information18%type;
520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;
522:
523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;

Line 524: l_per_information22 per_people_f.per_information22%type;

520: l_per_information19 per_people_f.per_information19%type;
521: l_per_information20 per_people_f.per_information20%type;
522:
523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;

Line 525: l_per_information23 per_people_f.per_information23%type;

521: l_per_information20 per_people_f.per_information20%type;
522:
523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;

Line 526: l_per_information24 per_people_f.per_information24%type;

522:
523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;

Line 527: l_per_information25 per_people_f.per_information25%type;

523: l_per_information21 per_people_f.per_information21%type;
524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;

Line 528: l_per_information26 per_people_f.per_information26%type;

524: l_per_information22 per_people_f.per_information22%type;
525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;

Line 529: l_per_information27 per_people_f.per_information27%type;

525: l_per_information23 per_people_f.per_information23%type;
526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;

Line 530: l_per_information28 per_people_f.per_information28%type;

526: l_per_information24 per_people_f.per_information24%type;
527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;

Line 531: l_per_information29 per_people_f.per_information29%type;

527: l_per_information25 per_people_f.per_information25%type;
528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;

Line 532: l_per_information30 per_people_f.per_information30%type;

528: l_per_information26 per_people_f.per_information26%type;
529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;

Line 533: l_date_of_death per_people_f.date_of_death%type;

529: l_per_information27 per_people_f.per_information27%type;
530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;

Line 534: l_background_check_status per_people_f.background_check_status%type;

530: l_per_information28 per_people_f.per_information28%type;
531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;

Line 535: l_background_date_check per_people_f.background_date_check%type;

531: l_per_information29 per_people_f.per_information29%type;
532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;

Line 536: l_blood_type per_people_f.blood_type%type;

532: l_per_information30 per_people_f.per_information30%type;
533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;

Line 537: l_correspondence_language per_people_f.correspondence_language%type;

533: l_date_of_death per_people_f.date_of_death%type;
534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;

Line 538: l_fast_path_employee per_people_f.fast_path_employee%type;

534: l_background_check_status per_people_f.background_check_status%type;
535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;

Line 539: l_fte_capacity per_people_f.fte_capacity%type;

535: l_background_date_check per_people_f.background_date_check%type;
536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;

Line 540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;

536: l_blood_type per_people_f.blood_type%type;
537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;

Line 541: l_honors per_people_f.honors%type;

537: l_correspondence_language per_people_f.correspondence_language%type;
538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;

Line 542: l_internal_location per_people_f.internal_location%type;

538: l_fast_path_employee per_people_f.fast_path_employee%type;
539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;

Line 543: l_last_medical_test_by per_people_f.last_medical_test_by%type;

539: l_fte_capacity per_people_f.fte_capacity%type;
540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;

Line 544: l_last_medical_test_date per_people_f.last_medical_test_date%type;

540: l_hold_applicant_date_until per_people_f.hold_applicant_date_until%type;
541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;

Line 545: l_mailstop per_people_f.mailstop%type;

541: l_honors per_people_f.honors%type;
542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;

Line 546: l_office_number per_people_f.office_number%type;

542: l_internal_location per_people_f.internal_location%type;
543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;

Line 547: l_on_military_service per_people_f.on_military_service%type;

543: l_last_medical_test_by per_people_f.last_medical_test_by%type;
544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;

Line 548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;

544: l_last_medical_test_date per_people_f.last_medical_test_date%type;
545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;

Line 549: l_projected_start_date per_people_f.projected_start_date%type;

545: l_mailstop per_people_f.mailstop%type;
546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;

Line 550: l_rehire_authorizor per_people_f.rehire_authorizor%type;

546: l_office_number per_people_f.office_number%type;
547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;

Line 551: l_rehire_recommendation per_people_f.rehire_recommendation%type;

547: l_on_military_service per_people_f.on_military_service%type;
548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;

Line 552: l_resume_exists per_people_f.resume_exists%type;

548: l_pre_name_adjunct per_people_f.pre_name_adjunct%type;
549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;

Line 553: l_resume_last_updated per_people_f.resume_last_updated%type;

549: l_projected_start_date per_people_f.projected_start_date%type;
550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;

Line 554: l_second_passport_exists per_people_f.second_passport_exists%type;

550: l_rehire_authorizor per_people_f.rehire_authorizor%type;
551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;

Line 555: l_student_status per_people_f.student_status%type;

551: l_rehire_recommendation per_people_f.rehire_recommendation%type;
552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;

Line 556: l_work_schedule per_people_f.work_schedule%type;

552: l_resume_exists per_people_f.resume_exists%type;
553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;

Line 557: l_rehire_reason per_people_f.rehire_reason%type;

553: l_resume_last_updated per_people_f.resume_last_updated%type;
554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;

Line 558: l_benefit_group_id per_people_f.benefit_group_id%type;

554: l_second_passport_exists per_people_f.second_passport_exists%type;
555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;

Line 559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;

555: l_student_status per_people_f.student_status%type;
556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;

Line 560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;

556: l_work_schedule per_people_f.work_schedule%type;
557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;

Line 561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;

557: l_rehire_reason per_people_f.rehire_reason%type;
558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;

Line 562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;

558: l_benefit_group_id per_people_f.benefit_group_id%type;
559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;

Line 563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;

559: l_receipt_of_death_cert_date per_people_f.receipt_of_death_cert_date%type;
560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;

Line 564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;

560: l_coord_ben_med_pln_no per_people_f.coord_ben_med_pln_no%type;
561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;

Line 565: l_original_date_of_hire per_people_f.original_date_of_hire%type;

561: l_coord_ben_no_cvg_flag per_people_f.coord_ben_no_cvg_flag%type;
562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;

Line 566: l_town_of_birth per_people_f.town_of_birth%type;

562: l_uses_tobacco_flag per_people_f.uses_tobacco_flag%type;
563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;
570: -- IN/OUT parameters for BP API and API

Line 567: l_region_of_birth per_people_f.region_of_birth%type;

563: l_dpdnt_adoption_date per_people_f.dpdnt_adoption_date%type;
564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;
570: -- IN/OUT parameters for BP API and API
571: l_employee_number per_people_f.employee_number%type;

Line 568: l_country_of_birth per_people_f.country_of_birth%type;

564: l_dpdnt_vlntry_svce_flag per_people_f.dpdnt_vlntry_svce_flag%type;
565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;
570: -- IN/OUT parameters for BP API and API
571: l_employee_number per_people_f.employee_number%type;
572: l_object_version_number per_people_f.object_version_number%type;

Line 569: l_global_person_id per_people_f.global_person_id%type;

565: l_original_date_of_hire per_people_f.original_date_of_hire%type;
566: l_town_of_birth per_people_f.town_of_birth%type;
567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;
570: -- IN/OUT parameters for BP API and API
571: l_employee_number per_people_f.employee_number%type;
572: l_object_version_number per_people_f.object_version_number%type;
573: -- OUT parameters for BP API

Line 571: l_employee_number per_people_f.employee_number%type;

567: l_region_of_birth per_people_f.region_of_birth%type;
568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;
570: -- IN/OUT parameters for BP API and API
571: l_employee_number per_people_f.employee_number%type;
572: l_object_version_number per_people_f.object_version_number%type;
573: -- OUT parameters for BP API
574: l_full_name per_people_f.full_name%type;
575: l_comment_id per_people_f.comment_id%type;

Line 572: l_object_version_number per_people_f.object_version_number%type;

568: l_country_of_birth per_people_f.country_of_birth%type;
569: l_global_person_id per_people_f.global_person_id%type;
570: -- IN/OUT parameters for BP API and API
571: l_employee_number per_people_f.employee_number%type;
572: l_object_version_number per_people_f.object_version_number%type;
573: -- OUT parameters for BP API
574: l_full_name per_people_f.full_name%type;
575: l_comment_id per_people_f.comment_id%type;
576: l_name_combination_warning boolean;

Line 574: l_full_name per_people_f.full_name%type;

570: -- IN/OUT parameters for BP API and API
571: l_employee_number per_people_f.employee_number%type;
572: l_object_version_number per_people_f.object_version_number%type;
573: -- OUT parameters for BP API
574: l_full_name per_people_f.full_name%type;
575: l_comment_id per_people_f.comment_id%type;
576: l_name_combination_warning boolean;
577: l_assign_payroll_warning boolean;
578: l_orig_hire_warning boolean;

Line 575: l_comment_id per_people_f.comment_id%type;

571: l_employee_number per_people_f.employee_number%type;
572: l_object_version_number per_people_f.object_version_number%type;
573: -- OUT parameters for BP API
574: l_full_name per_people_f.full_name%type;
575: l_comment_id per_people_f.comment_id%type;
576: l_name_combination_warning boolean;
577: l_assign_payroll_warning boolean;
578: l_orig_hire_warning boolean;
579: l_effective_start_date per_people_f.effective_start_date%type;

Line 579: l_effective_start_date per_people_f.effective_start_date%type;

575: l_comment_id per_people_f.comment_id%type;
576: l_name_combination_warning boolean;
577: l_assign_payroll_warning boolean;
578: l_orig_hire_warning boolean;
579: l_effective_start_date per_people_f.effective_start_date%type;
580: l_effective_end_date per_people_f.effective_end_date%type;
581: -- OUT parameters for API
582: l_api_name_combination_warning boolean := false;
583: l_api_assign_payroll_warning boolean := false;

Line 580: l_effective_end_date per_people_f.effective_end_date%type;

576: l_name_combination_warning boolean;
577: l_assign_payroll_warning boolean;
578: l_orig_hire_warning boolean;
579: l_effective_start_date per_people_f.effective_start_date%type;
580: l_effective_end_date per_people_f.effective_end_date%type;
581: -- OUT parameters for API
582: l_api_name_combination_warning boolean := false;
583: l_api_assign_payroll_warning boolean := false;
584: l_api_orig_hire_warning boolean := false;