APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on PER_ALL_PEOPLE_F

Line 2620: from per_all_people_f per

2616: l_dob_found boolean;
2617: --
2618: cursor c_date_of_birth is
2619: select per.date_of_birth
2620: from per_all_people_f per
2621: where per.person_id = p_person_id
2622: and per.business_group_id = p_business_group_id
2623: and p_effective_date between per.effective_start_date
2624: and per.effective_end_date;

Line 2822: from per_all_people_f per

2818: l_legid_found boolean;
2819: --
2820: cursor c_leg_id is
2821: select per.national_identifier
2822: from per_all_people_f per
2823: where per.person_id = p_person_id
2824: and per.business_group_id = p_business_group_id
2825: and p_effective_date between
2826: per.effective_start_date and per.effective_end_date;

Line 7366: from per_all_people_f per,

7362: (trunc
7363: (months_between(p_effective_date, per.date_of_birth))/ 12
7364: ) bnf_age,
7365: pb.ttee_person_id
7366: from per_all_people_f per,
7367: ben_pl_bnf_f pb
7368: where pb.pl_bnf_id = p_pl_bnf_id
7369: and per.person_id = pb.bnf_person_id
7370: and per.business_group_id = p_business_group_id

Line 8827: from per_all_people_f per,

8823: select pcr.contact_type,
8824: plb.bnf_person_id,
8825: plb.pl_bnf_id,
8826: pl.pl_id
8827: from per_all_people_f per,
8828: per_contact_relationships pcr,
8829: ben_pl_f pl,
8830: ben_pl_bnf_f plb,
8831: ben_prtt_enrt_rslt_f pen,

Line 8866: from per_all_people_f per,

8862: select 'O',
8863: plb.organization_id,
8864: plb.pl_bnf_id,
8865: pl.pl_id
8866: from per_all_people_f per,
8867: hr_all_organization_units o,
8868: ben_pl_f pl,
8869: ben_pl_bnf_f plb,
8870: ben_prtt_enrt_rslt_f pen,

Line 9389: l_person_id per_all_people_f.person_id%type;

9385:
9386: l_pcp_actn_warning boolean := FALSE;
9387: l_pcp_dpnt_actn_warning boolean := FALSE;
9388: l_pln_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
9389: l_person_id per_all_people_f.person_id%type;
9390: l_rslt_object_version_number number(15);
9391:
9392: --
9393: -- Bug : 1857685