APPS.GMD_QMDSC dependencies on PER_ALL_PEOPLE

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

134: if(Approver.person_id is null) then
135: select user_name into l_user from fnd_user
136: where user_id=Approver.user_id;
137: else
138: /*select user_name into l_user from fnd_user a,per_all_people b
139: where
140: b.person_id=Approver.person_id and
141: a.employee_id is not null and
142: a.employee_id = b.person_id; */

Line 149: and exists (select 1 from per_all_people where person_id = Approver.person_id);

145: -- Commented the above select statement and added new select to fix performance issues
146: select user_name into l_user from fnd_user a
147: where a.employee_id = Approver.person_id
148: and a.employee_id is not null
149: and exists (select 1 from per_all_people where person_id = Approver.person_id);
150:
151: end if;
152:
153: /* Set the User Attribute */