858:
859: SELECT
860: attr_group_disp_name INTO l_attr_display_name
861: FROM
862: ego_obj_attr_grp_assocs_v
863: WHERE association_id = p_association_id;
864:
865: --Check if there are any entries for in EGO_PAGE_ENTRIES_V
866:
867: -- Bug - 5068278 , avoided Full Table Scans
868: SELECT COUNT(*) INTO l_count
869: FROM EGO_PAGE_ENTRIES_B A,
870: FND_OBJECTS B ,
871: EGO_OBJ_ATTR_GRP_ASSOCS_V C
872: WHERE C.ASSOCIATION_ID = A.ASSOCIATION_ID
873: AND A.ASSOCIATION_ID = p_association_id
874: AND C.OBJECT_ID = B.OBJECT_ID
875: AND B.OBJ_NAME = 'EGO_ITEM' ;