DBA Data[Home] [Help]

APPS.AMW_SECURITY_PUB dependencies on FND_OBJECTS

Line 168: from fnd_objects

164: v_object_id := g_obj_id_cache; /* If we have it cached, use value */
165: else /* not cached, hit db */
166: select object_id
167: into v_object_id
168: from fnd_objects
169: where obj_name=p_object_name;
170:
171: /* Store in cache */
172: g_obj_id_cache := v_object_id;

Line 319: FROM fnd_objects

315: ,pk3_column_type
316: ,pk4_column_type
317: ,pk5_column_type
318: , database_object_name
319: FROM fnd_objects
320: WHERE obj_name=p_object_name ;
321: begin
322:
323: if(x_table_alias is NULL) then

Line 572: fnd_objects obj,

568: cp_end_date DATE) IS
569:
570: SELECT 'X'
571: FROM fnd_grants grants,
572: fnd_objects obj,
573: fnd_menus menus
574: WHERE grants.grantee_key=cp_grantee_key
575: AND grants.grantee_type=cp_grantee_type
576: AND grants.menu_id=menus.menu_id