3166: --
3167: l_business_group_id hr_all_organization_units.organization_id%TYPE;
3168: l_org_now_no_manager_warning BOOLEAN;
3169: l_system_person_type per_person_types.system_person_type%TYPE;
3170: l_comment_id hr_comments.comment_id%TYPE;
3171: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3172: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3173: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3174: l_full_name per_all_people_f.full_name%TYPE;
3793: l_future_asgs_count INTEGER;
3794: l_system_person_type per_person_types.system_person_type%TYPE;
3795: l_effective_start_date DATE;
3796: l_effective_end_date DATE;
3797: l_comment_id hr_comments.comment_id%TYPE;
3798: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3799: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3800: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3801: l_full_name per_all_people_f.full_name%TYPE;