DBA Data[Home] [Help]

APPS.BEN_PREM_PRTT_MONTHLY dependencies on PER_PEOPLE_F

Line 368: select full_name from per_people_f

364: ,p_warning in varchar2)is
365: l_package varchar2(80) := g_package||'.premium_warning';
366:
367: cursor c_person (p_person_id number) is
368: select full_name from per_people_f
369: where person_id = p_person_id
370: and p_effective_date between effective_start_date
371: and effective_end_date;
372: l_full_name per_all_people_f.full_name%TYPE := ''; -- UTF8 varchar2(240) := '';