DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on PER_ALL_PEOPLE_F

Line 318: from per_all_people_f papf

314:
315: Begin
316: select papf.full_name
317: into l_name
318: from per_all_people_f papf
319: where papf.person_id = p_employee_id and
320: papf.effective_start_date <= l_date and
321: papf.effective_end_date > l_date;
322: Exception when others then

Line 330: from per_all_people_f papf

326: if( l_name is null ) then
327: Begin
328: select papf.full_name
329: into l_name
330: from per_all_people_f papf
331: where papf.person_id = p_employee_id
332: and rownum = 1;
333: Exception when others then
334: l_name := null;