APPS.BEN_CLOSE_ENROLLMENT dependencies on PER_ALL_PEOPLE_F

Line 521: per_all_people_f ppf,

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

Line 687: l_per_business_group_id per_all_people_f.business_group_id%type;

683: l_dummy_dt date;
684: l_dummy_num number(15);
685: l_dummy_varchar varchar2(30);
686: l_found varchar2(1);
687: l_per_business_group_id per_all_people_f.business_group_id%type;
688: --
689: l_proc varchar2(80) := g_package||'.close_single_enrollment';
690: l_dflt_enrt_date date;
691: l_pil_stat_cd varchar2(30);

Line 1522: l_per_rec per_all_people_f%rowtype;

1518: --
1519: -- start bug 3079317
1520: l_rec benutils.g_active_life_event;
1521: l_env ben_env_object.g_global_env_rec_type;
1522: l_per_rec per_all_people_f%rowtype;
1523: l_encoded_message varchar2(2000);
1524: l_app_short_name varchar2(2000);
1525: l_message_name varchar2(2000);
1526: g_rec ben_type.g_report_rec;

Line 1937: per_all_people_f per,

1933: is
1934: select distinct pil.person_id
1935: ,pil.per_in_ler_id
1936: from ben_per_in_ler pil,
1937: per_all_people_f per,
1938: ben_ler_f ler
1939: where pil.business_group_id = p_business_group_id
1940: and pil.per_in_ler_stat_cd = 'STRTD'
1941: and pil.person_id = per.person_id