APPS.BEN_CLOSE_ENROLLMENT dependencies on PER_ALL_PEOPLE_F

Line 522: per_all_people_f ppf,

518: ,pil.lf_evt_ocrd_dt
519: ,ppf.business_group_id
520: ,pil.per_in_ler_stat_cd
521: from ben_per_in_ler pil,
522: per_all_people_f ppf,
523: ben_ler_f ler
524: where pil.per_in_ler_id = p_per_in_ler_id
525: and pil.business_group_id = p_business_group_id
526: and pil.per_in_ler_stat_cd = 'STRTD'

Line 709: l_per_business_group_id per_all_people_f.business_group_id%type;

705: l_dummy_dt date;
706: l_dummy_num number(15);
707: l_dummy_varchar varchar2(30);
708: l_found varchar2(1);
709: l_per_business_group_id per_all_people_f.business_group_id%type;
710: --
711: l_proc varchar2(80) := g_package||'.close_single_enrollment';
712: l_dflt_enrt_date date;
713: l_pil_stat_cd varchar2(30);

Line 1562: l_per_rec per_all_people_f%rowtype;

1558: --
1559: -- start bug 3079317
1560: l_rec benutils.g_active_life_event;
1561: l_env ben_env_object.g_global_env_rec_type;
1562: l_per_rec per_all_people_f%rowtype;
1563: l_encoded_message varchar2(2000);
1564: l_app_short_name varchar2(2000);
1565: l_message_name varchar2(2000);
1566: g_rec ben_type.g_report_rec;

Line 1977: per_all_people_f per,

1973: is
1974: select distinct pil.person_id
1975: ,pil.per_in_ler_id
1976: from ben_per_in_ler pil,
1977: per_all_people_f per,
1978: ben_ler_f ler
1979: where pil.business_group_id = p_business_group_id
1980: and pil.per_in_ler_stat_cd = 'STRTD'
1981: and pil.person_id = per.person_id