DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_API dependencies on PER_ALL_PEOPLE_F

Line 181: from per_all_people_f per

177: ,c_eff_date in date
178: )
179: is
180: select per.business_group_id
181: from per_all_people_f per
182: where per.person_id = c_person_id
183: and c_eff_date between per.effective_start_date
184: and per.effective_end_date;
185: --

Line 246: from per_all_people_f

242: and l_effective_date <= nvl(inactive_date,l_effective_date);
243: --
244: cursor c_supervisor is
245: select null
246: from per_all_people_f
247: where person_id = l_supervisor_id
248: and current_employee_flag = 'Y'
249: and l_effective_date
250: between effective_start_date