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

Line 374: select user_name into l_user from fnd_user

370: return;
371: end if;
372:
373: if(Approver.person_id is null) then
374: select user_name into l_user from fnd_user
375: where user_id=Approver.user_id;
376: else
377: /* select user_name into l_user from fnd_user a,per_all_people b
378: where b.person_id=Approver.person_id and

Line 377: /* select user_name into l_user from fnd_user a,per_all_people b

373: if(Approver.person_id is null) then
374: select user_name into l_user from fnd_user
375: where user_id=Approver.user_id;
376: else
377: /* select user_name into l_user from fnd_user a,per_all_people b
378: where b.person_id=Approver.person_id and
379: a.employee_id is not null and
380: a.employee_id = b.person_id; */
381:

Line 383: /*select user_name into l_user from fnd_user a

379: a.employee_id is not null and
380: a.employee_id = b.person_id; */
381:
382: -- Rewritten the above query as part of performance bug# 5221298
383: /*select user_name into l_user from fnd_user a
384: where a.employee_id = Approver.person_id
385: and a.employee_id is not null
386: and exists (select 1 from per_all_people where person_id = Approver.person_id);*/
387:

Line 389: select user_name into l_user from fnd_user

385: and a.employee_id is not null
386: and exists (select 1 from per_all_people where person_id = Approver.person_id);*/
387:
388: -- RLNAGARA B5714223 Replaced the above query with the below query.
389: select user_name into l_user from fnd_user
390: where user_id=ame_util.personidtouserid (approver.person_id);
391:
392: end if;
393:

Line 533: select user_name into l_user from fnd_user

529: /* No Approval Required */
530: P_resultout:='COMPLETE:N';
531: else
532: if(Approver.person_id is null) then
533: select user_name into l_user from fnd_user
534: where user_id=Approver.user_id;
535: else
536: /* select user_name into l_user from fnd_user a,per_all_people b
537: where

Line 536: /* select user_name into l_user from fnd_user a,per_all_people b

532: if(Approver.person_id is null) then
533: select user_name into l_user from fnd_user
534: where user_id=Approver.user_id;
535: else
536: /* select user_name into l_user from fnd_user a,per_all_people b
537: where
538: b.person_id=Approver.person_id and
539: a.employee_id is not null and
540: a.employee_id = b.person_id; */

Line 543: select user_name into l_user from fnd_user a

539: a.employee_id is not null and
540: a.employee_id = b.person_id; */
541:
542: -- Rewritten the above query as part of performance bug# 5221298
543: select user_name into l_user from fnd_user a
544: where a.employee_id = Approver.person_id
545: and a.employee_id is not null
546: and exists (select 1 from per_all_people where person_id = Approver.person_id);
547: end if;