51: BEGIN
52:
53: SELECT USER_ID
54: INTO l_user_id
55: FROM FND_USER
56: WHERE USER_NAME = p_user_name;
57:
58: SELECT APPLICATION_ID
59: INTO l_application_id
164:
165:
166: SELECT USER_ID
167: INTO l_user_id
168: FROM FND_USER
169: WHERE USER_NAME = p_user_name;
170:
171:
172: if (fnd_global.user_id = -1) then
520:
521:
522: SELECT USER_ID
523: INTO l_user_id
524: FROM FND_USER
525: WHERE USER_NAME = p_user_name;
526:
527:
528: select DECODE( A2M_DBLINK,