DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_API dependencies on PER_ALL_PEOPLE_F

Line 180: from per_all_people_f per

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

Line 245: from per_all_people_f

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