APPS.RRS_SITE_INFO dependencies on EGO_OBJ_AG_ASSOCS_B

Line 554: attr_grp_id ego_obj_ag_assocs_b.attr_grp_id%Type

550: l_display_name varchar2(240);
551:
552: -- l_attributes_row_table x_attributes_row_table;
553: /*Type site_entity_rec is Record(
554: attr_grp_id ego_obj_ag_assocs_b.attr_grp_id%Type
555: );
556: Type site_entity_tab is table of site_entity_rec;
557: l_entity_details site_entity_tab;
558: */

Line 606: FROM ego_obj_ag_assocs_b eoab

602:
603: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
604: BULK COLLECT
605: INTO l_attr_grp_name
606: FROM ego_obj_ag_assocs_b eoab
607: ,fnd_objects fo
608: ,EGO_FND_DSC_FLX_CTX_EXT ext
609: WHERE eoab.object_id = fo.object_id
610: AND fo.obj_name in ( 'RRS_SITE')

Line 625: FROM ego_obj_ag_assocs_b eoab

621:
622: SELECT eoab.attr_group_id
623: BULK COLLECT
624: INTO l_attr_grp_id
625: FROM ego_obj_ag_assocs_b eoab
626: ,fnd_objects fo
627: WHERE eoab.object_id = fo.object_id
628: AND fo.obj_name in ( 'RRS_SITE')
629: AND eoab.classification_code IN

Line 877: FROM ego_obj_ag_assocs_b eoab

873:
874: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
875: BULK COLLECT
876: INTO l_attr_grp_name
877: FROM ego_obj_ag_assocs_b eoab
878: ,fnd_objects fo
879: ,EGO_FND_DSC_FLX_CTX_EXT ext
880: WHERE eoab.object_id = fo.object_id
881: AND fo.obj_name in ( 'RRS_LOCATION')

Line 1100: FROM ego_obj_ag_assocs_b eoab

1096:
1097: SELECT distinct ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
1098: BULK COLLECT
1099: INTO l_attr_grp_name
1100: FROM ego_obj_ag_assocs_b eoab
1101: ,fnd_objects fo
1102: ,EGO_FND_DSC_FLX_CTX_EXT ext
1103: WHERE eoab.object_id = fo.object_id
1104: AND fo.obj_name in ( 'RRS_TRADE_AREA')