199: gmd_debug.put_line('Approvers Found');
200: END IF;
201:
202: if(Approver.person_id is null) then
203: select user_name into l_user from fnd_user
204: where user_id=Approver.user_id;
205: else
206: select user_name into l_user from fnd_user
207: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
202: if(Approver.person_id is null) then
203: select user_name into l_user from fnd_user
204: where user_id=Approver.user_id;
205: else
206: select user_name into l_user from fnd_user
207: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
208: end if;
209:
210:
405: /* No Approval Required */
406: P_resultout:='COMPLETE:N';
407: else
408: if(Approver.person_id is null) then
409: select user_name into l_user from fnd_user
410: where user_id=Approver.user_id;
411: else
412: select user_name into l_user from fnd_user
413: where
408: if(Approver.person_id is null) then
409: select user_name into l_user from fnd_user
410: where user_id=Approver.user_id;
411: else
412: select user_name into l_user from fnd_user
413: where
414: user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
415: end if;
416: