APPS.RRS_SITE_UTILS dependencies on RRS_SITES_B

Line 28: rrs_sites_b rs

24: l_state,
25: l_postal_code
26: from
27: hz_locations hl,
28: rrs_sites_b rs
29: where
30: rs.location_id = hl.location_id
31: and rs.site_id = p_site_id;
32:

Line 64: from rrs_sites_b rs

60:
61: BEGIN
62: select rs.site_identification_number
63: into l_ret
64: from rrs_sites_b rs
65: where rs.site_id = p_site_id;
66:
67: RETURN l_ret;
68: END GET_SITE_DISPLAY_NAME;

Line 145: rrs_sites_b rs

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
148: rtag.group_id = rltag.group_id and
149: rgta.group_id = rltag.group_id and

Line 165: rrs_sites_b rs

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
168: rtag.group_id = rltag.group_id and
169: rgta.group_id = rltag.group_id and

Line 186: rrs_sites_b rs,

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
189: rltag.is_primary_flag = 'Y' and
190: rtag.group_id = rltag.group_id and

Line 209: rrs_sites_b rs,

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
212: rgta.group_id = p_tag_code and
213: rtag.group_id = rltag.group_id and

Line 334: ,rrs_sites_b site

330: IS
331: /*CURSOR c_location_type_code(c_site_id NUMBER) IS
332: SELECT pn.location_type_lookup_code
333: FROM pn_locations_all pn
334: ,rrs_sites_b site
335: WHERE site.property_location_id = pn.location_id
336: AND site.site_id = c_site_id ;
337:
338: CURSOR c_building(c_site_id NUMBER) IS

Line 341: ,rrs_sites_b site

337:
338: CURSOR c_building(c_site_id NUMBER) IS
339: SELECT pn.building
340: FROM pn_locations_all pn
341: ,rrs_sites_b site
342: WHERE site.property_location_id = pn.location_id
343: AND site.site_id = c_site_id ;
344:
345: CURSOR c_floor(c_site_id NUMBER) IS

Line 348: ,rrs_sites_b site

344:
345: CURSOR c_floor(c_site_id NUMBER) IS
346: SELECT pn.floor
347: FROM pn_locations_all pn
348: ,rrs_sites_b site
349: WHERE site.property_location_id = pn.location_id
350: AND site.site_id = c_site_id ;
351:
352: CURSOR c_office(c_site_id NUMBER) IS

Line 355: ,rrs_sites_b site

351:
352: CURSOR c_office(c_site_id NUMBER) IS
353: SELECT pn.office
354: FROM pn_locations_all pn
355: ,rrs_sites_b site
356: WHERE site.property_location_id = pn.location_id
357: AND site.site_id = c_site_id ;
358:
359: l_location_type_lookup_code pn_locations_all.location_type_lookup_code%TYPE ;

Line 384: ,rrs_sites_b site

380: RETURN l_location_name ;*/
381: CURSOR c_location_code(c_site_id NUMBER) IS
382: SELECT pn.location_code
383: FROM pn_locations_all pn
384: ,rrs_sites_b site
385: WHERE site.property_location_id = pn.location_id
386: AND site.site_id = c_site_id ;
387:
388: l_location_code pn_locations_all.location_code%TYPE ;