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.UMX_LOGIN_HELP_PVT dependencies on HZ_PARTIES

Line 215: FROM hz_parties hzp, fnd_user fu

211: AND nvl(end_date, sysdate + 1) > sysdate;
212:
213: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
214: SELECT hzp.email_address
215: FROM hz_parties hzp, fnd_user fu
216: WHERE hzp.party_id = fu.person_party_id
217: AND fu.user_name = p_user_name;
218:
219: begin

Line 291: FROM hz_parties p, fnd_user fu

287:
288:
289: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
290: SELECT fu.user_name
291: FROM hz_parties p, fnd_user fu
292: WHERE p.party_id = fu.person_party_id
293: AND p.email_address = p_email_address;
294:
295:

Line 365: FROM hz_parties p, fnd_user fu

361:
362:
363: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
364: SELECT fu.user_name
365: FROM hz_parties p, fnd_user fu
366: WHERE p.party_id = fu.person_party_id
367: AND UPPER(p.email_address) = UPPER(p_email_address);
368:
369: