APPS.GMD_QMSED dependencies on PER_ALL_PEOPLE

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 386: and exists (select 1 from per_all_people where person_id = Approver.person_id);*/

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:
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);

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 546: and exists (select 1 from per_all_people where person_id = Approver.person_id);

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;
548:
549: /* Set the User Attribute */
550: