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.

[Home] [Help]

APPS.EGO_PARTY_PUB dependencies on FND_USER

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

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

Line 2535: AND fnd_user.person_party_id = hr_employee.party_id

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
2538: AND (hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'
2539: OR

Line 2536: AND fnd_user.start_date <= SYSDATE

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
2538: AND (hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'
2539: OR
2540: (fnd_profile.value('HR_TREAT_CWK_AS_EMP') = 'Y' AND

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

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
2538: AND (hr_employee.CURRENT_EMPLOYEE_FLAG = 'Y'
2539: OR
2540: (fnd_profile.value('HR_TREAT_CWK_AS_EMP') = 'Y' AND
2541: hr_employee.current_npw_flag = 'Y')

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

Line 2626: WHERE fnd_user.employee_id = hr_employee.person_id

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

Line 2627: AND fnd_user.person_party_id = hr_employee.party_id

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
2630: AND (hr_employee.current_employee_flag = 'Y'
2631: OR

Line 2628: AND fnd_user.start_date <= SYSDATE

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
2630: AND (hr_employee.current_employee_flag = 'Y'
2631: OR
2632: (fnd_profile.value('HR_TREAT_CWK_AS_EMP') = 'Y' AND

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

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
2630: AND (hr_employee.current_employee_flag = 'Y'
2631: OR
2632: (fnd_profile.value('HR_TREAT_CWK_AS_EMP') = 'Y' AND
2633: hr_employee.current_npw_flag = 'Y')