DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on PER_ALL_PEOPLE_F

Line 262: from per_all_people_f

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

Line 1095: from per_all_people_f per

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