APPS.EGO_UPLOAD_PUB dependencies on EGO_USER_V

Line 402: from ego_user_v

398: -- if creating catalog category, then create roles as well
399: BEGIN
400: SELECT user_id, party_id
401: INTO l_user_id, l_party_id
402: from ego_user_v
403: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);
404: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
405: l_party_id := -1000;
406: END IF;

Line 412: from ego_user_v

408: WHEN OTHERS THEN
409: -- defaulting to MFG
410: SELECT user_id, party_id
411: INTO l_user_id, l_party_id
412: from ego_user_v
413: where user_name = 'MFG';
414: -- l_user_id := 1068;
415: -- l_party_id := 6530;
416: END;