APPS.ENG_REVISED_ITEM_UTIL dependencies on PER_PEOPLE_F

Line 1383: FROM per_people_f ppf, fnd_user fu

1379: AND to_char(fu.employee_id) = party.person_identifier
1380: AND ROWNUM = 1;*/
1381: -- Modified query for performance bug 4240438
1382: SELECT ppf.party_id INTO req_id
1383: FROM per_people_f ppf, fnd_user fu
1384: WHERE fu.user_id = l_User_Id
1385: AND fu.employee_id = ppf.person_id
1386: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date; -- Fix for 4293553
1387: EXCEPTION