497:
498: begin
499: l_proc := g_package||'get_history_id';
500: if (p_assignment_type = 'E' or p_assignment_type = 'C') then
501: select nvl(substr((select ghr_ss_views_pkg.get_people_ei_id_ason_date(p_person_id,p_information_type,p_effective_date) from dual), 0, 10),-1)
502: into l_history_id
503: from dual;
504: end if;
505: return (l_history_id);
499: l_proc := g_package||'get_history_id';
500: if (p_assignment_type = 'E' or p_assignment_type = 'C') then
501: select nvl(substr((select ghr_ss_views_pkg.get_people_ei_id_ason_date(p_person_id,p_information_type,p_effective_date) from dual), 0, 10),-1)
502: into l_history_id
503: from dual;
504: end if;
505: return (l_history_id);
506: end get_history_id;
507: