APPS.OM_SETUP_VALID_PKG dependencies on FND_USER

Line 232: FROM FND_USER_RESP_GROUPS;

228: resp_id NUMBER;
229: resps SARRAY:= SARRAY();
230: CURSOR resp_cursor IS
231: SELECT USER_ID, RESPONSIBILITY_ID
232: FROM FND_USER_RESP_GROUPS;
233: resp resp_cursor%ROWTYPE;
234: indx NUMBER;
235: BEGIN
236: indx := 1;

Line 288: FROM FND_USER;

284: /* FUNCTION getUsers RETURN NUMARRAY AS
285: users NUMARRAY:= NUMARRAY();
286: CURSOR usr_cursor IS
287: SELECT USER_ID
288: FROM FND_USER;
289: usr usr_cursor%ROWTYPE;
290: indx NUMBER;
291: BEGIN
292: indx := 1;

Line 318: FROM FND_USER

314: username VARCHAR2(255);
315: BEGIN
316: SELECT USER_NAME
317: INTO username
318: FROM FND_USER
319: WHERE USER_ID = userid;
320: RETURN username;
321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN

Line 729: FROM FND_USER_RESP_GROUPS

725: resp_id NUMBER;
726: BEGIN
727: SELECT RESPONSIBILITY_ID
728: INTO resp_id
729: FROM FND_USER_RESP_GROUPS
730: WHERE USER_ID = user_id
731: AND RESPONSIBILITY_APPLICATION_ID = 660
732: AND ROWNUM < 2;
733: RETURN TRUE;

Line 922: FROM FND_USER_RESP_GROUPS

918: P_VALUE VARCHAR2
919: ) RETURN SARRAY AS
920: CURSOR ALL_USER(resp_id IN NUMBER) IS
921: SELECT USER_ID
922: FROM FND_USER_RESP_GROUPS
923: WHERE RESPONSIBILITY_ID=resp_id;
924: ctr NUMBER := 1;
925: j NUMBER := 1;
926: user_all ALL_USER%ROWTYPE;