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 2533: FROM fnd_user fnd_user, per_all_people_f hr_employee

2529: -- Bug 9652538 - modified query to also pick up contingent workers
2530: -- based on the profile option 'HR_TREAT_CWK_AS_EMP'
2531: SELECT hr_employee.party_id person_id
2532: INTO l_party_id
2533: FROM fnd_user fnd_user, per_all_people_f hr_employee
2534: WHERE fnd_user.EMPLOYEE_ID = hr_employee.PERSON_ID
2535: AND fnd_user.person_party_id = hr_employee.party_id
2536: AND fnd_user.start_date <= SYSDATE
2537: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE

Line 2625: FROM fnd_user fnd_user, per_all_people_f hr_employee

2621: -- Bug 9652538 - modified query to also pick up contingent workers
2622: -- based on the profile option 'HR_TREAT_CWK_AS_EMP'
2623: CURSOR internal_users_wc IS
2624: SELECT hr_employee.party_id person_id
2625: FROM fnd_user fnd_user, per_all_people_f hr_employee
2626: WHERE fnd_user.employee_id = hr_employee.person_id
2627: AND fnd_user.person_party_id = hr_employee.party_id
2628: AND fnd_user.start_date <= SYSDATE
2629: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE