124:
125: BEGIN -- Fetch user name
126: select user_name
127: into l_user_name
128: from fnd_user
129: where person_party_id = p_person_party_id
130: and nvl(end_date,sysdate) >= sysdate;
131: EXCEPTION
132: WHEN TOO_MANY_ROWS THEN
140: END IF;
141:
142: select user_name
143: into l_user_name
144: from fnd_user
145: where person_party_id = p_person_party_id
146: and nvl(end_date,sysdate) >= sysdate
147: and rownum=1;
148: