1104: AND fo.obj_name in ( 'RRS_TRADE_AREA')
1105: AND eoab.attr_group_id = ext.attr_group_id
1106: AND eoab.classification_code IN
1107: ( select b.group_id
1108: from rrs_trade_areas_ext_vl a,rrs_trade_areas b
1109: where b.location_id = l_location_id
1110: and a.trade_area_id = b.trade_area_id
1111: );
1112:
1130: AND DISPLAY_NAME = p_page_name
1131: AND CLASSIFICATION_CODE IN
1132: (
1133: select b.group_id
1134: from rrs_trade_areas_ext_vl a
1135: ,rrs_trade_areas b
1136: where b.location_id = l_location_id
1137: and a.trade_area_id = b.trade_area_id
1138: )