APPS.RRS_SITE_INFO dependencies on RRS_SITES_TL

Line 170: name rrs_sites_tl.name%TYPE

166: party_name hz_parties.party_name%Type,
167: property_location_id rrs_sites_b.property_location_id%TYPE,
168: start_date rrs_sites_b.start_date%TYPE,
169: end_date rrs_sites_b.end_date%TYPE,
170: name rrs_sites_tl.name%TYPE
171: );
172:
173: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
174: l_site_header_details local_rrs_site_header_tab;

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

244: RSB.END_DATE,
245: RST.NAME
246: Bulk Collect
247: INTO l_site_header_details
248: From RRS_SITES_B RSB, RRS_SITES_TL RST , rrs_lookups_v lkup1,rrs_lookups_v lkup2
249: ,rrs_lookups_v lkup3 , BOM_CALENDARS BC, HZ_PARTIES HP
250: WHERE RSB.SITE_IDENTIFICATION_NUMBER = p_site_id_num
251: and RSB.SITE_ID = RST.SITE_ID
252: and LKUP1.LOOKUP_TYPE = 'RRS_SITE_TYPE'

Line 1287: parent_site_name rrs_sites_tl.name%Type

1283:
1284: TYPE local_rrs_site_hierar_rec is RECORD (
1285: hierarchy_name rrs_site_groups_tl.name%TYPE,
1286: hierarchy_node_name rrs_site_group_nodes_tl.name%TYPE,
1287: parent_site_name rrs_sites_tl.name%Type
1288: );
1289: Type local_rrs_site_hierar_tab is table of local_rrs_site_hierar_rec;
1290: l_hierarchy_details local_rrs_site_hierar_tab;
1291: