APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on PER_ALL_PEOPLE_F

Line 2607: from per_all_people_f per

2603: l_dob_found boolean;
2604: --
2605: cursor c_date_of_birth is
2606: select per.date_of_birth
2607: from per_all_people_f per
2608: where per.person_id = p_person_id
2609: and per.business_group_id = p_business_group_id
2610: and p_effective_date between per.effective_start_date
2611: and per.effective_end_date;

Line 2809: from per_all_people_f per

2805: l_legid_found boolean;
2806: --
2807: cursor c_leg_id is
2808: select per.national_identifier
2809: from per_all_people_f per
2810: where per.person_id = p_person_id
2811: and per.business_group_id = p_business_group_id
2812: and p_effective_date between
2813: per.effective_start_date and per.effective_end_date;

Line 7281: from per_all_people_f per,

7277: (trunc
7278: (months_between(p_effective_date, per.date_of_birth))/ 12
7279: ) bnf_age,
7280: pb.ttee_person_id
7281: from per_all_people_f per,
7282: ben_pl_bnf_f pb
7283: where pb.pl_bnf_id = p_pl_bnf_id
7284: and per.person_id = pb.bnf_person_id
7285: and per.business_group_id = p_business_group_id

Line 8742: from per_all_people_f per,

8738: select pcr.contact_type,
8739: plb.bnf_person_id,
8740: plb.pl_bnf_id,
8741: pl.pl_id
8742: from per_all_people_f per,
8743: per_contact_relationships pcr,
8744: ben_pl_f pl,
8745: ben_pl_bnf_f plb,
8746: ben_prtt_enrt_rslt_f pen,

Line 8781: from per_all_people_f per,

8777: select 'O',
8778: plb.organization_id,
8779: plb.pl_bnf_id,
8780: pl.pl_id
8781: from per_all_people_f per,
8782: hr_all_organization_units o,
8783: ben_pl_f pl,
8784: ben_pl_bnf_f plb,
8785: ben_prtt_enrt_rslt_f pen,

Line 9304: l_person_id per_all_people_f.person_id%type;

9300:
9301: l_pcp_actn_warning boolean := FALSE;
9302: l_pcp_dpnt_actn_warning boolean := FALSE;
9303: l_pln_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
9304: l_person_id per_all_people_f.person_id%type;
9305: l_rslt_object_version_number number(15);
9306:
9307: --
9308: -- Bug : 1857685