APPS.RRS_SITE_INFO dependencies on RRS_TRADE_AREAS

Line 1090: from rrs_trade_areas_ext_vl a,rrs_trade_areas b

1086: AND fo.obj_name in ( 'RRS_TRADE_AREA')
1087: AND eoab.attr_group_id = ext.attr_group_id
1088: AND eoab.classification_code IN
1089: ( select b.group_id
1090: from rrs_trade_areas_ext_vl a,rrs_trade_areas b
1091: where b.location_id = l_location_id
1092: and a.trade_area_id = b.trade_area_id
1093: );
1094:

Line 1098: from rrs_trade_areas

1094:
1095: select trade_area_id
1096: BULK COLLECT
1097: INTO l_trade_area_ids
1098: from rrs_trade_areas
1099: where location_id = l_location_id;
1100:
1101:
1102: elsif (p_page_name is not null) then

Line 1116: from rrs_trade_areas_ext_vl a

1112: AND DISPLAY_NAME = p_page_name
1113: AND CLASSIFICATION_CODE IN
1114: (
1115: select b.group_id
1116: from rrs_trade_areas_ext_vl a
1117: ,rrs_trade_areas b
1118: where b.location_id = l_location_id
1119: and a.trade_area_id = b.trade_area_id
1120: )

Line 1117: ,rrs_trade_areas b

1113: AND CLASSIFICATION_CODE IN
1114: (
1115: select b.group_id
1116: from rrs_trade_areas_ext_vl a
1117: ,rrs_trade_areas b
1118: where b.location_id = l_location_id
1119: and a.trade_area_id = b.trade_area_id
1120: )
1121: ORDER BY SEQUENCE;

Line 1141: from rrs_trade_areas

1137:
1138: select trade_area_id
1139: BULK COLLECT
1140: INTO l_trade_area_ids
1141: from rrs_trade_areas
1142: where location_id = l_location_id
1143: and group_id in
1144: (
1145: select classification_code