DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on FND_USER

Line 1377: FROM HZ_PARTIES party, fnd_user fu

1373: -- Commented the above query as eng_security_people_v in engestd.odf
1374: -- will not be available in DMF patchset
1375: /*SELECT party.PARTY_ID
1376: INTO req_id
1377: FROM HZ_PARTIES party, fnd_user fu
1378: WHERE fu.user_id = l_User_Id
1379: AND to_char(fu.employee_id) = party.person_identifier
1380: AND ROWNUM = 1;*/
1381: -- Modified query for performance bug 4240438

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