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

Line 566: l_user_name fnd_user.user_name%type;

562: l_event Varchar2(40);
563: l_datetrack_mode Varchar2(40);
564: l_assignment_id Number;
565: l_assignment_id_can Varchar2(40);
566: l_user_name fnd_user.user_name%type;
567: l_old_position_id_can Varchar2(40);
568: l_old_position_id hr_all_positions_f.position_id%type;
569:
570:

Line 769: , fnd_user usr

765: cursor get_user_name (p_person_id in number,p_effective_start_date in date,p_old_position_id in number)
766: is
767: SELECT usr.user_name,usr.start_date,end_date
768: FROM per_all_assignments_f ass
769: , fnd_user usr
770: WHERE ass.person_id = usr.employee_id
771: and ass.person_id = p_person_id
772: --AND p_effective_start_date BETWEEN usr.start_date AND nvl (usr.end_date, p_effective_start_date)
773: AND ass.position_id IS NOT NULL

Line 1052: FND_USER USR,

1048: NULL FAX,
1049: 'ACTIVE' STATUS
1050: from PER_ALL_ASSIGNMENTS_F ASS,
1051: PER_ALL_POSITIONS POS,
1052: FND_USER USR,
1053: PER_ALL_PEOPLE_F PER,
1054: FND_TERRITORIES FNDT,
1055: FND_LANGUAGES FNDL,
1056: HR_LOCATIONS HRL