APPS.EGO_GROUP_WF_PKG dependencies on EGO_USER_V

Line 59: FROM fnd_grants f, fnd_menus m, fnd_objects o, ego_user_v user1

55: -----------------------------------------------
56: --PERF TUNING :4956096
57: CURSOR c_get_admin_list (cp_group_id IN NUMBER ) IS
58: SELECT user1.user_name, user1.party_id, user1.party_name, f.grantee_key
59: FROM fnd_grants f, fnd_menus m, fnd_objects o, ego_user_v user1
60: WHERE f.instance_pk1_value = to_char(cp_group_id)
61: AND f.start_date <= SYSDATE
62: AND NVL(f.end_date, SYSDATE) >= SYSDATE
63: AND (f.grantee_key like 'HZ_PARTY:%'

Line 286: FROM ego_user_v

282: -- WHERE users.customer_id = parties.party_id
283: -- AND parties.party_id = p_party_id;
284: --PERF TUNINIG :4956096
285: SELECT user_name, party_name
286: FROM ego_user_v
287: WHERE party_id = p_party_id;
288:
289: -- CURSOR get_owner_user_party_names_c (p_group_id NUMBER) IS
290: -- SELECT users.user_name, parties.party_name

Line 1942: FROM ego_user_v

1938: ----------------------------------------------------------------------
1939: -- PERF TUNING :4956096
1940: CURSOR c_get_party_name (cp_user_name IN VARCHAR2) IS
1941: SELECT party_name
1942: FROM ego_user_v
1943: WHERE user_name = cp_user_name;
1944:
1945: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;
1946: l_item_type VARCHAR2(30);