APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on PER_ALL_PEOPLE_F

Line 265: from per_all_people_f

261: --
262:
263: cursor c_bg_id is
264: select business_group_id
265: from per_all_people_f
266: where person_id = p_person_id
267: and p_effective_date between effective_start_date and effective_end_date;
268:
269: l_pdp c_pdp%rowtype;

Line 1098: from per_all_people_f per

1094: -- CESD = Max (PESD, Min(RSD, EFD))
1095: --
1096: cursor c_per_efsd is
1097: select per.effective_start_date
1098: from per_all_people_f per
1099: where per.person_id = p_person_id
1100: order by effective_start_date asc ;
1101: --
1102: -- By default, effective date is initally passed on from SS into