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_LOCATIONS_PKG dependencies on PER_PEOPLE_F

Line 55: from per_people_f ppf

51: p_designated_receiver in out nocopy varchar2) is
52: --
53: cursor c1 is
54: select ppf.full_name
55: from per_people_f ppf
56: , fnd_sessions ses
57: where ses.session_id = userenv('sessionid')
58: and person_id = p_designated_receiver_id
59: and ses.effective_date

Line 65: from per_people_f ppf

61: and ppf.effective_end_date;
62: --
63: cursor c2 is
64: select ppf.full_name
65: from per_people_f ppf
66: where ppf.person_id = p_designated_receiver_id
67: and ppf.effective_start_date = (
68: select min(ppf2.effective_start_date)
69: from per_people_f ppf2

Line 69: from per_people_f ppf2

65: from per_people_f ppf
66: where ppf.person_id = p_designated_receiver_id
67: and ppf.effective_start_date = (
68: select min(ppf2.effective_start_date)
69: from per_people_f ppf2
70: where ppf2.person_id = ppf.person_id );
71: --
72: begin
73: --