DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PVT dependencies on EGO_USER_V

Line 163: FROM ego_user_v

159: G_SESSION_LANG := USERENV('LANG');
160: BEGIN
161: SELECT party_id, party_name
162: INTO G_PARTY_ID, G_PARTY_NAME
163: FROM ego_user_v
164: WHERE USER_ID = G_USER_ID;
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: -- 3600938 sometimes user_id is not being retrieved

Line 170: FROM ego_user_v

166: WHEN NO_DATA_FOUND THEN
167: -- 3600938 sometimes user_id is not being retrieved
168: SELECT party_id, party_name, user_id
169: INTO G_PARTY_ID, G_PARTY_NAME, G_USER_ID
170: FROM ego_user_v
171: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
172: END;
173: --
174: -- error handler parameters