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 FND_USER

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 2532: WHERE fnd_user.EMPLOYEE_ID = hr_employee.PERSON_ID

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
2536: AND hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 2533: AND fnd_user.person_party_id = hr_employee.party_id

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
2536: AND hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'
2537: AND hr_employee.EFFECTIVE_START_DATE <= SYSDATE

Line 2534: AND fnd_user.start_date <= SYSDATE

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
2536: AND hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'
2537: AND hr_employee.EFFECTIVE_START_DATE <= SYSDATE
2538: AND NVL(hr_employee.EFFECTIVE_END_DATE,SYSDATE) >= SYSDATE

Line 2535: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE

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
2536: AND hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'
2537: AND hr_employee.EFFECTIVE_START_DATE <= SYSDATE
2538: AND NVL(hr_employee.EFFECTIVE_END_DATE,SYSDATE) >= SYSDATE
2539: AND NOT EXISTS

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

Line 2618: WHERE fnd_user.employee_id = hr_employee.person_id

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
2622: AND hr_employee.current_employee_flag = 'Y'

Line 2619: AND fnd_user.person_party_id = hr_employee.party_id

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
2622: AND hr_employee.current_employee_flag = 'Y'
2623: AND hr_employee.effective_start_date <= SYSDATE

Line 2620: AND fnd_user.start_date <= SYSDATE

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
2622: AND hr_employee.current_employee_flag = 'Y'
2623: AND hr_employee.effective_start_date <= SYSDATE
2624: AND NVL(hr_employee.effective_end_date,SYSDATE) >= SYSDATE

Line 2621: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE

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
2622: AND hr_employee.current_employee_flag = 'Y'
2623: AND hr_employee.effective_start_date <= SYSDATE
2624: AND NVL(hr_employee.effective_end_date,SYSDATE) >= SYSDATE
2625: AND NOT EXISTS