APPS.BEN_DETERMINE_ELIGIBILITY dependencies on PER_ALL_PEOPLE_F

Line 15: ,p_per_row in out NOCOPY per_all_people_f%rowtype

11: --
12: procedure determine_elig_prfls
13: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
14: ,p_par_elig_state in out NOCOPY ben_comp_obj_filter.g_par_elig_state_rec
15: ,p_per_row in out NOCOPY per_all_people_f%rowtype
16: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
17: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
18: ,p_appasg_row in out NOCOPY ben_person_object.g_cache_ass_table
19: ,p_empasgast_row in out NOCOPY per_assignment_status_types%rowtype

Line 109: l_per_rec per_all_people_f%rowtype;

105: l_elig_rl_cnt number := 0;
106: l_ctr_count number := 0;
107: l_jurisdiction_code varchar2(30);
108: --
109: l_per_rec per_all_people_f%rowtype;
110: l_ass_rec per_all_assignments_f%rowtype;
111: l_loc_rec hr_locations_all%rowtype;
112: l_ctr_rec per_contact_relationships%rowtype;
113: l_hsc_rec hr_soft_coding_keyflex%rowtype;

Line 129: per_all_people_f ppf

125: --END FONM
126: cursor c_get_contacts is
127: select ctr.*
128: from per_contact_relationships ctr,
129: per_all_people_f ppf
130: where ctr.person_id = p_person_id
131: and ctr.personal_flag = 'Y'
132: and ctr.contact_person_id = ppf.person_id
133: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))

Line 144: per_all_people_f ppf

140: --
141: cursor c_get_no_of_contacts is
142: select count(ctr.person_id)
143: from per_contact_relationships ctr,
144: per_all_people_f ppf
145: where ctr.person_id = p_person_id
146: and ctr.personal_flag = 'Y'
147: and ctr.contact_person_id = ppf.person_id
148: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))