376: l_name_combination_warning boolean;
377: l_orig_hire_warning boolean;
378:
379: l_pei ghr_mt_people_ei_v%rowtype;
380: l_sit ghr_mt_analysis_criteria_v%rowtype;
381: l_hr_user_type varchar2(20);
382: l_address ghr_mt_addresses_v%rowtype;
383:
384: --
393: and mt_person_id = p_tran.mt_person_id;
394:
395: cursor cur_sit is
396: select *
397: from ghr_mt_analysis_criteria_v
398: where mt_name = p_transfer_name
399: and mt_person_id = p_tran.mt_person_id;
400:
401: cursor cur_address is