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.HR_WPM_MASS_APR_PUSH dependencies on FND_USER

Line 3124: FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl

3120: IS
3121: SELECT pa.plan_id, pa.appraiser_person_id, pa.object_version_number,
3122: usr.user_name, pa.main_appraiser_id, pa.appraisee_person_id,
3123: ppl.full_name
3124: FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl
3125: WHERE appraisal_id = p_appraisal_id
3126: AND ppl.person_id = usr.employee_id(+)
3127: AND ppl.person_id = pa.main_appraiser_id
3128: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date

Line 3171: l_user_name fnd_user.user_name%TYPE;

3167: l_appraiser_person_id NUMBER;
3168: l_appraisal_id NUMBER;
3169: blockedactivityid NUMBER;
3170: l_instance_label VARCHAR2 (100);
3171: l_user_name fnd_user.user_name%TYPE;
3172: l_main_appraiser_id per_all_people_f.person_id%TYPE;
3173: l_appraisee_person_id per_all_people_f.person_id%TYPE;
3174: l_full_name per_all_people_f.full_name%TYPE;
3175: l_item_type VARCHAR2 (30);