APPS.EGO_DOM_SECURITY_PVT dependencies on FND_GRANTS

Line 127: FROM fnd_grants GRANTS,

123: GRANTS.grantee_key grantee_key,
124: menus.Menu_name role_name,
125: menus.user_menu_name role_display_name,
126: menus.menu_id menu_id
127: FROM fnd_grants GRANTS,
128: fnd_objects OBJECTS,
129: fnd_menus_vl MENUS
130: WHERE OBJECTS.object_id = GRANTS.object_id
131: AND OBJECTS.obj_name=cp_entity_name

Line 327: 'FROM fnd_grants grants, ' ||

323: 'grantee_person_company.party_id company_id, ' ||
324: 'grantee_person_company.party_name company_name, ' ||
325: 'trunc(grants.start_date) start_date , ' ||
326: 'trunc(grants.end_date) end_date ' ||
327: 'FROM fnd_grants grants, ' ||
328: 'hz_parties grantee_person, ' ||
329: 'hz_parties grantee_person_company, ' ||
330: 'hz_relationships grantee_person_company_rel, ' ||
331: 'fnd_menus_tl granted_menu, ' ||

Line 407: 'FROM fnd_grants grants, ' ||

403: '-1 company_id, ' ||
404: 'null company_name, ' ||
405: 'trunc(grants.start_date) start_date , ' ||
406: 'trunc(grants.end_date) end_date ' ||
407: 'FROM fnd_grants grants, ' ||
408: 'hz_parties grantee_group, ' ||
409: 'fnd_menus_tl granted_menu, ' ||
410: 'fnd_menus granted_menu_data, ' ||
411: 'fnd_objects obj ' ||

Line 424: 'FROM fnd_grants f, ' ||

420: 'OR EXISTS ' ||
421: '( ' ||
422: 'SELECT ' ||
423: ' ''X'' ' ||
424: 'FROM fnd_grants f, ' ||
425: 'fnd_menus m, ' ||
426: 'fnd_objects o ' ||
427: 'WHERE f.instance_pk1_value = to_char(grantee_group.party_id) ' ||
428: 'AND f.start_date <= SYSDATE ' ||

Line 490: 'FROM fnd_grants grants, ' ||

486: 'grantee_company.party_id company_id, ' ||
487: 'grantee_company.party_name company_name, ' ||
488: 'trunc(grants.start_date) start_date , ' ||
489: 'trunc(grants.end_date) end_date ' ||
490: 'FROM fnd_grants grants, ' ||
491: 'hz_parties grantee_company, ' ||
492: 'fnd_menus_tl granted_menu, ' ||
493: 'fnd_menus granted_menu_data, ' ||
494: 'fnd_objects obj ' ||

Line 543: 'FROM fnd_grants grants, ' ||

539: '-1 company_id, ' ||
540: 'null company_name, ' ||
541: 'trunc(grants.start_date) start_date, ' ||
542: 'trunc(grants.end_date) end_date ' ||
543: 'FROM fnd_grants grants, ' ||
544: 'hz_parties grantee_global, ' ||
545: 'fnd_menus_tl granted_menu, ' ||
546: 'fnd_menus granted_menu_data, ' ||
547: 'fnd_objects obj ' ||

Line 578: ' FROM fnd_grants grants, ' ||

574: ' null company_id , ' ||
575: ' '''' COMPANY_NAME , ' ||
576: ' trunc(grants.start_date) start_date , ' ||
577: ' trunc(grants.end_date) end_date ' ||
578: ' FROM fnd_grants grants, ' ||
579: ' fnd_menus granted_menu, ' ||
580: ' fnd_objects obj, ' ||
581: ' hz_parties grantee_person, ' ||
582: ' fnd_menus_tl granted_menu_tl ' ||

Line 626: ' fnd_grants grants , ' ||

622: ' '''' COMPANY_NAME , ' ||
623: ' trunc(grants.start_date) start_date , ' ||
624: ' trunc(grants.end_date) end_date ' ||
625: ' FROM ' ||
626: ' fnd_grants grants , ' ||
627: ' fnd_menus granted_menu, ' ||
628: ' fnd_objects obj , ' ||
629: ' hz_parties member , ' ||
630: ' hz_relationships member_group , ' ||

Line 791: FROM fnd_grants grants,

787: SELECT DISTINCT
788: sets.instance_set_id instance_set_id ,
789: sets.instance_set_name instance_set_name,
790: sets.predicate predicate
791: FROM fnd_grants grants,
792: fnd_object_instance_sets sets,
793: fnd_objects obj
794: WHERE obj.obj_name = p_obj_name
795: AND grants.object_id = obj.object_id