DBA Data[Home] [Help]

APPS.CZ_UTILS dependencies on ALL_USERS

Line 219: sUSER ALL_USERS.USERNAME%TYPE;

215: END;
216: END;
217: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
218: PROCEDURE GET_USER_NAME (forSPXID IN NUMBER, outNAME OUT NOCOPY VARCHAR2) IS
219: sUSER ALL_USERS.USERNAME%TYPE;
220: sFND FND_USER.USER_NAME%TYPE;
221:
222: BEGIN
223: IF forSPXID<0 THEN

Line 225: FROM ALL_USERS

221:
222: BEGIN
223: IF forSPXID<0 THEN
224: SELECT DISTINCT USERNAME INTO sUSER
225: FROM ALL_USERS
226: WHERE USER_ID=-forSPXID;
227: outNAME:=sUSER;
228: ELSE
229: SELECT USER_NAME INTO sFND