APPS.BEN_PREM_PRTT_MONTHLY dependencies on PER_ALL_PEOPLE_F

Line 372: l_full_name per_all_people_f.full_name%TYPE := ''; -- UTF8 varchar2(240) := '';

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) := '';
373:
374: cursor c_premium (p_prtt_enrt_rslt_id number,
375: p_effective_start_date date, p_effective_date date) is
376: select distinct 'Y'