APPS.EGO_UPLOAD_PUB dependencies on EGO_USER_V

Line 279: from ego_user_v

275: -- if creating catalog category, then create roles as well
276: BEGIN
277: SELECT user_id, party_id
278: INTO l_user_id, l_party_id
279: from ego_user_v
280: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);
281: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
282: l_party_id := -1000;
283: END IF;

Line 289: from ego_user_v

285: WHEN OTHERS THEN
286: -- defaulting to MFG
287: SELECT user_id, party_id
288: INTO l_user_id, l_party_id
289: from ego_user_v
290: where user_name = 'MFG';
291: -- l_user_id := 1068;
292: -- l_party_id := 6530;
293: END;