APPS.RRS_SITE_INFO dependencies on RRS_TRADE_AREAS

Line 1108: from rrs_trade_areas_ext_vl a,rrs_trade_areas b

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:

Line 1116: from rrs_trade_areas

1112:
1113: select trade_area_id
1114: BULK COLLECT
1115: INTO l_trade_area_ids
1116: from rrs_trade_areas
1117: where location_id = l_location_id;
1118:
1119:
1120: elsif (p_page_name is not null) then

Line 1134: from rrs_trade_areas_ext_vl a

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: )

Line 1135: ,rrs_trade_areas b

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: )
1139: ORDER BY SEQUENCE;

Line 1159: from rrs_trade_areas

1155:
1156: select trade_area_id
1157: BULK COLLECT
1158: INTO l_trade_area_ids
1159: from rrs_trade_areas
1160: where location_id = l_location_id
1161: and group_id in
1162: (
1163: select classification_code