APPS.EGO_GROUP_WF_PKG dependencies on FND_GRANTS

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 947: -- Removed as the owner is now obtained from fnd_grants

943: CURSOR get_item_key_id_c IS
944: SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
945: FROM dual;
946: --
947: -- Removed as the owner is now obtained from fnd_grants
948: --
949: -- CURSOR c_get_owner_name(cp_group_id NUMBER) IS
950: -- SELECT users.user_name
951: -- FROM fnd_user users

Line 2549: l_grantee_key fnd_grants.grantee_key%TYPE;

2545: l_dup_user NUMBER := 0;
2546: l_api_name VARCHAR2(30) := 'SET_WF_ROLES';
2547: l_role_name VARCHAR2(360) ;
2548: l_role_display_name VARCHAR2(100);
2549: l_grantee_key fnd_grants.grantee_key%TYPE;
2550: l_user_name fnd_user.user_name%TYPE;
2551: l_party_id hz_parties.party_id%TYPE;
2552: l_group_id hz_parties.party_id%TYPE;
2553: