370: ,p_warning in varchar2)is
371: l_package varchar2(80) := g_package||'.premium_warning';
372:
373: cursor c_person (p_person_id number) is
374: select full_name from per_people_f
375: where person_id = p_person_id
376: and p_effective_date between effective_start_date
377: and effective_end_date;
378: l_full_name per_all_people_f.full_name%TYPE := ''; -- UTF8 varchar2(240) := '';