APPS.RRS_SITE_INFO dependencies on RRS_SITES_TL

Line 166: name rrs_sites_tl.name%TYPE

162: party_name hz_parties.party_name%Type,
163: property_location_id rrs_sites_b.property_location_id%TYPE,
164: start_date rrs_sites_b.start_date%TYPE,
165: end_date rrs_sites_b.end_date%TYPE,
166: name rrs_sites_tl.name%TYPE
167: );
168:
169: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
170: l_site_header_details local_rrs_site_header_tab;

Line 240: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2

236: RSB.END_DATE,
237: RST.NAME
238: Bulk Collect
239: INTO l_site_header_details
240: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2
241: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP
242: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num
243: and RSB.SITE_ID = RST.SITE_ID
244: and LKUP1.LOOKUP_TYPE = 'RRS_SITE_TYPE'