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