APPS.BEN_PREM_PRTT_MONTHLY dependencies on PER_ALL_PEOPLE_F

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

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) := '';
379:
380: cursor c_premium (p_prtt_enrt_rslt_id number,
381: p_effective_start_date date, p_effective_date date) is
382: select distinct 'Y'