APPS.GMD_QMDSC dependencies on FND_USER

Line 135: select user_name into l_user from fnd_user

131: /* No Approval Required */
132: P_resultout:='COMPLETE:N';
133: else
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

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 146: select user_name into l_user from fnd_user a

142: a.employee_id = b.person_id; */
143:
144: -- Bug# 5226352
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: