798: --
799: CURSOR get_warning_dtls_for_ee(cp_person_id in number)
800: is
801: select substr(full_name,1,48), employee_number
802: from per_all_people_f
803: where person_id = cp_person_id
804: order by effective_end_date desc;
805:
806: ld_start_date DATE;
816: ln_assignment_action_id number;
817: ln_w2c_pp_asg_actid number;
818: ln_w2c_pp_locked_actid number;
819:
820: lv_national_identifier per_all_people_f.national_identifier%type;
821: lv_message varchar2(50):= null;
822: lv_full_name per_all_people_f.full_name%type;
823: lv_name varchar2(50);
824: lv_record_name varchar2(50);
818: ln_w2c_pp_locked_actid number;
819:
820: lv_national_identifier per_all_people_f.national_identifier%type;
821: lv_message varchar2(50):= null;
822: lv_full_name per_all_people_f.full_name%type;
823: lv_name varchar2(50);
824: lv_record_name varchar2(50);
825: ln_prev_person_id number;
826: