APPS.RRS_SITE_UTILS dependencies on RRS_LOC_TRADE_AREA_GRPS

Line 143: rrs_loc_trade_area_grps rltag,

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
147: rltag.is_primary_flag = 'Y' and

Line 163: rrs_loc_trade_area_grps rltag,

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
167: rgta.group_id = p_tag_code and

Line 184: rrs_loc_trade_area_grps rltag,

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
188: where

Line 207: rrs_loc_trade_area_grps rltag,

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
211: where