APPS.RRS_SITE_UTILS dependencies on RRS_GROUP_TRADE_AREAS

Line 132: l_trade_area_number_code rrs_group_trade_areas.trade_area_number_code%type;

128: p_y_coord IN NUMBER DEFAULT NULL
129: )
130: IS
131: l_geometry RRS_SITE_TMP.geometry%type;
132: l_trade_area_number_code rrs_group_trade_areas.trade_area_number_code%type;
133: --Bug 4903895 - Start Code
134: /*
135: CURSOR primary_tag_cursor IS
136: select

Line 142: rrs_group_trade_areas rgta,

138: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
139: rgta.trade_area_number_code
140: from
141: rrs_trade_area_groups_b rtag,
142: rrs_group_trade_areas rgta,
143: rrs_loc_trade_area_grps rltag,
144: hz_locations l,
145: rrs_sites_b rs
146: where

Line 162: rrs_group_trade_areas rgta,

158: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
159: rgta.trade_area_number_code
160: from
161: rrs_trade_area_groups_b rtag,
162: rrs_group_trade_areas rgta,
163: rrs_loc_trade_area_grps rltag,
164: hz_locations l,
165: rrs_sites_b rs
166: where

Line 183: rrs_group_trade_areas rgta,

179: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
180: rgta.trade_area_number_code
181: from
182: rrs_trade_area_groups_b rtag,
183: rrs_group_trade_areas rgta,
184: rrs_loc_trade_area_grps rltag,
185: hz_locations l,
186: rrs_sites_b rs,
187: rrs_site_tmp tmp

Line 206: rrs_group_trade_areas rgta,

202: DECODE(rtag.unit_of_measure_code,'KILOMETER',rgta.outer_bound*1000,'MILE',rgta.outer_bound*1609.344), 10),
203: rgta.trade_area_number_code
204: from
205: rrs_trade_area_groups_b rtag,
206: rrs_group_trade_areas rgta,
207: rrs_loc_trade_area_grps rltag,
208: hz_locations l,
209: rrs_sites_b rs,
210: rrs_site_tmp tmp