eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_PARTY_PUB dependencies on PER_ALL_PEOPLE_F

Line 2531: FROM fnd_user fnd_user, per_all_people_f hr_employee

2527: BEGIN
2528:
2529: SELECT hr_employee.party_id person_id
2530: INTO l_party_id
2531: FROM fnd_user fnd_user, per_all_people_f hr_employee
2532: WHERE fnd_user.EMPLOYEE_ID = hr_employee.PERSON_ID
2533: AND fnd_user.person_party_id = hr_employee.party_id
2534: AND fnd_user.start_date <= SYSDATE
2535: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE

Line 2617: FROM fnd_user fnd_user, per_all_people_f hr_employee

2613: --changed query to remove full table scan. Bug#4429524
2614: --modified the query to reduce the cost bug 4895705
2615: CURSOR internal_users_wc IS
2616: SELECT hr_employee.party_id person_id
2617: FROM fnd_user fnd_user, per_all_people_f hr_employee
2618: WHERE fnd_user.employee_id = hr_employee.person_id
2619: AND fnd_user.person_party_id = hr_employee.party_id
2620: AND fnd_user.start_date <= SYSDATE
2621: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE