DBA Data[Home] [Help]

APPS.EGO_GROUP_WF_PKG dependencies on FND_MENUS

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:%'