DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on PER_PEOPLE_F

Line 1366: FROM per_people_f ppf, fnd_user fu

1362: AND to_char(fu.employee_id) = party.person_identifier
1363: AND ROWNUM = 1;*/
1364: -- Modified query for performance bug 4240438
1365: SELECT ppf.party_id INTO req_id
1366: FROM per_people_f ppf, fnd_user fu
1367: WHERE fu.user_id = l_User_Id
1368: AND fu.employee_id = ppf.person_id
1369: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date; -- Fix for 4293553
1370: EXCEPTION