APPS.BEN_EVALUATE_ELIG_CONC dependencies on PER_ALL_PEOPLE_F

Line 102: from per_all_people_f ppf

98: l_parm c_parameter%rowtype;
99: --
100: cursor c_person is
101: select ppf.*
102: from per_all_people_f ppf
103: where ppf.person_id = l_person_id
104: and business_group_id = p_business_group_id
105: and nvl(l_effective_date,trunc(sysdate))
106: between ppf.effective_start_date

Line 109: l_per_rec per_all_people_f%rowtype;

105: and nvl(l_effective_date,trunc(sysdate))
106: between ppf.effective_start_date
107: and ppf.effective_end_date;
108:
109: l_per_rec per_all_people_f%rowtype;
110: l_per_dummy_rec per_all_people_f%rowtype;
111:
112: cursor c_ebo is
113: select elig_obj_id

Line 110: l_per_dummy_rec per_all_people_f%rowtype;

106: between ppf.effective_start_date
107: and ppf.effective_end_date;
108:
109: l_per_rec per_all_people_f%rowtype;
110: l_per_dummy_rec per_all_people_f%rowtype;
111:
112: cursor c_ebo is
113: select elig_obj_id
114: from ben_elig_obj_f

Line 484: from per_all_people_f ppf

480: -- Cursors declaration.
481: --
482: cursor c_person is
483: select ppf.person_id
484: from per_all_people_f ppf
485: where ppf.business_group_id = p_business_group_id
486: and l_effective_date between ppf.effective_start_date
487: and ppf.effective_end_date
488: and (p_person_id is null or

Line 512: from per_all_people_f pap

508: and paa.primary_flag = 'Y'
509: and paa.location_id = p_location_id))
510: and (p_benfts_grp_id is null
511: or exists (select null
512: from per_all_people_f pap
513: where pap.person_id = ppf.person_id
514: and pap.business_group_id = ppf.business_group_id
515: and l_effective_date
516: between pap.effective_start_date